6 Replies Latest reply: Dec 20, 2012 3:23 PM by EBSDBA RSS

    TNS:connection closed

    user2996886
      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
          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
            user2996886
            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
              Can you connect to the database remotely?

              Please see the docs referenced in my previous reply.

              Thanks,
              Hussein
              • 4. Re: TNS:connection closed
                user2996886
                no i cannot connect to the database remotely

                Thanks
                Jay
                • 5. Re: TNS:connection closed
                  Hussein Sawwan-Oracle
                  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
                    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