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

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_75.dmp” ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory SOLUTION: In a RAC database, if you are taking export with parallel option and the datapump […]

 PROBLEM: Sql query failed with ORA-02394: exceeded session limit on IO usage error. SQL> select count(*) from dba_objects; select count(*) from dba_objects * ERROR at line 1: ORA-02394: exceeded session limit on IO usage, you are being logged off SOLUTION: This error comes, when the sessions exceeds the value of LOGICAL_READS_PER_SESSION defined in user profile. To […]