In 12.2, adautocfg.sh fails with ORA-20001: Node name visnode1 not found in adop repository tables

 

In 12.2, adautocfg.sh fails with ORA-20001: Node name visnode1 not found in adop repository tables

Script Name    : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.2
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/erp/applmgr/fs1/inst/apps/vis1_visnode1/admin/install/txkGenADOPWrapper.pl)
TIME    : Mon Jan 11 09:11:15 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 11 09:11:15 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> Connected.    visnode1
SQL> SELECT ad_zd_adop.get_node_type('visnode1') FROM DUAL
       *
ERROR at line 1:
ORA-20001: Node name visnode1 not found in adop repository tables
ORA-06512: at "APPS.AD_ZD_ADOP", line 3055

Background:

As part of application tier configuration, ADOP tables got cleaned with fnd_conc_clone.setup_clean procedure.
exec FND_CONC_CLONE.SETUP_CLEAN;

Following query will result 0 records or no entries of the node 'visnode1'
select * from APPLSYS.ADOP_VALID_NODES;

Solution:

Add entry into APPLSYS.ADOP_VALID_NODES table manually and retry autoconfig.
Get value of DEFAULT_EDITION from DATABASE_PROPERTIES table which is needed to add entry manually in ADOP_VALID_NODES table.

select property_value from database_properties where property_name = 'DEFAULT_EDITION';
Result was - ORA$BASE.  This may change based on your patching cycles. Take whatever value returned by this query.

insert into APPLSYS.ADOP_VALID_NODES values('visnode1','vis1_visnode1','ORA$BASE');
commit;

Rerun autoconfig.