Introduction:-In this article, we will resolve the issue adop phasepreparevalidateinventory-error . The issue adop phase=prepare ValidateInventory: [ERROR]: At least one Oracle inventory check has failed while executing at primary node.
[applmgr@uatapps ~]$ adop phase=prepare
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /oracle/EBSFS/fs1/inst/apps/UAT_uatapps/appl/admin/UAT_uatapps.xml
Patch edition context: /oracle/EBSFS/fs2/inst/apps/UAT_uatapps/appl/admin/UAT_uatapps.xml
Patch file system free space: 449.52 GB
Validating system setup.
Node registry is valid.
Log: /oracle/EBSFS/fs1/inst/apps/UAT_uatapps/logs/appl/rgf/TXK/verifyssh.log
Output: /oracle/EBSFS/fs1/inst/apps/UAT_uatapps/logs/appl/rgf/TXK/out.xml
Remote execution is operational.
[WARNING] ETCC: The following required database fixes have not been applied to node uatapps:
31983472
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
Checking for existing adop sessions.
Continuing with existing session [Session ID: 15].
===========================================================================
ADOP (C.Delta.12)
Session ID: 15
Node: uatapps1
Phase: prepare
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_151850/adop.log
===========================================================================
Verifying existence of context files in database.
Checking if adop can continue with available nodes in the configuration.
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_151850/prepare/uatapps1
txkADOPEvalSrvStatus.pl returned SUCCESS
Skipping configuration validation on admin node: [uatapps1]
Validating configuration on node(s): [uatapps2].
Output: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_151850/prepare/validate/remote_execution_result_level2.xml
[ERROR] txkADOPValidation failed on Node: “uatapps2”
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_151850/prepare/uatapps2
txkADOPEvalSrvStatus.pl returned SUCCESS
Verifying data dictionary.
Creating list of nodes where prepare phase needs to be run.
The prepare phase has already been run on node: uatapps1
Not running prepare phase as it has already been run on all nodes.
Summary report for current adop session:
Node uatapps2: Failed
– Prepare status: Not Started
Node uatapps1: Completed successfully
– Prepare status: Completed successfully
For more details, run the command: adop -status -detail
adop exiting with status = 0 (Success)
Investigating the issue by check below logs.
ADOPValidations_detailed.log:-
————————————
verifyInventoryAgainstFilesystem …
————————————
ERROR: /oracle/EBSFS/fs1/FMW_Home/Oracle_EBS-app1 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 /oracle/EBSFS/fs1/FMW_Home/Oracle_EBS-app1.
-bash-4.1$ cat /etc/oraInst.loc
inventory_loc=/etc/oraInventory
cd /oracle/EBSFS/fs1/EBSapps/10.1.2/oui/bin
[applmgr@uatapps2 bin]$ ./runInstaller.sh -attachhome ORACLE_HOME=/oracle/EBSFS/fs1/EBSapps/10.1.2
./runInstaller.sh: line 2: cd: /oui/bin/linux: No such file or directory
Starting Oracle Universal Installer…
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-06-17_03-05-31PM. Please wait …[applmgr@uatapps bin]$ Java HotSpot(TM) Server VM warning: You have loaded library /tmp/OraInstall2021-06-17_03-05-31PM/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It’s highly recommended that you fix the library with ‘execstack -c <libfile>’, or link it with ‘-z noexecstack’.
‘AttachHome’ operation failed as it was called without name of the Oracle Home being attached.
[applmgr@uatapps2 bin]$
[applmgr@uatapps2 bin]$
[applmgr@uatapps2 bin]$ ./runInstaller.sh -attachhome ORACLE_HOME=/oracle/EBSFS/fs1/EBSapps/10.1.2 ORACLE_HOME_NAME=EBS_EXTERNAL_NODE
./runInstaller.sh: line 2: cd: /oui/bin/linux: No such file or directory
Starting Oracle Universal Installer…
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-06-17_03-07-35PM. Please wait …[applmgr@uatapps bin]$ Java HotSpot(TM) Server VM warning: You have loaded library /tmp/OraInstall2021-06-17_03-07-35PM/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It’s highly recommended that you fix the library with ‘execstack -c <libfile>’, or link it with ‘-z noexecstack’.
‘AttachHome’ was successful.
./runInstaller.sh -attachhome ORACLE_HOME=/oracle/EBSFS/fs1/FMW_Home/Oracle_EBS-app1 ORACLE_HOME_NAME=EBS_EXTERNAL_NODE1
./runInstaller.sh -attachhome ORACLE_HOME=/oracle/EBSFS/fs1/FMW_Home/webtier ORACLE_HOME_NAME=EBS_EXTERNAL_NODE2
./runInstaller.sh -attachhome ORACLE_HOME=/oracle/EBSFS/fs1/FMW_Home/oracle_common ORACLE_HOME_NAME=EBS_EXTERNAL_NODE3
After attached above oracle home.
Re-executed the adop phase=prepare.
[applmgr@uatapps ~]$ adop phase=prepare
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /oracle/EBSFS/fs1/inst/apps/UAT_uatapps1/appl/admin/UAT_uatapps.xml
Patch edition context: /oracle/EBSFS/fs2/inst/apps/UAT_uatapps1/appl/admin/UAT_uatapps.xml
Patch file system free space: 446.70 GB
Validating system setup.
Node registry is valid.
Log: /oracle/EBSFS/fs1/inst/apps/UAT_uatapps1/logs/appl/rgf/TXK/verifyssh.log
Output: /oracle/EBSFS/fs1/inst/apps/UAT_uatapps1/logs/appl/rgf/TXK/out.xml
Remote execution is operational.
[WARNING] ETCC: The following required database fixes have not been applied to node uatapps:
31983472
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
Checking for existing adop sessions.
Continuing with existing session [Session ID: 15].
===========================================================================
ADOP (C.Delta.12)
Session ID: 15
Node: uatapps
Phase: prepare
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_154058/adop.log
===========================================================================
Verifying existence of context files in database.
Checking if adop can continue with available nodes in the configuration.
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_154058/prepare/uatapps
txkADOPEvalSrvStatus.pl returned SUCCESS
Skipping configuration validation on admin node: [uatapps1]
Validating configuration on node(s): [uatapps2].
Output: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_154058/prepare/validate/remote_execution_result_level2.xml
Log: /oracle/EBSFS/fs_ne/EBSapps/log/adop/15/20210617_154058/prepare/uatapps
txkADOPEvalSrvStatus.pl returned SUCCESS
Verifying data dictionary.
Creating list of nodes where prepare phase needs to be run.
The prepare phase needs to be run on node: uatapps2
The prepare phase has already been run on node: uatapps1
Starting admin server on patch file system.
Running prepare phase on node(s): [uatapps2].
…………………………………………………..
Another interesting article to resolve the adop prepare issue, click here.
You may check another post related to similar issue, click here.