Adop is not to able to detect any valid application
tier nodes
Issue:
Running ADOP
on 12.2 is failing at initial Validation with error “adop is not able to detect
any valid application tier nodes”
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials...
Initializing...
Run Edition context : /u01/oracle/VIS/fs1/inst/apps/VIS_ora01/appl/admin/VIS_ora01.xml
Patch edition context: / u01/oracle/VIS/fs2/inst/apps/VIS_ora01/appl/admin/VIS_ora01.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/VIS /fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Wed Apr 22 04:40:38 2015
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: adop is not able to detect any valid application tier nodes in
ADOP_VALID_NODES table. Ensure autoconfig is run on all nodes.
[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 = 255 (Fail)
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials...
Initializing...
Run Edition context : /u01/oracle/VIS/fs1/inst/apps/VIS_ora01/appl/admin/VIS_ora01.xml
Patch edition context: / u01/oracle/VIS/fs2/inst/apps/VIS_ora01/appl/admin/VIS_ora01.xml
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/VIS /fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Wed Apr 22 04:40:38 2015
FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ]
ERRORMSG: adop is not able to detect any valid application tier nodes in
ADOP_VALID_NODES table. Ensure autoconfig is run on all nodes.
[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 = 255 (Fail)
Cause
Upon investigation we found
that Database listener is not listening ebs_patch service which is mandatory
for 12.2 to work on any adop activities.
[oracle@ora01 ~]$ lsnrctl
status $ORACLE_SID
LSNRCTL for Linux: Version
11.2.0.4.0 - Production on 23-APR-2015 12:20:02
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Alias VIS
Listening Endpoints Summary...
.
.
Services Summary...
Service "VIS" has 2 instance(s).
Instance "VIS", status UNKNOWN,
has 1 handler(s) for this service...
Instance "VIS", status READY, has 1
handler(s) for this service...
The command completed
successfully
Solution
1) Make
sure that Database init parameter has service name ebs_patch defined
2) Connect
to Database as sysdba
sqlplus
/ as sysdba
SQL>
show parameter service_name
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
service_names string VIS, ebs_patch
If this is there, set the parameter as below
SQL> alter system set service_names=’ebs_patch’,’VIS’
scope=spfile;
3) Verify
init parameter LOCAL_LISTENER and set it to <DB_NAME>_LOCAL
SQL>
alter system set local_listener=’VIS_LOCAL’ scope=spfile;
4) Bounce
the application & database services
