Application and database instance are installed on different server. I have requirement to configure DMZ node on new server.
Current version :
Application : R12.2.4
Database: 11.2.0.3
After succefully DMZ configuration, I was getting below error while applying patch.
APPL_TOP is set to /u01/TEST/appltest/fs1/EBSapps/appl
[EVENT] [START 2016/07/28 21:08:25] Checking the DB parameter value
[EVENT] [END 2016/07/28 21:08:26] Checking the DB parameter value
[UNEXPECTED]Unable to find appltop_id for the host test from database
[UNEXPECTED]Invalid appltop id: "".
[UNEXPECTED]Unrecoverable error occured. Exiting the current session.
Log file: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/adop_20160728_210802.log
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
Solutions:
Applicaiton Tier APPL_TOP name should be same across all the applicaiton tier nodes.
1) Change context variable s_atName on Secondary node to Master Application Nodename .
2) Executed autoconfig and bounced services.
3) Then adop is running succefully without any error
[appltest@test ~]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/TEST/appltest/fs1/inst/apps/TEST_test/admin/log/07282117/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/TEST/appltest/fs1/inst/apps/TEST_test
Classpath : /u01/TEST/appltest/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/TEST/appltest/fs1/EBSapps/comn/java/classes
Using Context file : /u01/TEST/appltest/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[appltest@test ~]$ adop phase=cleanup
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Please wait. Validating credentials...
RUN file system context file: /u01/TEST/appltest/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml
PATCH file system context file: /u01/TEST/appltest/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml
Execute SYSTEM command : df /u01/TEST/appltest/fs2
************* Start of session *************
version: 12.2.0
started at: Thu Jul 28 2016 21:19:59
APPL_TOP is set to /u01/TEST/appltest/fs1/EBSapps/appl
[EVENT] [START 2016/07/28 21:20:02] Checking the DB parameter value
[EVENT] [END 2016/07/28 21:20:03] Checking the DB parameter value
[START 2016/07/28 21:20:12] adzdoptl.pl run
ADOP Session ID: 22
Phase: cleanup
Log file: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/22/adop_20160728_211939.log
[START 2016/07/28 21:20:18] cleanup phase
[EVENT] [START 2016/07/28 21:20:20] Performing Cleanup steps
[EVENT] [START 2016/07/28 21:20:21] Running stored CLEANUP actions
Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=16 restart=no abandon=yes defaultsfile=/u01/TEST/appltest/fs1/EBSapps/appl/admin/TEST/adalldefaults.txt patchtop=/u01/TEST/appltest/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
ADPATCH Log directory: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/22/cleanup_20160728_211939/TEST_test/log
[EVENT] [END 2016/07/28 21:20:46] Running stored CLEANUP actions
[START 2016/07/28 21:20:46] Generating All DDL Report
[EVENT] Report: /u01/TEST/appltest/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql
[EVENT] Output: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/22/cleanup_20160728_211939/TEST_test
[END 2016/07/28 21:20:47] Generating All DDL Report
[EVENT] Calling cleanup in STANDARD mode
[WARNING] Cleanup may take a while. Please wait.
[EVENT] [END 2016/07/28 21:20:54] Performing Cleanup steps
[END 2016/07/28 21:20:58] cleanup phase
[EVENT] [START 2016/07/28 21:21:00] Generating AD_ZD_LOGS Report
[EVENT] Report: /u01/TEST/appltest/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
[EVENT] Output: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/22/cleanup_20160728_211939/TEST_test/adzdshowlog.out
[EVENT] [END 2016/07/28 21:21:00] Generating AD_ZD_LOGS Report
[END 2016/07/28 21:21:00] adzdoptl.pl run
adop phase=cleanup - Completed Successfully
Log file: /u01/TEST/appltest/fs_ne/EBSapps/log/adop/22/adop_20160728_211939.log
adop exiting with status = 0 (Success)
[appltest@test ~]$
