Today there is a friend of this situation, when using plsql to connect to the database prompts ORA-12537: TNS: Connection closed.
Today, a friend has such a situation, in the use of pl/SQL to connect to the database prompts ORA-12537: TNS: Connection closed.
Today, a friend has such a situation, in the use of pl/SQL to connect to the database prompts ORA-12537: TNS: Connection closed.
View the process (simulated process for confidentiality ):
View process:
1) view the client tnsname. ora file information as follows:
# Tnsnames. ora Network Configuration File: E: \ softsetup \ Oracle_client \ oracle_base \ network \ admin \ tnsnames. ora
# Generated by Oracle configuration tools.
RHYS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.101) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = RHYS)
)
)
No problem
2) view the server listening status
[Oracle @ oracle-one ~] $ Lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0-Production on 01-NOV-2013 11:19:35
Copyright (c) 1991,201 3, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle-one) (PORT = 1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0-Production
Start Date 01-NOV-2013 11:08:41
Uptime 0 days 0 hr. 10 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/opt/app/oracle/product/11.2.0/dbhome_1/network/admin/listener. ora
Listener Log File/opt/app/oracle/diag/tnslsnr/oracle-one/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = oracle-one) (PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
Services Summary...
Service "RHYS" has 1 instance (s ).
Instance "RHYS", status READY, has 1 handler (s) for this service...
Service "RHYSXDB" has 1 instance (s ).
Instance "RHYS", status READY, has 1 handler (s) for this service...
The command completed successfully
[Oracle @ oracle-one ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.4.0 Production on Fri Nov 1 11:19:38 2013
Copyright (c) 1982,201 3, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter service
NAME TYPE VALUE
-----------------------------------------------------------------------------
Service_names string RHYS
SQL>
Normal
3) Use tnsping on the client:
C: \ Users \ Administrator> tnsping rhys
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0-Production on 01-11-
11:10:05 2013
Copyright (c) 1997,201 0, Oracle. All rights reserved.
Used parameter files:
E: \ softsetup \ oracle_client \ oracle_base \ network \ admin \ sqlnet. ora
Alias resolved using TNSNAMES Adapter
Try to connect (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.1
68.56.101) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = RHYS )))
TNS-12547: TNS: Lost connection
C: \ Users \ Administrator>
For more details, please continue to read the highlights on the next page:
Related reading:
SPFILE error causing database startup failure (ORA-01565)
ORA-01172, ORA-01151 error handling
ORA-00600 [2662] troubleshooting
Troubleshooting for ORA-01078 and LRM-00109
Notes on ORA-00471 Processing Methods
ORA-00314, redolog corruption, or missing Handling Methods
Solution to ORA-00257 archive logs being too large to store