TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Posted by Vasudev Seeram on September 22, 2008 Leave a comment (0) Go to comments

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

TriniDBA