This discussion is archived
1 2 3 4 Previous Next 47 Replies Latest reply: Feb 3, 2013 11:11 PM by 968325 RSS

adcfgclone.pl dbTier gets error

968325 Newbie
Currently Being Moderated
Dear all i made the cloning steps on DB and apps . preclone completed successful on db and apps and autoconfig and i created appsutil also newly. i made everything to make the post clone succeed .everything is good only not post clone.

APPS : REDHAT 4.7 32 BIT 11.5.10.2
DB : ORACLE LINUX 5.3 64 BIT 10.2.0.5

THE LOG CONTAINS ERRORS LIKE :

Executing runAutoConfig...

Deleting files of type INSTALL

Checking for file: /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/sqlnet.ora
Processing driver file: /oracle/oracle/proddb/10.2.0/appsutil/template/addbtmpl.drv

Checking for file: /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/tnsnames.ora

Checking for file: /oracle/oracle/proddb/10.2.0/dbs/initTEST.ora

Checking for file: /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/listener.ora
Starting CVM in INSTE8_SETUP mode

Using Context file : /oracle/oracle/proddb/10.2.0/appsutil/TEST_emctestdb.xml

Attempting to create a back up of the Context file
Created back up file of name :
/oracle/oracle/proddb/10.2.0/appsutil/out/TEST_emctestdb/01300000/TEST_emctestdb.xml
===========================================================================
Starting synchronization of file system Context file and its templates with those in the database

Database connection : Failed
OAM Context editing support feature: Unverified
OAM Customization support feature : Unverified

File system template : /oracle/oracle/proddb/10.2.0/appsutil/template/adxdbctx.tmp

Checking for customizations to Context template
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations.
Looking for custom template at : /oracle/oracle/proddb/10.2.0/appsutil/template/custom/adxdbctx.tmp
Custom template : Not available
Customizations found : None
----------------------------------------------------------------
File system Context file :/oracle/oracle/proddb/10.2.0/appsutil/TEST_emctestdb.xml

Checking the Context file for possible updates from the Database
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations and the Context files in DataBase and in the file system may be unsynchronized
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Generate Tns Names
##########################################################################
Classpath : /oracle/oracle/proddb/10.2.0/jdk/jre/lib/rt.jar:/oracle/oracle/proddb/10.2.0/jdk/lib/dt.jar:/oracle/oracle/proddb/10.2.0/jdk/lib/tools.jar:/oracle/oracle/proddb/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/oracle/proddb/10.2.0/appsutil/java/xmlparserv2.zip:/oracle/oracle/proddb/10.2.0/appsutil/java:/oracle/oracle/proddb/10.2.0/jlib/netcfg.jar:/oracle/oracle/proddb/10.2.0/jlib/ldapjclnt10.jar

Loading ORACLE_HOME environment from /oracle/oracle/proddb/10.2.0
Logfile: /oracle/oracle/proddb/10.2.0/appsutil/log/TEST_emctestdb/01300000/NetServiceHandler.log
Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates
Instantiating templates
tnsnames.ora instantiated
listener.ora instantiated

adgentns.pl exiting with status 25600
ERRORCODE = 25600 ERRORCODE_END
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ADX Database Utility
---------------------------------------------------------------

getConnection() -->
sDbHost : emctestdb
sDbDomain : emceg.com
sDbPort : 1522
sDbSid : TEST
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@emctestdb.emceg.com:1522:TEST
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=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
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=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.emceg.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---------------

RC-40201: Unable to connect to Database TEST.


StackTrace:
java.lang.Exception: Cannot connect to database using DBUtil
at oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3414)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:524)
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)

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

getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : emctestdb
sDbDomain : emceg.com
sDbPort : 1522
sDbSid : TEST
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@emctestdb.emceg.com:1522:TEST
Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
Exception occurred: java.sql.SQLException: Io exception: Connection reset
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.emceg.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection reset
Connection could not be obtained; returning null
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Creating the control file for TEST_emctestdb database ...


SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 00:01:47 2013

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

Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 2101672 bytes
Variable Size 427822680 bytes
Database Buffers 629145600 bytes
Redo Buffers 14671872 bytes

Control file created.


Database altered.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-------------------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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

by the way listener gone up :

You are running addlnctl.sh version 115.7

Logfile: /oracle/oracle/proddb/10.2.0/appsutil/log/TEST_emctestdb/addlnctl.txt

Starting listener process TEST ...


addlnctl.sh: exiting with status 0

.end std out.

.end err out.

