Script txkGenADOPWrapper.pl 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.

Symptoms

On : 12.2.3 version, Autoconfig Engine

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

Script Name : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.4
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/APDATA/TEST/AP/fs1/inst/apps/TEST_ebs/admin/install/txkGenADOPWrapper.pl)
TIME : Thu May 11 13:54:53 2017
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
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:

STACK TRACE
at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x1e1aaa8)') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x2581090)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x2581090)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x2581090)', 0) called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x2581090)', 'HASH(0x2e0b910)') called at ...fs2/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm 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/TechstackDB.pm 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/txkGenADOPWrapper.pl line 503
main::getNodeType() called at ...fs2/inst/apps/EBSDEV_ebs/admin/install/txkGenADOPWrapper.pl line 199
eval {...} called at ...fs2/inst/apps/EBSDEV_ebs/admin/install/txkGenADOPWrapper.pl line 140
)
ERRORCODE = 1 ERRORCODE_END
.end std out.

Changes

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

Cause

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 hundreds of Community platforms