Month: May 2017
How to restart ADOP from FAILED session – R12.2 Online Patching
Sometimes during prepare or apply phase of ADOP, some error occurs and you wants to Restart the ADOP session.
Perform following steps.:
$adop phase=abort
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials…
.
.
.
.
.
.
.
.
adop phase=abort – Completed Successfully
Log file: /u01/appltest/fs_ne/EBSapps/log/adop/40/adop_20141257_01987.log
adop exiting with status = 0 (Success)
$
APPS R12 LOG FILE LOCATIONS
Log files are useful in troubleshooting issues in Oracle Applications. Below is the given list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DataBase & Apps Listener and various components in ORACLE Apps R12/11i:
1.Startup/Shutdown Log files for Application Tier in R12
Instance Top is new TOP added in R12
Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…
- $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)
- $INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
- $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
- $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…,oa*,opmn.log)
- $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
- $INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)
2. Cloning Log files in R12
Preclone log files in source instance
Database Tier
- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)
Application Tier
- $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)
Clone log files in target instance
Database Tier
- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
Apps Tier
- $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log
3. Patch related log files in R12
Application Tier adpatch log
- $APPL_TOP/admin/$SID/log/
Developer (Developer/Forms & Reports 10.1.2) Patch
- $ORACLE_HOME/.patch_storage
Web Server (Apache) patch
- $IAS_ORACLE_HOME/.patch_storage
Database Tier opatch log
- $ORACLE_HOME/.patch_storage
4. Autoconfig related log files in R12
Database Tier Autoconfig log :
- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log
Application Tier Autoconfig log –
- $INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log
Autoconfig context file location in R12 –
- $INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml
5. Other log files in R12
1.Database Tier
- Relink Log files :
- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
- Alert Log Files
- $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
- Network Logs :
- $ORACLE_HOME/network/admin/$SID.log
- OUI Inventory Logs :
- $ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
2.Application Tier
- $ORACLE_HOME/j2ee/DevSuite/log
- $ORACLE_HOME/opmn/logs
- $ORACLE_HOME/network/logs
- Tech Stack Patch 10.1.3 (Web/HTTP Server)
- $IAS_ORACLE_HOME/j2ee/forms/logs
- $IAS_ORACLE_HOME/j2ee/oafm/logs
- $IAS_ORACLE_HOME/j2ee/oacore/logs
- $IAS_ORACLE_HOME/opmn/logs$IAS_ORACLE_HOME/network/log
- $INST_TOP/logs/ora/10.1.2
- $INST_TOP/logs/ora/10.1.3
- $INST_TOP/logs/appl/conc/log
- $INST_TOP/logs/appl/admin/log
ERROR
ld.so: object ‘/lib/libcwait.so’ from /etc/ld.so.preload cannot be preloaded: ignored.
Changes
Check compat-libcwait-2.1-1.i386.rpm was installed if yes
SOLUTION
1- Move the “libcwait.so” library from “/usr/lib” to “/lib”.
2. Modify the path given in the file “/etc/ld.so.preload” to point to the new location.
3- Download and Install compat-libcwait-2.1-2 of 64 bit with Root user.
- # rpm -e compat-libcwait-2.1-1.i386
- # rpm -ivh compat-libcwait-2.1-2.x86_64.rpm
NOTE: Download from compat-libcwait-2.1-2
ERROR
$ adcfgclone.pl dbTechStack
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.8
Enter the APPS password :
no linkxlC in /u01/ebs/db/11.2.0/appsutil/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oradev/bin /usr/bin/X11 /sbin /u01/ebs/db/11.2.0/bin .
Checking for make… found – /usr/bin/make
Checking for ld… found – /usr/bin/ld
Checking for linkxlC…
Unable to locate ‘linkxlC’ utility in path
Checking for ar… found – /usr/bin/ar
Unable to locate all utilities with system path.
PATH = /u01/ebs/db/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oradev/bin:/usr/bin/X11:/sbin:/u01/ebs/db/11.2.0/bin:.
WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above
$
SOLUTION
1. Check the linkxlC path in Linux by typing below command.
- $ which linkxlC
/usr/oracle/bin/linkxlC
2.Export Path for linkxlC
- $ export PATH=/usr/oracle/bin:$PATH
3. Run adcfgclone again:
- $ adcfgclone.pl dbTechStack