Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 23 December 2012

java.sql.SQLRecoverableException: IO Error: adcfgclone.pl

Hi,

Error occured while running adcfgclone on dbTier  on R12.1.3 Sun Solrais 10 sparc 64-bit with the following error:


 RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase


StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)
        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
        at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:366)
        at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:110)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Unknown Source) 

If we check adcfgclone log file error:


This error is encountered only because adcfgclone.pl not able to update the context variable s_db_listener to target SID its still keeps the old value of source system.

Controlfile creation did not failed, database is configured properly. If we connect to database its up.


Solution:

Change value of context variable s_db_listener in context file to the required target value (PREPROD in mycase) and run autoconfig it will complete successful.

Thanks for reading :)

regards,
X A H E E R

No comments: