Database Blog

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

ERROR: URL Validation Failed. The Error Could Have Been Caused Through The Use Of The Browser’s Naviation

  APPLIES TO: Oracle HRMS (US) - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2] SYMPTOMS: When trying to open either the 'Disclose Veteran Status' or the 'Disclose Disability Status'…

Read More

Gather Stats ORA-0000: normal, successful completion

ERROR: Gather Stats ORA-0000: normal, successful completion SOLUTION: Check to see what records will be backed up on the wf_queue_temp_jms_table backup table: set linesize 155; set pagesize 200; set verify…

Read More