This discussion is archived
1 2 3 4 Previous Next 47 Replies Latest reply: Feb 3, 2013 11:11 PM by 968325 Go to original post RSS
  • 15. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    i did all this and i did all the solutions in the notes and there are no more lines in the status for listener
  • 16. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ tnsping TEST

    TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 30-JAN-2013 03:28:47

    Copyright (c) 1997, 2010, Oracle. All rights reserved.

    Used parameter files:
    /oracle/oracle/proddb/10.2.0/network/admin//sqlnet_ifile.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522)) (CONNECT_DATA=(SID=TEST)))
    TNS-12537: TNS:connection closed
  • 17. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ lsnrctl status TEST

    LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 30-JAN-2013 03:36:02

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

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
    STATUS of the LISTENER
    ------------------------
    Alias TEST
    Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
    Start Date 30-JAN-2013 00:01:47
    Uptime 0 days 3 hr. 34 min. 15 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/listener.ora
    Listener Log File /oracle/oracle/proddb/10.2.0/network/admin/test.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTEST)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "TEST" has 1 instance(s).
    Instance "TEST", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
  • 18. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 03:39:40 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
    .end std out.

    .end err out.
  • 19. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    adcrobj.sh started at Wed Jan 30 03:39:40 EET 2013

    Parameters passed are : -nopromptmsg

    The environment settings are as follows ...

    ORACLE_HOME : /oracle/oracle/proddb/10.2.0
    ORACLE_SID : TEST
    TWO_TASK :
    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
  • 20. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    You copied back all the dbtier files and run perl adcfgclone.pl dbTier (As per the note) .

    try sqlplus <username>/<password>@TEST

    while your tns ping shows this
    >
    Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522)) (CONNECT_DATA=(SID=TEST)))
    TNS-12537: TNS:connection closed
    >

    lsnrctl status shows this
    >
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTEST)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522)))
    >

    Can you post the sqlnet.ora and tnsnames.ora

    Regards
    Yoonas
  • 21. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ sqlplus apps/apps@TEST

    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 04:08:57 2013

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

    ERROR:
    ORA-12537: TNS:connection closed


    Enter user-name:


    I cant find sqlnet.ora in TNS_ADMIN
  • 22. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    TNSNAMES


    TEST = (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
    (CONNECT_DATA=(SID=TEST))
    )

    TEST_LOCAL =
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
    )

    TEST_REMOTE =
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
    )

    #
    # Intermedia
    #
    extproc_connection_data =
    (DESCRIPTION=
    (ADDRESS_LIST =
    (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
    )
    (CONNECT_DATA=
    (SID=PLSExtProc)
    (PRESENTATION = RO)
    ) )

    IFILE=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/TEST_emctestdb_ifile.ora
  • 23. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    echo $TNS_ADMIN
    ping emctestdb
    see if sqlnet is available at /oracle/oracle/proddb/10.2.0/network/admin/


    export TNS_ADMIN=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb

    sqlplus apps/apps@TEST
  • 24. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    [oraprod@emctestdb TEST_emctestdb]$ echo $TNS_ADMIN
    /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb

    [oraprod@emctestdb TEST_emctestdb]$ ping emctestdb
    PING emctestdb.emceg.com (10.10.100.8) 56(84) bytes of data.
    64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=1 ttl=64 time=0.028 ms
    64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=2 ttl=64 time=0.015 ms
    64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=3 ttl=64 time=0.020 ms


    yes it has sqlnet.ora

    NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
    SQLNET.EXPIRE_TIME= 10
    tcp.validnode_checking = yes
    tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)


    IFILE=/oracle/oracle/proddb/10.2.0/network/admin//sqlnet_ifile.ora



    [oraprod@emctestdb admin]$ export TNS_ADMIN=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb
    [oraprod@emctestdb admin]$ sqlplus apps/apps@TEST

    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 04:46:40 2013

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

    ERROR:
    ORA-12537: TNS:connection closed


    Enter user-name:
  • 25. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    Change the setting in sqlnet.ora

    From
    tcp.validnode_checking = yes
    tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)
    to
    tcp.validnode_checking = no
    ##tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)

    or

    tcp.validnode_checking = yes
    tcp.invited_nodes=(emctestdb.emceg.com, 10.10.100.8)

    lsnrctl stop TEST
    lsnrctl start TEST

    sqlplus apps/apps@TEST
  • 26. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    ok thank you it solved my problem now and i ran autoconfig and its successful . but should i run the adcfgclone.pl dbTier again or it will crash the DB ?
  • 27. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    No, try adcfgclone.pl on appsTier
  • 28. Re: adcfgclone.pl dbTier gets error
    968325 Newbie
    Currently Being Moderated
    is that mean adcfgclone.pl dbTier is completed successful ?
  • 29. Re: adcfgclone.pl dbTier gets error
    yoonas Expert
    Currently Being Moderated
    It could be that the issue we resolved now was stopping adcfgclone.pl from successfull completion, from the log you can see the it was not able to get connection to database. When we tried autoconfig before it was not able to run successfully. Now you are able to run autoconfig so we can assume if this issue were no there adcfgclone.pl woul have completed successfully !.

    So try running adcfgclone.pl on appsTier,

    if you run adcfgclone.pl dbTier it will recreate your database so you may have to delete those files and copy again from source..

    _Troubleshooting RapidClone issues with Oracle Applications 11i [ID 364565.1]_

    Edited by: yoonus on Jan 30, 2013 7:36 AM

    Edited by: yoonus on Jan 30, 2013 7:38 AM

Legend

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