Database Blog

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

Ways 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 More

12C : 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 More

12C : 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 More

12.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

R12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request nnnnn’

E-Business Suite R12 Concurrent Processing, Output Post Processing related issues Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request…

Read More

ORA-12152 “Unable To Send Break Message” on Connection

When trying to login to the database from a client(Toad, SQL Developer) when using a Cisco GSS and a CSM (Content Switch Module) the connection fails to complete or fails…

Read More

Error: “Unable to Connect” Oracle Apex Access Issue

Recently we had install the Oracle Apex and installation done successfully and access via local system Oracle Apex running perfectly but while we access in remote then we had faced…

Read More

How to resolve ORA-01994: GRANT failed: password file missing or disabled

ERROR: ORA-01994: GRANT failed: password file missing or disabled SOLUTION: 1)Log in as the same user who owns the file $ORACLE_HOME and create the password file as follows. $orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID…

Read More