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)
)
Subscribe
Login
0 Comments
Oldest