7 Replies Latest reply on Oct 6, 2009 6:50 PM by 669842

    Errorcode 25600 during adcfgclone.pl

    669842
      Hi,
      I'm configuring a clone on and RHEL 5 environment. When I run adcfgclone.pl on the dbTier, it's exiting with an error at 70%. Extracts from the logs are as follows:

      ApplyDBTier log
      -------------------ADX Database Utility Finished---------------

      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.<init>(ApplyDatabase.java:661)+
      +     at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)+
      +     at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)+
      +     at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)+
      +     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:68)+
      +     at java.lang.Thread.run(Unknown Source)+



      NetServiceHandler.log
      +     Classpath : /u0/svrtest/svrtestdb/10.2.0/jdk/jre/lib/rt.jar:/u0/svrtest/svrtestdb/10.2.0/jdk/lib/dt.jar:/u0/svrtest/svrtestdb/10.2.0/jdk/lib/tools.jar:/u0/svrtest/svrtestdb/10.2.0/jdbc/lib/ojdbc14.jar:/u0/svrtest/svrtestdb/10.2.0/appsutil/java/xmlparserv2.zip:/u0/svrtest/svrtestdb/10.2.0/appsutil/java:/u0/svrtest/svrtestdb/10.2.0/jlib/netcfg.jar:/u0/svrtest/svrtestdb/10.2.0/jlib/ldapjclnt10.jar+

      +===============================================================================+
      NetServiceHandler 115.53 started for tclg-clone-114 at Sun Oct 04 21:36:35 AST 2009
      +===============================================================================+

      +[ Context Information ]+

      Host              : tclg-clone-114
      Domain            : tclgroup.com
      Out Dir           : /u0/svrtest/svrtestdb/10.2.0/appsutil/out/svrtest_tclg-clone-114/10042136
      Tier Type         : DATABASE TIER
      Getting connection...


      ---------------------------------------------------------------
      ADX Database Utility

      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost    : tclg-clone-114
      sDbDomain  : tclgroup.com
      sDbPort    : 1598
      sDbSid     : svrtest
      sDbUser    : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@tclg-clone-114.tclgroup.com:1598:svrtest
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tclg-clone-114.tclgroup.com)(PORT=1598))(CONNECT_DATA=(SERVICE_NAME=svrtest)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tclg-clone-114.tclgroup.com)(PORT=1598))(CONNECT_DATA=(SERVICE_NAME=svrtest.tclgroup.com)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      Could not get connection to the database.
      Exiting with status 100 to instantiate the tnsnames.ora template
      Creation of Directory - /u0/svrtest/svrtestdb/10.2.0/network/admin/svrtest_tclg-clone-114 Succeeded.
      instantiate file:

      source : /u0/svrtest/svrtestdb/10.2.0/appsutil/template/ad8itns.ora
      dest   : /u0/svrtest/svrtestdb/10.2.0/network/admin/svrtest_tclg-clone-114/tnsnames.ora


      AutoConfig is exiting with status 0

      instantiate file:

      source : /u0/svrtest/svrtestdb/10.2.0/appsutil/template/ad8ilsnr.ora
      dest   : /u0/svrtest/svrtestdb/10.2.0/network/admin/svrtest_tclg-clone-114/listener.ora


      AutoConfig is exiting with status 0


      adgentns.pl exiting with status 25600
      ERRORCODE = 25600 ERRORCODE_END

      Now I saw from my ApplyDBTier.log that the database was created, and when I tried using sqlplus '/ as sysdba' I was able to logon. So I tried running adautocfg.sh but I still get the 25600 error. Here's the extract from the adconfig.log:

      ****************************************************

      afdbprf.sh started at Sun Oct  4 21:41:45 AST 2009


      The environment settings are as follows ...

      ORACLE_HOME : /u0/svrtest/svrtestdb/10.2.0
      ORACLE_SID : svrtest
      PATH : /u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestdb/10.2.0/bin:/usr/bin:/usr/sbin:/u0/svrtest/svrtestdb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestdb/10.2.0/bin:/usr/bin:/usr/sbin:/u0/svrtest/svrtestdb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:.:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/applmgr/bin
      Library Path : /u0/svrtest/svrtestdb/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/svrtest/svrtestdb/10.2.0/ctx/lib

      Executable : /u0/svrtest/svrtestdb/10.2.0/bin/sqlplus


      SQL*Plus: Release 10.2.0.4.0 - Production on Sun Oct 4 21:41:45 2009

      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

      Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
      ORA-12541: TNS:no listener


      ERRORCODE = 1 ERRORCODE_END
      +.end std out.+

      +.end err out.+
      ****************************************************


      AutoConfig Services Phase
      Running Service Process 1 of 1 for AppsUtil
      Executing script in InstantiateFile:
      +/u0/svrtest/svrtestdb/10.2.0/appsutil/install/svrtest_tclg-clone-114/adcrobj.sh+

      script returned:
      ****************************************************

      adcrobj.sh started at Sun Oct  4 21:41:45 AST 2009

      Parameters passed are : -nopromptmsg

      The environment settings are as follows ...

      ORACLE_HOME : /u0/svrtest/svrtestdb/10.2.0
      ORACLE_SID : svrtest
      TWO_TASK :

      PATH : /u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestdb/10.2.0/bin:/usr/bin:/usr/sbin:/u0/svrtest/svrtestdb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/u0/svrtest/svrtestdb/10.2.0/bin:/usr/bin:/usr/sbin:/u0/svrtest/svrtestdb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:.:/u0/svrtest/svrtestora/iAS/Apache/perl/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/applmgr/bin
      LD_LIBRARY_PATH : /u0/svrtest/svrtestdb/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/svrtest/svrtestdb/10.2.0/ctx/lib

      SQLPLUS Executable : /u0/svrtest/svrtestdb/10.2.0/bin/sqlplus


      SQL*Plus: Release 10.2.0.4.0 - Production on Sun Oct 4 21:41:45 2009

      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

      Connected.

      PL/SQL procedure successfully completed.


      Commit complete.

      Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      adcrobj.sh exiting with status 0
      ERRORCODE = 0 ERRORCODE_END
      +.end std out.+

      +.end err out.+
      ****************************************************



      +===========================================================================+
      Starting Restore Profile utility at Sun Oct 04 21:41:46 AST 2009
      Using version 115.6


      ---------------------------------------------------------------
      ADX Database Utility

      ---------------------------------------------------------------

      getConnection() -->
      sDbHost    : tclg-clone-114
      sDbDomain  : tclgroup.com
      sDbPort    : 1598
      sDbSid     : svrtest
      sDbUser    : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@tclg-clone-114.tclgroup.com:1598:svrtest
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tclg-clone-114.tclgroup.com)(PORT=1598))(CONNECT_DATA=(SERVICE_NAME=svrtest)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tclg-clone-114.tclgroup.com)(PORT=1598))(CONNECT_DATA=(SERVICE_NAME=svrtest.tclgroup.com)))
      Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      +     Verifying connection to the Database : Could not be stablished+
      +     No Restore Profile file created.+


      Restore Profile utility ran successfully

      +===========================================================================+




      +[AutoConfig Error Report]+
      The following report lists errors AutoConfig encountered during each

      phase of its execution.  Errors are grouped by directory and phase.
      The report format is:
      +<filename> <phase> <return code where appropriate>+

      +[PROFILE PHASE]+
      AutoConfig could not successfully execute the following scripts:

      Directory: /u0/svrtest/svrtestdb/10.2.0/appsutil/install/svrtest_tclg-clone-114
      afdbprf.sh              INSTE8_PRF         1



      AutoConfig is exiting with status 1

      Is this an error I can recover from without having to run pre-clone on my source again? Any help would be appreciated.
      Thanks,
      Lia.