1 2 3 4 Previous Next 47 Replies Latest reply: Feb 4, 2013 1:11 AM by 968325 RSS

    adcfgclone.pl dbTier gets error

    968325
      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
          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
            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
              do you mean target or source?
              • 4. Re: adcfgclone.pl dbTier gets error
                yoonas
                Target, i think thats where the problem is happening.
                • 5. Re: adcfgclone.pl dbTier gets error
                  968325
                  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
                    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
                      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
                        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
                          [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
                            [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
                              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
                                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
                                  nothing new still got the same error
                                  • 14. Re: adcfgclone.pl dbTier gets error
                                    yoonas
                                    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