THanks
  • 1. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    and by the way i can connect to the DB via sqlplus / as sysdba and i can startup the Db and shut it down after running the new env file of the target DB :

    [oraprod@emctestdb 10.2.0]$ sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 01:31:34 2013

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


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 1073741824 bytes
    Fixed Size 2101672 bytes
    Variable Size 427822680 bytes
    Database Buffers 629145600 bytes
    Redo Buffers 14671872 bytes
    Database mounted.
    Database opened.
  • 2. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Hi,

    Did you try to run autoconfig on dbtier then run post clone on application tier?

    Regards
    Yoonas
  • 3. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    do you mean target or source?
  • 4. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Target, i think thats where the problem is happening.
  • 5. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    here are the steps i done :

    1.autoconfig db source
    2.autoconfig apps source
    3.preclone db source
    4. preclone apps source.
    5. copy db and apps source to target.
    6 post clone target db . here is the problem .

    what is the steps you want ?
  • 6. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    As you can start the database and listener after sourcing environment on target , you could try running autoconfig on target then post clone on target
  • 7. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    autoconfig errors :

    Starting synchronization of file system Context file and its templates with those in the database

    Database connection : Failed
    OAM Context editing support feature: Unverified
    OAM Customization support feature : Unverified



    Warning: Unable to connect to Database.
    If the system is OAM enabled, this may result in loss of customizations.
    Looking for custom template at : /oracle/oracle/proddb/10.2.0/appsutil/template/custom/adxdbctx.tmp
    Custom template : Not available
    Customizations found : None






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

    getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
    getConnection() -->
    sDbHost : emctestdb
    sDbDomain : emceg.com
    sDbPort : 1522
    sDbSid : TEST
    sDbUser : apps
    Trying to connect using SID...
    getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@emctestdb.emceg.com:1522:TEST
    Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
    Trying to connect using SID as ServiceName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
    Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
    Trying to connect using SID as ServiceName.DomainName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.emceg.com)))
    Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
    Connection could not be obtained; returning null




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

    Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database


    StackTrace:
    java.sql.SQLException: Could not get connection to the database
    at oracle.apps.ad.tools.configuration.CVMHelper.processNewContextFile(CVMHelper.java:884)
    at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1721)
    at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1523)
    at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:665)




    Generate Tns Names
    ##########################################################################
    Classpath : /oracle/oracle/proddb/10.2.0/jdk/jre/lib/rt.jar:/oracle/oracle/proddb/10.2.0/jdk/lib/dt.jar:/oracle/oracle/proddb/10.2.0/jdk/lib/tools.jar:/oracle/oracle/proddb/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/oracle/proddb/10.2.0/appsutil/java/xmlparserv2.zip:/oracle/oracle/proddb/10.2.0/appsutil/java:/oracle/oracle/proddb/10.2.0/jlib/netcfg.jar:/oracle/oracle/proddb/10.2.0/jlib/ldapjclnt10.jar

    Loading ORACLE_HOME environment from /oracle/oracle/proddb/10.2.0
    Logfile: /oracle/oracle/proddb/10.2.0/appsutil/log/TEST_emctestdb/01300219/NetServiceHandler.log
    Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates
    Instantiating templates
    tnsnames.ora instantiated
    listener.ora instantiated

    adgentns.pl exiting with status 25600
    ERRORCODE = 25600 ERRORCODE_END



    afdbprf.sh started at Wed Jan 30 02:19:48 EET 2013


    The environment settings are as follows ...

    ORACLE_HOME : /oracle/oracle/proddb/10.2.0
    ORACLE_SID : TEST
    PATH : /usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oraprod/bin
    Library Path : /oracle/oracle/proddb/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/oracle/proddb/10.2.0/ctx/lib

    Executable : /oracle/oracle/proddb/10.2.0/bin/sqlplus


    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 02:19:49 2013

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

    Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
    ORA-12537: TNS:connection closed


    ERRORCODE = 1 ERRORCODE_END



    getConnection() -->
    sDbHost : emctestdb
    sDbDomain : emceg.com
    sDbPort : 1522
    sDbSid : TEST
    sDbUser : apps
    Trying to connect using SID...
    getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@emctestdb.emceg.com:1522:TEST
    Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
    Trying to connect using SID as ServiceName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST)))
    Exception occurred: java.sql.SQLException: Io exception: Connection reset
    Trying to connect using SID as ServiceName.DomainName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=TEST.emceg.com)))
    Exception occurred: java.sql.SQLException: Io exception: Got minus one from a read call
    Connection could not be obtained; returning null

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

    Verifying connection to the Database : Could not be stablished




    [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: /oracle/oracle/proddb/10.2.0/appsutil/install/TEST_emctestdb
    afdbprf.sh INSTE8_PRF 1
  • 8. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Hope Listener and database were running when you run autoconfig.
    can you post output of addlnlctl.sh status TEST

    also see

    adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' [ID 1299429.1]

    11i: 'adcfgclone.pl dbTier' fails with error RC-40201 and RC-00118 - Raised by oracle.apps.ad.clone.ApplyDatabase [ID 339128.1]

    Edited by: yoonus on Jan 30, 2013 4:39 AM

    Edited by: yoonus on Jan 30, 2013 4:44 AM
  • 9. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ ./addlnctl.sh status TEST

    You are running addlnctl.sh version 115.7

    Logfile: /oracle/oracle/proddb/10.2.0/appsutil/log/TEST_emctestdb/addlnctl.txt

    Finding status of listener process TEST ...


    addlnctl.sh: exiting with status 0
  • 10. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ nslookup emctestdb.emceg.com
    Server: 10.10.100.236
    Address: 10.10.100.236#53

    Name: emctestdb.emceg.com
    Address: 10.10.100.8
  • 11. Re: adcfgclone.pl dbTier gets error
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    Please refer:
         11i: 'adcfgclone.pl dbTier' fails with error RC-40201 and RC-00118 - Raised by oracle.apps.ad.clone.ApplyDatabase [ID 339128.1]
    Also review:
    ' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' [ID 1299429.1]
    R12 Rapidclone on dbTier Tries to Start Listener with Source SID: "RC-00118 'Error occurred during creation of database' " [ID 1329400.1]

    Regard
    Helios
  • 12. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Did you see the reference notes on MOS?

    Thats not the full output. Please post complete, just status is not enough

    Edited by: yoonus on Jan 30, 2013 4:48 AM
  • 13. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    nothing new still got the same error
  • 14. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Please login to support.oracle.com and see the notes referred https://support.oracle.com/

    when you run the addlnctl.sh status TEST you will have few more lines after the line "Finding status of listener process TEST ..." post those line as well
1 2 3 4 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points