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.

Oracle error -1400: ORA-01400: cannot insert NULL in to ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

 

While running Autoconfig failed:

        Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5)                ; END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL in                to ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

        at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:334)

        at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:337)

        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:762)

        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:233)

        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)

        at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:787)

FAILED

COMPLETED

Solution:

drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.adop_valid_nodes;
create synonym apps.adop_valid_nodes for applsys.adop_valid_nodes;