Apps DBA Workshop

In one of our csutomer Environment during the Oracle E-Business suite siwtchover activity we encounted the following error during exeuction of autoconfig. adcvmlog.xml renamed to /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/PROD_ERPAPPSdr01/06081214/adcvmlog.xml.06081215 [CVM Error Report] The following report lists errors encountered during CVM Phase /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.sh 1 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1 AutoConfig execution completed on Sat Jun 8 12:15:08 2024 Time taken for AutoConfig execution to complete : 0 mins 23 secs Cause: UTL_FILE_DIR is obselete with Database 19c and hence autoconfig is not able to set/locate the correct utl_file_dir Solution: Need to set utl_file_directory as per the new tech stack tools and once the locations are set to valid directories autoconfig will be completed successfully. Script "txkCfgUtlfileDir.pl" will be used with thr...

Oracle EBS R12.1.3 clone configuration script failing while configuring config tools. This issue is reported on OracleEBS running on IBM-AIX 6.1. Environment details: OS Version             => IBM-AIX 6.1 (64-Bit) EBS version           => R12,1.3 Database Version   => 11.2.0.1 Error Stack while running adcfgclone.pl on appsTier: Setting LIBPATH to /oratest/R12_app/apps_st/comn/clone/oui/lib/aix Beginning application tier Apply - Mon Feb 2 11:11:30 2022 /oratest/R12_app/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /oratest/R12_app/apps_st/comn/clone/jlib/xmlparserv2.jar:/oratest/R12_app/apps_st/comn/clone/jlib/ojdbc14.jar:/oratest/R12_app/apps_st/comn/clone/jlib/java:/oratest/R12_app/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/ewt3.jar:/oratest/R12_app/apps_st/comn/clone/jlib/oui/sha...

I received an Incident from one our customer that all standard concurrent requests in EBS R12.1.3  are not completing and its continuously in status "Running Normal" forever. This issue was reported on of their recently cloned TEST/UAT Environment. Environment details: EBS : 12.1.3 DB   : 12.1.0.2 OS   : IBM-AIX -6.1 (64-bit) If we check the log file for any standard concurrent request there is no error reported. Below is the concurrent manager logfile for Active users: Cocurrent log:  --------------------  +---------------------------------------------------------------------------+  Application Object Library: Version : 12.0.0  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.  FNDSCURS module: Active Users  +---------------------------------------------------------------------------+  Current system time is 30-OCT-2021 16:25:07  +----------------------------------------------------...

I received  an Incident from one of our customer that they are not able to apply patch on 10.1.2 ( Developer) Oracle Home for their recently cloned EBS R12 Instance. The command "opatch lsinventory is working fine when trying to apply the actual patch then its failing for "MISSING_COMPONENT : oracle.developer.reports.core, 10.1.2.3.0". Though component is included in the Inventory. Output from opatch lsinventory command: [oradev@TESTERP[/oradev]# opatch lsinventory Oracle Interim Patch Installer version 1.0.0.0.57 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home : /oradev/R12_app/apps/tech_st/10.1.2 Oracle Home Inventory : /oradev/R12_app/apps/tech_st/...

After configuring new clone in R12.1.3 when i was trying to run adautoconfig.sh script on dbTier then it completing with errors. In autoconfig logfile error stack: Connected. Checking for existence of the ACL .... DECLARE * ERROR at line 1: ORA-04031: unable to allocate 2032 bytes of shared memory ("shared pool","XDbD/PLZ01TcHgNAgAIIegtw==","qmxlu subheap","qmichdlArrayImg") ORA-06512: at line 16 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options txkcreateACL.sh: exiting with status 1   Cause: The configured shared_pool size in initialization parameter file is only 400 MB. Solution: => Increase shared_pool size 1000 MB => Bounce database => Re-run autoconfig This time it should complete successfully. bash-3.00$ adautocfg.sh Enter the APPS user password: The log file for this ses...

This article illustrates how to run "Purge Inactive Sessions" concurrent program in Oracle E-Business suite R12.1 This program will purge all session which are not active. "Purge Inactive Sessions" concurrent program is not included in request group of  system administrator responsibility. So first we need to add this request to system administrator responsibility request group. Navigation: login as sysadmin >  System Administrator > Security > Responsibility > Request - Here search for Group "System Administrator" - Add concurrent program "Purge Inactive Sessions" - save  - Submit new request "Purge Inactive Sessions""   - After successful completion of this request then check no. of records in table icx_sessions.  Hope helps :) Thanks for reading. regards, X A H E E R