ORA-

ORA-02394: exceeded session limit on IO usage

 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...

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

PROBLEM: While connecting to the database, getting error: SQL> connect test9/test9 ERROR: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit SOLUTION: 1. Check how many sessions were already ...

ORA-01145: offline immediate disallowed unless media recovery enabled

PROBLEM: While making a datafile offline, got below error.   SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline; ALTER database datafile ‘/export/home/orac...

RMAN-20002: target database already registered in recovery catalog

PROBLEM: While registering database to rman catalog, getting below error. RMAN> register database; RMAN-00571: ================================================ RMAN-00569: ========== ERROR MESSAGE ...

ORA-01665: control file is not a standby control file

PROBLEM: After restoring standby database from RMAN backup, got below error, while mounting standby database,getting below error. ORA-01665: control file is not a standby control file SOLUTION: Check ...

ORA-29280: invalid directory path ORA-06512:”SYS.UTL_FILE”

PROBLEM: One of our procedure using utl_file to create a file and it is failing with below error. SQL> declare file_open utl_file.file_type; begin file_open:=utl_file.fopen(‘TEST1′,R...

ORA-00245: control file backup failed; target is likely on a local file system

PROBLEM: While taking RMAN backup in oracle RAC database, getting below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK F...

ORA-01274: cannot add data file that was originally created as

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace alt...