TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Problem:

When running AutoConfig, it fails at 50% with the following error:

ERROR

ORA-12224: TNS:no listener

Solution:

Run the following, and then restart AutoConfig.

perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem

Reference:

Subject:  TNS Connectivity With Database Breaks After Running Autoconfig

Doc ID:  Note:377764.1

1020  unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

1021  . /u0/oracle/testappl/APPSTEST_ebusinesstest.env

1022  cd /u0/oracle/testora/iAS/appsoui/setup/

1023  perl OUIsetup.pl

1024  perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem

1025  cd /u0/oracle/testcomn/clone/bin/

1026  perl adcfgclone.pl appsTier

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.