This discussion is archived
6 Replies Latest reply: Nov 10, 2011 9:42 AM by Hussein Sawwan-Oracle RSS

perl adcfgclone.pl dbTier

838779 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    Jimmy,

    Thanks for the update and for sharing the workaround.

    Hussein

Legend

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