While adding new datafile, you may face below error. Problem: ALTER TABLESPACE TS_LO_DATA add datafile ‘+DATA’ size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded Solution: Check the db_files parameter in database SQL> show parameter db_files db_files integer 200 — Check the total number of datafiles present: […]
TROUBLESHOOTING
ERROR: No checkpoint table specified for ADD REPLICAT
While adding the replicate, you may get the below error. GGSCI (db75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RC12C/R4 ERROR: No checkpoint table specified for ADD REPLICAT. Solution: Checkpoint table need to be created in the replication side. 1. Login to ggsci with dblogin GGSCI (db75-2) 4> dblogin USERID TEST_GGATE, […]
INS -07003 unexpected error occured while accessing the bean store.
While installing oracle software or goldengate software, you may face below error as . INS -07003 unexpected error occured while accessing the bean store. Solution: Check the value of environmental variable PS1. It may contain some special characters […]
ORA-31623: a job is not attached to this session via the specified handle
PROBLEM: While taking export or import , you may face below issue. oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS directory=TESTDIR table_exists_action=truncate Import: Release 12.1.0.2.0 – Production on Sun Apr 10 14:30:23 2016 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database […]
OGG-01028 Formatting error on: table name
Problem: Goldengate extract may abend with the error OGG-01028 Formatting error on. Source Context : SourceModule : [er.redo.ora] SourceID : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c] SourceFunction : [REDOORA_handle_format_error SourceLine : [8949] 2016-03-30 18:13:34 ERROR OGG-01028 Formatting error on: table name SIEBEL.S_CONTACT, rowid AABjIBAAgAAC/svAAL, XID 12.16.3440952, position (Seqno 7643, RBA 541369824). Invalid numeric data detected. Error converting numeric […]
ERROR OGG-01841 CACHESIZE TOO SMALL:
While starting the extract it may get abend with the error like OGG-01841 CACHESIZE TOO SMALL: . 2016-03-29 11:37:08 ERROR OGG-01841 CACHESIZE TOO SMALL: 64M MINIMUM REQUIRED: 128M VM found: 128M Make sure there is sufficient swap space and make sure CACHEMGR CACHESIZE […]
ORA-600:[kpdbModAdminPasswdInRoot: Not CDB]
While changing the password of internal oracle users in oracle 12c , after it got expired, you may get error as below. ORA-600:[kpdbModAdminPasswdInRoot: Not CDB] SQL> connect system/oracle ERROR: ORA-28001: the password has expired Changing password for system New password: Retype […]
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
You may get ORA-38706: Cannot turn on FLASHBACK DATABASE logging while enabling flashback Problem: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled. solution: Put database in archivelog mode , if not […]
PL/SQL package DBMS_RCVMAN version 12.01.00.01 in RCVCAT database is not current
While connecting to catalog database using RMAN you may get below error like . PL/SQL package DBMS_RCVMAN version 12.01.00.01 in RCVCAT database is not current. Problem: oracle@TEST:~/RMAN/TEST$ rman Recovery Manager: Release 12.1.0.2.0 – Production on Tue Feb 23 09:27:33 2016 Copyright (c) 1982, 2014, Oracle and/or its […]
ORA-20013: DBMS_QOPATCH ran mostly in non install area
While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem: cd /oracle/app/oracle/product/12.1.0.2/dbhome_1/OPatch ./datapatch -verbose SQL Patching tool version 12.2.0.0.0 on Thu Feb 25 11:02:17 2016 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database…OK catcon: […]