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 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 MoreR12 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 MoreORA-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 MoreError: “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 MoreHow 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 MoreORA-30012: undo tablespace ‘UNDOTBS’ does not exist or of wrong type
ERROR: ORA-30012: undo tablespace ‘UNDOTBS’ does not exist or of wrong type. CAUSE: The parameter UNDO_MANAGEMENT is set to AUTO but the undo_tablespace does not exist or is not of…
Read MoreCannot Start Oracle HTTP Server on Privileged Port (80/443) on Solaris 9
APPLIES TO: Oracle HTTP Server - Version 9.0.2 to 10.1.3.0.0 [Release 9iAS to AS10gR3] Oracle Solaris on SPARC (64-bit) Oracle Solaris on SPARC (32-bit) Web Cache - Version: 9.0.2 to…
Read More