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

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