We recently installed EBS 12.2 for use with VCP/ASCP/Demantra suite of products.
while we had quite a few issues, I am mentioning about this particular issue here.
We were trying to apply patch 19549533 on our brand new ebs installation.
To apply the patch, these are the steps:
adop phase=prepare
adop phase=apply patches=19549533
adop phase=finalize
adop phase=cutover
When I was trying to run adop phase=prepare , it failed with below error:
---------
SETUP VALIDATION is in progress. This may take few minutes to complete.
[UNEXPECTED]Error occurred while executing "perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs1/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -patchctxfile=/u01/install/APPS/fs2/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/35/prepare_20160222_134702/EBSQA_ovpxvcpqa -promptmsg=hide"
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ovpxvcpqa
Log file: /u01/install/APPS/fs_ne/EBSapps/log/adop/35/adop_20160222_134702.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 = 1 (Fail)
------------
Same error is seen, when I try to run adop phase=fs_clone
I did not find any relevant hits in google or metalink. While taking a closer look at the log files, one of the logfiles said the following:
-----
[root@ovpxvcpqa EBSQA_ovpxvcpqa]# tail -f ADOPValidations_Mon_Feb_22_13_34_11_2016.log
Nodes with context files in the FND_OAM_CONTEXT_FILES table on both run and patch file systems: NONE
Nodes without context files in the FND_OAM_CONTEXT_FILES table on either/or run and patch file systems: ovpxvcpqa
Corrective Action:
- If the run file system context file for a node is missing, run AutoConfig on the run file system of that node to sync with the value with the database.
- If the patch file system context file of a node is missing, run AutoConfig on the patch file system of that node with the -syncctx option as follows to sync with the value with the database.
On UNIX:
sh
/bin/adconfig.sh contextfile= -syncctx
On Windows:
\bin\adconfig.cmd contextfile= -syncctx
Exiting validations as further tests will break.
^C
[root@ovpxvcpqa EBSQA_ovpxvcpqa]#
--------
I was sure that the run file system was fine, but was doubtful about the patch file system.
Anyways, i decided to run the below command on both run and patch file systems:
sh
/bin/adconfig.sh contextfile= -syncctx
For run file system:
source the run file system using
. /u01/install/APPS/EBSapps.env run
[oracle@ovpxvcpqa EBSQA_ovpxvcpqa]$ sh $AD_TOP/bin/adconfig.sh contextfile=/u01/install/APPS/fs1/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -syncctx
Enter the APPS user password:
The log file for this session is located at: /u01/install/APPS/fs1/inst/apps/EBSQA_ovpxvcpqa/admin/log/02221207/adconfig.log
Option specified : Synchronize context file
Only context file synchronization will be performed
Classpath : /u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/APPS/fs1/EBSapps/comn/java/classes
Using ContextFile : /u01/install/APPS/fs1/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml
Synchronizing the context file ......COMPLETED
AutoConfig completed successfully.
[oracle@ovpxvcpqa EBSQA_ovpxvcpqa]$
For patch file system:
Source the patch file system by running:
. /u01/install/APPS/EBSapps.env patch
[oracle@ovpxvcpqa EBSQA_ovpxvcpqa]$ sh $AD_TOP/bin/adconfig.sh contextfile=/u01/install/APPS/fs2/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -syncctx
Enter the APPS user password:
The log file for this session is located at: /u01/install/APPS/fs2/inst/apps/EBSQA_ovpxvcpqa/admin/log/02221207/adconfig.log
Option specified : Synchronize context file
Only context file synchronization will be performed
Classpath : /u01/install/APPS/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/APPS/fs2/EBSapps/comn/java/classes
Using ContextFile : /u01/install/APPS/fs2/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml
Synchronizing the context file ......COMPLETED
AutoConfig completed successfully.
[oracle@ovpxvcpqa EBSQA_ovpxvcpqa]$
After completing this , I re-ran
adop phase=fs_clone and it fails with the below error:
There is already a session which is incomplete. Details are:
Session Id : 35
Prepare phase status : NOT COMPLETED
Apply phase status : NOT COMPLETED
Cutover phase status : NOT COMPLETED
Abort phase status : NOT COMPLETED
Session status : FAILED
Will continue with previous session
[UNEXPECTED]FS clone cannot be called while a patching cycle is active
To resolve this, I had to run the
adop phase=abort
Then do the cleanup using :
adop phase=cleanup cleanup_mode=standard
Then I re-ran
adop phase=fs_clone
This time , it went past the point where it errored out previously :) but soon failed with below error
----
Validation Results for Node: ovpxvcpqa
---------------------------------------
[ERROR]: At least one Oracle inventory check has failed.
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.
Some validations failed, please check /u01/install/APPS/fs_ne/EBSapps/log/adop/36/fs_clone_20160222_140723/EBSQA_ovpxvcpqa/ADOPValidations_Mon_Feb_22_14_07_46_2016.log
=========================== END OF VALIDATION REPORT ======================
[UNEXPECTED]Error occurred while executing "perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs1/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -patchctxfile=/u01/install/APPS/fs2/inst/apps/EBSQA_ovpxvcpqa/appl/admin/EBSQA_ovpxvcpqa.xml -phase=fs_clone -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/36/fs_clone_20160222_140723/EBSQA_ovpxvcpqa -promptmsg=hide"
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ovpxvcpqa
Log file: /u01/install/APPS/fs_ne/EBSapps/log/adop/36/adop_20160222_140723.log
-------
So from the error , it was evident that there is an issue with oraInventory.
Then , I following log file also pointed that the issue is apparently with
/u01/install/APPS/fs1/EBSapps/10.1.2 Oracle home.
/u01/install/APPS/fs_ne/EBSapps/log/adop/36/fs_clone_20160222_140723/EBSQA_ovpxvcpqa/ADOPValidations_Mon_Feb_22_14_07_46_2016.log:
----------------------------------------------------------------------------------------------------------------------------------
Lines #(191-195):
====================================
ERROR: /u01/install/APPS/fs1/EBSapps/10.1.2 is not registered in the inventory
Corrective Action: Provide the location of a valid inventory file. If you believe the inventory is valid, you may want to attach the /u01/install/APPS/fs1/EBSapps/10.1.2.
[oracle@ovpxvcpqa APPS]$
Ok . Good. So how do we fix this inventory issue.
Upon researching, there is a very good note on metalink, which descibes about , what homes to expect on a 12.2 ebs environment and how to re-attach them.
R12.2 How To Re-attach Oracle Homes To The Central Inventory (Doc ID 1586607.1)
using the above note I attached the problem OH.
/u01/install/APPS/fs1/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/install/APPS/fs1/EBSapps/10.1.2" ORACLE_HOME_NAME="OH582721206"
/u01/install/APPS/fs2/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/install/APPS/fs2/EBSapps/10.1.2" ORACLE_HOME_NAME="OH165974127"
Excellent!!!
Now I again re-run the adop phase=fs_clone
This time , it seems to be running successfully ...
and yeaahhh it completed successfully...
----
#############################################################
END: FSCloneApplyFSCloneApply - appsTier Finished at Mon Feb 22 15:30:10 CST 2016
Status: Completed Successfully
Total Time Taken : 35.950 mins
#############################################################
END: doClone..
CLONE APPLY COMPLETED SUCCESSFULLY
----
Hope this helps some one.