ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes
issue
[applmgr@ebs121 upg1227]$ adop phase=apply patches=21841299 hotpatch=yes patchtop=/apps/upgpatch/upg1227 abandon=no restart=yes
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /db/applmgr/PROD/fs1/inst/apps/PROD_ebs121/appl/admin/PROD_ebs121.xml
Patch edition context: /db/applmgr/PROD/fs2/inst/apps/PROD_ebs121/appl/admin/PROD_ebs121.xml
*******FATAL ERROR*******
PROGRAM : (/db/applmgr/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Tue Jan 7 20:11:59 2020
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: Cannot identify any valid application tier nodes in
ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.
adop exiting with status = 255 (Fail)
[applmgr@ebs121 upg1227]$
Solutiion -
check code level
SQL> select
abbreviation
,codelevel
from
ad_trackable_entities
where
abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
order by
abbreviation; 2 3 4 5 6 7 8 9
ABBREVIATION CODELEVEL
------------------------------ ------------------------------
ad C
atg_pf C
fnd C
fwk C
icx D
txk C
6 rows selected.
SQL>
Run AutoConfig on the DB tier:
Source the <RDBMS_ORACLE_HOME> home.
$ cd <RDBMS_ORACLE_HOME>/appsutil/scripts/<SID>_<HOSTNAME>/
$./adautocfg.sh
... Confirm Autoconfig completes successfully.
... If RAC, Repeat step 3 on all RAC nodes.
Run Autoconfig on the run file system.
$ source <EBS_BASE>/EBSapps.env run
$ cd $ADMIN_SCRIPTS_HOME
$ ./adautocfg.sh
... Confirm Autoconfig completes successfully.
- apply the patch now..
able to run adop without any issueable to run adop without any issue