6 Replies Latest reply: Nov 10, 2011 11:42 AM by Hussein Sawwan-Oracle RSS

    perl adcfgclone.pl dbTier

    838779
      Hi,

      I run perl adcfgclone.pl dbTier on IB AIX 6.1, and I got an erro as bellow :

      --------------------------------------------------------------------------------------------------------
      Starting DB listener with command:
      /u01/DEV/db/tech_st/11.1.0/appsutil/scripts/DEV_svrdev/addlnctl.sh start DEV
      Logfile: /u01/DEV/db/tech_st/11.1.0/appsutil/log/DEV_svrdev/addlnctl.txt

      You are running addlnctl.sh version 120.1.12010000.4


      Starting listener process DEV ...


      LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 09-NOV-2011 21:21:16

      Copyright (c) 1991, 2008, Oracle. All rights reserved.

      Starting /u01/DEV/db/tech_st/11.1.0/bin/tnslsnr: please wait...

      TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
      System parameter file is /u01/DEV/db/tech_st/11.1.0/network/admin/DEV_svrdev/listener.ora
      Log messages written to /u01/DEV/db/tech_st/11.1.0/log/diag/tnslsnr/svrdev/dev/alert/log.xml
      TNS-01151: Missing listener name, DEV, in LISTENER.ORA

      Listener failed to start. See the error message(s) above...


      addlnctl.sh: exiting with status 1

      addlnctl.sh: check the logfile /u01/DEV/db/tech_st/11.1.0/appsutil/log/DEV_svrdev/addlnctl.txt for more info
      rmation ...


      .end std out.

      .end err out.

      .......
      .......
      .......

      Database altered.


      Tablespace altered.


      Tablespace altered.


      Database altered.


      PL/SQL procedure successfully completed.

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      exit_code=0

      Checking for errors ...


      .end std out.

      .end err out.


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

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : svrdev
      sDbDomain : incasiraya.com
      sDbPort : 1528
      sDbSid : DEV
      sDbUser : APPS
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@svrdev.incasiraya.com:1528:DEV
      Exception occurred: java.sql.SQLException: 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=svrdev.incasiraya.com)(PORT=1528))
      (CONNECT_DATA=(SERVICE_NAME=DEV)))
      Exception occurred: java.sql.SQLException: 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=svrdev.incasiraya.com)(PORT=1528))
      (CONNECT_DATA=(SERVICE_NAME=DEV.incasiraya.com)))
      Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection
      Connection could not be obtained; returning null

      -------------------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.doConf(ApplyDatabase.java:635)
      at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
      at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)
      at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:45)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:
      27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:528)
      at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
      at java.lang.Thread.run(Thread.java:735)

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

      I Think coz the listener not up.

      Please advice, what should I do.

      Thank you
      Jimmy
        • 1. Re: perl adcfgclone.pl dbTier
          838779
          content of listener.ora :
          -----------------------------------

          $ cat listener.ora
          #
          # $Header: ad8ilsnr.ora 120.3.12010000.3 2010/03/09 07:07:03 jmajumde ship $
          #
          # ###############################################################
          #
          # This file is automatically generated by AutoConfig. It will be read and
          # overwritten. If you were instructed to edit this file, or if you are not
          # able to use the settings created by AutoConfig, refer to Metalink Note
          # 387859.1 for assistance.
          #
          # ###############################################################

          #

          #
          # Net8 definition for Database listener
          #

          PROD =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = svrdev.incasiraya.com)(PORT = 1528))
          )
          )

          SID_LIST_PROD =
          (SID_LIST =
          (SID_DESC =
          (ORACLE_HOME= /u01/DEV/db/tech_st/11.1.0)
          (SID_NAME = DEV)
          )
          )

          STARTUP_WAIT_TIME_PROD = 0
          CONNECT_TIMEOUT_PROD = 10
          TRACE_LEVEL_PROD = OFF

          LOG_DIRECTORY_PROD = /u01/DEV/db/tech_st/11.1.0/network/admin
          LOG_FILE_PROD = PROD
          TRACE_DIRECTORY_PROD = /u01/DEV/db/tech_st/11.1.0/network/admin
          TRACE_FILE_PROD = PROD
          ADMIN_RESTRICTIONS_PROD = ON
          SUBSCRIBE_FOR_NODE_DOWN_EVENT_PROD = OFF


          # added parameters for bug# 9286476
          LOG_STATUS_PROD = ON
          INBOUND_CONNECT_TIMEOUT_PROD = 60

          # ADR is only applicable for 11gDB
          DIAG_ADR_ENABLED_PROD = ON
          ADR_BASE_PROD = /u01/DEV/db/tech_st/11.1.0/admin/DEV_svrdev

          ---------------------------------------------------------------------------------------------------------
          the name still PROD, should be change to DEV

          Please advice.

          Thank you
          • 2. Re: perl adcfgclone.pl dbTier
            Hussein Sawwan-Oracle
            TNS-01151: Missing listener name, DEV, in LISTENER.ORA
            The listener entry is missing in your listener.ora file, you should have an entry similar to the PROD entry you posted above but it should points to DEV instance (with the correct hostname, SID, port).

            Thanks,
            Hussein
            • 3. Re: perl adcfgclone.pl dbTier
              838779
              Hi Husein,


              Thank you for your respon, I think it should be changed automaticly by running adcfgclone.pl dbTier.

              Regards,
              Jimmy
              • 4. Re: perl adcfgclone.pl dbTier
                Hussein Sawwan-Oracle
                Jimmy,

                You are right, but looks like adcfgclone.pl did not create it for a reason.

                Please review the adcfgclone.pl log file to find out the reason. Also, review /u01/DEV/db/tech_st/11.1.0/appsutil/log/DEV_svrdev/addlnctl.txt for any errors.

                Thanks,
                Hussein
                • 5. Re: perl adcfgclone.pl dbTier
                  838779
                  Hi Husein,

                  I found this document : RapidClone fails at 70% after TXK.U due to "s_db_listener" referencing source SID [ID 1153204.1]

                  I can solve the problem with workaround :

                  1. Edit $ORACLE_HOME/appsutil/clone/context/db/CTXORIG.xml
                  2. Change the value for "s_db_listener" to the correct target system value
                  3. Shutdown Target Database
                  4. Rerun "perl adcfgclone.pl dbTier"

                  Clone process is done ... :)

                  Thank you Husein.

                  Regards,
                  Jimmy
                  • 6. Re: perl adcfgclone.pl dbTier
                    Hussein Sawwan-Oracle
                    Jimmy,

                    Thanks for the update and for sharing the workaround.

                    Hussein