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 MoreThe 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 MoreThe 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 More12.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 MoreERROR: 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 MoreGather 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 MoreWays To find whether the module is installed or not in Oracle Applications
We have 3 ways to find out if a module is installed in oracle apps 1 We can run the following script cd $AD_TOP/sql/adutconf.sql In this script, there is a…
Read More12C : Unified Audit Trial was not captured during successful Login and Failures
From oracle 12.1, unified audit trail has been introduced. To enable this audit_trail parameter should be set to none. However we observed that even though ORA_LOGON_FAILURES was available in AUDIT_UNIFIED_ENABLED_POLICIES…
Read More12C : SQL Tuning Advisor is not Running even though its enabled
Recently I faced a new issue in 12C. In automated maintenance task, sql tuning advisor was already enabled. but its still showing not running. Even I have validated dba_autotask_operation, it…
Read More12.2 E-Business Suite startCD 50 Install Fails with Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed Cannot install Web Tier Utilities
APPLIES TO: Oracle Applications DBA - Version 12.2.5 to 12.2.5 [Release 12.2] Oracle Applications Manager - Version 12.2.5 and later Information in this document applies to any platform. SYMPTOMS: E-Business…
Read More