My Oracle Support Banner

Script Fail With ORA-20001 While Running Autoconfig On Target Node During Migration (Doc ID 2268532.1)

Last updated on MARCH 28, 2018

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Autoconfig Engine

When running autoconfig on target server while migrating application tier the following error occurs.

Script Name :
Script Version : 120.0.12020000.4
(*******FATAL ERROR*******
PROGRAM : (/APDATA/TEST/AP/fs1/inst/apps/TEST_ebs/admin/install/
TIME : Thu May 11 13:54:53 2017
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
SQLPLUS error: buffer=

When running the function ad_zd_adop.get_node_type() passing the node name of the cloned instance (e.g, ebs) the following error is displayed

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

The following error can also be found in RCloneApplyAppstier_xxxx.log file:

at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 168
TXK::Error::abort('TXK::Error', 'HASH(0x1e1aaa8)') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x2581090)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release - Produc...', undef) called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x2581090)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release - Produc...') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 832
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x2581090)', 0) called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 234
TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x2581090)', 'HASH(0x2e0b910)') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 618
TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x2571088)', 'SELECT ad_zd_adop.get_node_type(\'ebs\') FROM DUAL') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/ line 573
TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x2571088)', 'SELECT ad_zd_adop.get_node_type(\'ebs\') FROM DUAL') called at ...fs2/inst/apps/EBSDEV_ebs/admin/install/ line 503
main::getNodeType() called at ...fs2/inst/apps/EBSDEV_ebs/admin/install/ line 199
eval {...} called at ...fs2/inst/apps/EBSDEV_ebs/admin/install/ line 140
.end std out.


This error has been found to occur for the following two scenarios:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.