APPS DBA

June 23, 2017 APP-PAY-06882: Assertion failure detected at location py3vntsetup:2

Accounts PayablesAPPS DBAErrors/Workarounds-APErrors/Workarounds-ApplicationsOracle Functional

ERROR

Error while Payroll processing:-

HR_6882_HRPROC_ASSERT
LOCATION py3vntsetup:2
APP-PAY-06882: Assertion failure detected at location py3vntsetup:2.

(more…)

June 12, 2017 Unable to locate ‘make’ utility in path

APPS DBAErrors/Workarounds-Applications

ERROR

Unable to locate ‘make’ utility in path

Issue :

bash-3.2$ perl adcfgclone.pl dbTechStack

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.7.1202010.2

Enter the APPS password :

Checking for make…
Unable to locate ‘make’ utility in path
Checking for ld…
Unable to locate ‘ld’ utility in path
Checking for ar…
Unable to locate ‘ar’ utility in path
Unable to locate all utilities with system path.

PATH = /u01/apps/Test/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/bin
WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above

SOLUTION

1.export PATH=/usr/ccs/bin:$PATH

2. Now, Run perl adcfgclone.pl dbTechStack

May 31, 2017 How to restart ADOP from FAILED session – R12.2 Online Patching

APPS DBAInstallations/Configurations-Applications

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)
$

May 31, 2017 Oracle APPLICATION R12 Log File Locations

APPS DBAInstallations/Configurations-Applications

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