Database Blog

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

Oracle Cloud Shell – Configuration and its uses

Oracle Cloud Shell is web based terminal access from Oracle Cloud console. It is free to use and provides access to Linux shell. Cloud shell is a small VM running…

Read More

The register extract of goldengate failed with OCI Error 959

Issue : The register extract of goldengate failed with OCI Error 959 Observation : Cannot register extract in Goldengate . It abends with the OCI Error 959. Reason : ORA-00959:…

Read More

The extract of the goldengate failed with the error : Error “OGG-00665 OCI Error executing fetch for TABLE (status = 1031-ORA-01031: insufficient privileges)”

Issue : The extract of the goldengate failed with the error : Error “OGG-00665 OCI Error executing fetch for TABLE (status = 1031-ORA-01031: insufficient privileges)” Observation : Goldengate Extract abends…

Read More

12.2 Rapid Install Fails On Installing Web Tier Utilities With Error “Fatal Error: TXK Install Service”

APPLIES TO: Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2] SYMPTOMS: 12.2 Rapid-Install fails while Installing Web Tier Utilities with below error: ++++++++++++++++++++++++++++++++++++++ Installing Web Tier…

Read More