This discussion is archived
6 Replies Latest reply: Dec 20, 2012 1:23 PM by EBSDBA RSS

TNS:connection closed

958381 Newbie
Currently Being Moderated
Hi All

When i issue "tnsping VIS" from apps node on two node (db on node1 and all appl services on node2) following error

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 20-DEC-2012 19:33:34

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

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=db)(PORT=1525)) (CONNECT_DATA=(SID=VIS)))
TNS-12537: TNS:connection closed

**database and Listener is up on the db node**
------

When i ran the autoconfig db its successful

when i ran on the apps node its erroring out as below

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


adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
  • 1. Re: TNS:connection closed
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please post the details of the application release, database version and OS.

    Can you login to the database remotely?

    Please upload AutoConfig log file for the application tier node to any free hosting website and post the link here.

    Please also see these docs.

    Service Temporarily Unavailable Error When Trying To Login To An 11.5.10 Instance [ID 386687.1]
    11.5.10 New Features : Managed SQL*Net Access from Hosts [ID 291897.1]
    'ORA-12537: TNS:connection closed' Errors Connecting To Oracle11g R1 on Linux via Oracle Net [ID 733737.1]
    Troubleshooting ORA-12537 / TNS-12537 TNS:Connection Closed [ID 555609.1]

    Thanks,
    Hussein
  • 2. Re: TNS:connection closed
    958381 Newbie
    Currently Being Moderated
    I'm in the process of upgrading 11.5..10.2 to R12.1.1

    Currently my db version is 11.2.0.1 and apps version is R12.1.1

    auto config error

    ORACLE_HOME : /u02/applmgr/apps/tech_st/10.1.2
    ORACLE_SID :
    TWO_TASK : VIS
    PATH : /u02/applmgr/apps/tech_st/10.1.2/bin:/usr/bin:/usr/sbin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/u02/applmgr/apps/tech_st/10.1.3/perl/bin:/u02/applmgr/apps/tech_st/10.1.2/bin:/u02/applmgr/apps/apps_st/appl/fnd/12.0.0/bin:/u02/applmgr/apps/apps_st/appl/ad/12.0.0/bin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/jre/bin::/u02/applmgr/apps/tech_st/10.1.3/perl/bin:/u02/applmgr/apps/tech_st/10.1.3/perl/bin:/u02/applmgr/apps/tech_st/10.1.2/bin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/u02/applmgr/apps/tech_st/10.1.2/bin:/usr/bin:/usr/sbin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/u02/applmgr/bin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/bin:/u02/applmgr/apps/tech_st/10.1.3/ant/bin:/u02/applmgr/apps/tech_st/10.1.3/appsutil/jdk/bin:/u02/applmgr/apps/tech_st/10.1.3/ant/bin
    LD_LIBRARY_PATH : /u02/applmgr/apps/tech_st/10.1.2/lib32:/u02/applmgr/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u02/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u02/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u02/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u02/applmgr/apps/apps_st/appl/sht/12.0.0/lib

    SQLPLUS Executable : /u02/applmgr/apps/tech_st/10.1.2/bin/sqlplus


    SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 20 19:01:57 2012

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

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


    adadmprf.sh exiting with status 1
    ERRORCODE = 1 ERRORCODE_END
    .end std out.

    .end err out.
    ****************************************************


    AutoConfig Profile Phase
    Running Profile Process 3 of 9 for AD_TOP
    File /u02/applmgr/inst/apps/VIS_apps/admin/install/admk80ln.sh not instantiated in the current pass, this file will not be executed
    AutoConfig Profile Phase
    Running Profile Process 4 of 9 for AD_TOP
    Executing script in InstantiateFile:
    /u02/applmgr/inst/apps/VIS_apps/admin/install/afadmprf.sh
  • 3. Re: TNS:connection closed
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Can you connect to the database remotely?

    Please see the docs referenced in my previous reply.

    Thanks,
    Hussein
  • 4. Re: TNS:connection closed
    958381 Newbie
    Currently Being Moderated
    no i cannot connect to the database remotely

    Thanks
    Jay
  • 5. Re: TNS:connection closed
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user2996886 wrote:
    no i cannot connect to the database remotely

    Thanks
    Jay
    Please see the first 2 docs referenced above.

    Thanks,
    Hussein
  • 6. Re: TNS:connection closed
    EBSDBA Expert
    Currently Being Moderated
    Hi,

    Do you see any errors in the alert log file?

    Post the output of lsnrctl status $ORACLE_HOME from db Tier

    Post the contents of sqlnet.ora from from DB $TNS_ADMIN.

    Thanks

Legend

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