Contact Premier Online Trainings Today

Oracle Apps DBA - ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes

Date Added: 07 Jan.2020 Date Updated: 07 Jan.2020 Oracle Apps DBA Full Blog

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