ORA-12537: TNS:connection closed

Giving below error when trying to connect oracle user

ERROR:

Sqlplus scott/tiger@PROD

SQL*Plus: Release 10.2.0.1.0 – Production on Thu Oct 16 15:06:46 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

SOLUTION:

Add the relevant LD_LIBRARY_PATH into the SID_DESC section in listener.ora file

(SID_DESC =
(ORACLE_HOME = /home/oracle/product/1020)
(ENVS=”LD_LIBRARY_PATH=/home/oracle/product/1020/lib:/usr/dt/lib:/usr/openwin/lib”)
(SID_NAME = PROD)
)

 

Thank You !!

By Oracle-DBA-masters, on February 13, 2014 at 10:30 am, under Oracle database. Tags: , . 1 Comment
Post a comment or leave a trackback: Trackback URL.

Comments

  • Gagan Kundra  On May 17, 2018 at 3:57 am
    Permalink | Reply

    Sir I am trying to open APEX by entering 127.0.0.1:8080/apex without success.

    When it TNSping 127.0.0.1:8080, then I am encountering this error

    TNS-12537: TNS:connection closed

    Please help me resolve this.

Leave a comment