Database Blog

ORA-4045 Error During Recompilation/Revalidation Of SYS.DBMS_STANDARD

APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.8 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…

Read More

Utlrp.sql results to “Warning: XDB Now Invalid, Could Not Find Xdbconfig”

APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.1.0.1 [Release 10.2 to 12.1] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud…

Read More

ORA-02082: a loopback database link must have a connection qualifier

ORA-02082: a loopback database link must have a connection qualifier Such error occurs when there is a db link which is a loop back database link i.e. points to itself…

Read More

Fix for ORA-19505: failed to identify file in RMAN

Fix — ORA-19505: failed to identify file in RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch00 channel at 01/17/2011…

Read More

ORA-65086: cannot open/close the pluggable database

solution: ORA-65086: cannot open/close the pluggable database — Unplug a pluggable database SQL> ALTER PLUGGABLE DATABASE VELDB close immediate; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE VELDB UNPLUG INTO ‘/u01/DB/bkp_pdb/VELDB.xml’;…

Read More

OC4J Configuration issue… OC4J_DBConsole_ not found.

I am trying to start EM on my newly created database, while starting EM, getting failed with OC4J Configuration issue… while diagnosed there is no OC4J_DBConsole_localhost directory exist in ORACLE_HOME.…

Read More

Autoconfig Issues seen after a Clone

After Completion of oracle clone , faced issue while running autoconfig. ERROR : ——– ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at…

Read More

Corrupt Block alert in Alert Log

Error : ======= Bad header found during buffer read Data in bad block: type: 2 format: 2 rdba: 0x21008dd0 last change scn: 0x0006.12114f8e seq: 0x37 flg: 0x04 spare1: 0x0 spare2:…

Read More

Autoconfig errors on adgentns.pl ORA-01400: cannot insert NULL into FND_APPS_SYSTEM.CSI_NUMBER

APPLIES TO: Oracle Applications DBA - Version 12.0.0 to 12.1.3 [Release 12 to 12.1] SYMPTOMS: On application Release 12 When attempting to run autoconfig on APPS Tier, the following error…

Read More

XDB Now Invalid Could Not Find Xdbconfig after applying DBPSU

APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…

Read More