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 verification check ORA-01110: data file 4: ‘+B2BCMDB/BMCW/undotbs201.dbf’ ORA-01203: wrong incarnation of this file – wrong creation SCN SOLUTION: To fix this, either you have […]

PROBLEM: While taking rman backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01 ORA-19588: archived log RECID 143154 STAMP 942443843 is no longer valid SOLUTION: This error is mostly because of 2 reasons. 1. Either 2 backups like […]

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 and not open in any instance SOLUTION: The reported error is because changing archive mode need to be done when the database is in mount […]

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 Database Buffers 5771362304 bytes Redo Buffers 21397504 bytes Database mounted. ORA-38760: This database instance failed to turn on flashback database. SOLUTION: 1. Check the alert log: Errors in […]

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 recovery – flashback database is enabled   SOLUTION: The error is because flashback mode is enabled in the database. So before disabling archive log mode, we need to […]

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: specified initialization parameter cannot be modified   SOLUTION: First, we need to check whether the parameter is system modifiable or not.   SQL> select name,VALUE,ISSYS_MODIFIABLE from SYS.V$PARAMETER […]

PROBLEM: While creating a user in root container in the multitenant database, Got error ORA-65049.   SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> create user TESTUSER identified by TESTUSER container=current; create user TESTUSER identified by TESTUSER container=current * ERROR at line 1: ORA-65049: creation of local user or role is not allowed in CDB$ROOT SOLUTION: Normal […]

PROBLEM: While creating a user in root container multitenant database, got the below error. SQL> show con_name CON_NAME —————————- CDB$ROOT SQL> create user TESTUSER identified by TESTUSER; create user TESTUSER identified by TESTUSER * ERROR at line 1: ORA-65096: invalid common user or role name SOLUTION: We can’t create normal users in root containers. We […]

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 line 1: ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled SOLUTION: SQL> alter system set “_no_recovery_through_resetlogs”=TRUE scope=both; System altered. SQL> shutdown immediate; […]

PROBLEM: While importing a dump, getting below error: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ORA-39002: invalid operation ORA-39174: Encryption password must be supplied. SOLUTION: The export dump is an encrypted one. I.e while taking export , ENCRYPTION_PASSWORD has […]