ORA-

ORA-65500: could not modify DB_UNIQUE_NAME while duplicating db

PROBLEM: While duplicating a database using RMAN active cloning in RAC database, got below error.(ORA-65500) RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql comman...

ORA-01203: wrong incarnation of this file – wrong creation SCN

PROBLEM: While opening a database, getting the error, ORA-01203: wrong incarnation of this file SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 4 failed ve...

ORA-19588: archived log RECID is no longer valid

PROBLEM: While taking rman backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN...

ORA-01126: database must be mounted in this instance and not open in any instance

PROBLEM: While enabling archive mode in database, got below error. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted in this instance ...

ORA-38760: This database instance failed to turn on flashback database

PROBLEM: While starting the database, got below error. SQL> startup ORACLE instance started. Total System Global Area 1.2549E+10 bytes Fixed Size 12155024 bytes Variable Size 6744442736 bytes Datab...

ORA-38774: cannot disable media recovery – flashback database is enabled

PROBLEM: While disabling archive log mode, got the error – ORA-38774   SQL> alter database noarchivelog; alter database noarchivelog * ERROR at line 1: ORA-38774: cannot disable media r...

ORA-02095: specified initialization parameter cannot be modified

PROBLEM: While modifying the parameter in the database, got below error. SQL> alter system set processes=1000 scope=both; alter system set processes=1000 scope=both * ERROR at line 1: ORA-02095: sp...

ORA-65049: creation of local user or role is not allowed in CDB$ROOT

PROBLEM: While creating a user in root container in the multitenant database, Got error ORA-65049.   SQL> show con_name CON_NAME —————————...

ORA-38856: cannot mark instance UNNAMED_INSTANCE as enabled

PROBLEM: We have restored a standalone database from a rac database, and while doing open resetlog, getting below error. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at...

ORA-31617: unable to open dump file for write

PROBLEM: While taking expdp in rac database, got below error. ORA-31617: unable to open dump file “/dumparea/TEST/asset_75.dmp” for write ORA-19505: failed to identify file “/dumparea/TEST/asset...