ORA-12537: TNS:connection closed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-12537: TNS:connection closed

  1. #1
    Join Date
    May 2006
    Location
    Maryland
    Posts
    10

    ORA-12537: TNS:connection closed

    I am trying to connect remotely to another linux server. When my servers are started as user 'A' and I connect through sqlplus as system/password@hos from the user 'oracle' i get this error message from the logs:

    TNS-12518: TNS:listener could not hand off client connection
    TNS-12547: TNS:lost contact
    TNS-12560: TNS: protocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

    Our processes are set to 2000 so it isn't the processes. Can anyone help me out?

    Thanks

    DBA

  2. #2
    Join Date
    Oct 2006
    Posts
    175
    Can you post what you have in listener.ora, listener.log and /var/log/messages?

  3. #3
    Join Date
    Apr 2009
    Posts
    21
    How connecting via ssh as user oracle:

    for example

    $ ssh oracle@server

    login as sys as sysdba

  4. #4
    Join Date
    May 2006
    Location
    Maryland
    Posts
    10
    Sorry guys, got busy with other things. Here is the info you requested.

    Listener.ora:
    LISTEN_1521 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST=
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP ADDRESS)(PORT = 1521))
    (SERVICE_NAME = SID)
    )

    listen.log:


    type='UNKNOWN' level='16' host_id='hostname'
    host_addr='IP ADDRESS'>
    18-JUN-2009 10:25:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=hostname)(USER=user 'A'))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listen_1521)(VERSION=185599744)) * status * 0




    I can connect as user oracle via ssh.

    when I am in sqlplus and try to connect remotely I get the error when the listener is started as the user 'A'.
    SQL> conn user/password@hostname.world;
    ERROR:
    ORA-12537: TNS:connection closed

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Your listener seems not configured properly. Please post 'lsnrctl status listner' and 'tnsping' command outputs.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  6. #6
    Join Date
    May 2006
    Location
    Maryland
    Posts
    10

    TNS:Connection closed

    Thanks guys, I think I found out the problem. I still have to test it but it appears that when I do a nslookup it isn't configured correctly. It still has the old domain name. Once I change this hopefully it will fix the issue. Thanks again for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width