Errorcode 25600 during adcfgclone.pl
669842 Oct 5, 2009 5:11 PMHi,
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.
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.