While starting DB instance below error coming because of less memory allocated to oracle user at OS level. ORA-27102: out of memory SVR4 Error: 12: Not enough space Additional information: 1671 Additional information: 16106127360 Additional information: 6291456000   Solution: If Oracle DB version is 12.1.0.2 or later use below […]

         While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema   RMAN> connect target sys/oracle#1234@ARCDB connected to target database: ARCDB (DBID=605774762) RMAN> connect catalog RMAN_st/rman@catlogdb connected to recovery catalog database RMAN> create catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS […]

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: […]

           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, […]

                            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 […]

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 […]

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 […]

                        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 […]

                          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 […]

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       […]