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 existed for that user: SELECT count(*) as connections,username FROM v$session where username=’&USER_NAME’ GROUP BY username; SQL> SELECT count(*) as connections,username FROM v$session where username=’&USER_NAME’ GROUP BY username; Enter value for […]

PROBLEM: While importing dump file, got error as ORA-39358: Export dump file version 12.1.0.2.0 not compatible with target version 11.2.0.4.0 . SOLUTION: 1. Check the compatible parameter of both source and target database. SOURCE DB: SQL>>]show parameter compatible NAME TYPE VALUE ———————————— ———– —————————- compatible string 12.1.0.2.0 noncdb_compatible boolean FALSE TARGET DB: SQL> show parameter […]

PROBLEM: After successful db upgrade, I tried to update the compatible parameter and restart the database. I got below error.   SQL> alter system set compatible=”12.2.0.1″ scope=spfile; System altered. SQL> startup force ORACLE instance started. Total System Global Area 1.4663E+10 bytes Fixed Size 15697000 bytes Variable Size 8455723928 bytes Database Buffers 6140461056 bytes Redo Buffers […]

PROBLEM: While applying a patch to oracle binary using opatch utility, got below error. $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/12.1.0/dbtest Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/12.1.0/dbtest/oraInst.loc OPatch version : 12.1.0.1.10 OUI version : 12.1.0.2.0 Log file location : /oracle/app/oracle/product/12.1.0/dbtest/cfgtoollogs/opatch/opatch2017-02-16_15-30-33PM_1.log Verifying […]

PROBLEM: While making a datafile offline, got below error.   SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline; ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline * ERROR at line 1: ORA-01145: offline immediate disallowed unless media recovery enabled   SOLUTION: To make a datafile offline, archive mode need to be enabled.   SQL> archive log list Database log mode […]

PROBLEM: While registering database to rman catalog, getting below error. RMAN> register database; RMAN-00571: ================================================ RMAN-00569: ========== ERROR MESSAGE STACK FOLLOWS ========== RMAN-00571: ================================================ RMAN-03009: failure of register command on default channel at 12/08/2010 13:03:21 RMAN-20002: target database already registered in recovery catalog   SOLUTION: 1. Check dbid of the database. SQL> select dbid from […]

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 the database_role of STANDBY sql> SELECT database_role FROM v$database; DATABASE_ROLE —————- PRIMARY Convert to standby database sql> Alter database convert to physical standby; Now mount again: sql> […]

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′,’dbaclassa.txt’,’w’); utl_file.fclose(file_open); end; / 2 3 4 5 6 7 declare * ERROR at line 1: ORA-29280: invalid directory path ORA-06512: at “SYS.UTL_FILE”, line 41 ORA-06512: at “SYS.UTL_FILE”, line 478 ORA-06512: at […]

PROBLEM: While taking RMAN backup in oracle RAC database, getting below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of resync command on default channel at 12/10/2016 22:16:52 ORA-00245: control file backup failed; target is likely on a local file system Recovery Manager complete. No lines match the search […]

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 altered. — Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file […]