ORA-12537: TNS: Connection closed and TNS-12547: TNS: Lost connection

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