ORA-12537: TNS: connectionclosed

ORA-12537: TNS: connectionclosed

ORA-12537: TNS: connection closed

Error: ORA-12537: TNS: connection closed.

Environment:

Oracle: 11.2.0.2

OS: LINUX 5.6

Environment: RAC

NODE1: 10.20.31.36

NODE2: 10.20.31.38

[Oracle @ ract1 ~] $ Sqlplussys/oracle@10.20.31.36: 1521/racdbas sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Tue Jan 15 16:19:04 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

ERROR:
ORA-12537: TNS: connection closed

Using the same listener, you can log on to the ASM instance.

[Oracle @ ract1 ~] $ Sqlplussys/oracle@10.20.31.36: 1521/+ ASMas sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Tue Jan 15 16:32:29 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>

It's okay to log on to node 2.

[Oracle @ ract1 ~] $ Sqlplussys/oracle@10.20.31.38: 1521/racdbas sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Tue Jan 15 16:33:46 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

Listener Configuration:

[Oracle @ ract1 admin] $ cat sqlnet. ora
# Sqlnet. ora. ract1 Network Configuration File:/grid/product/11.2.0/network/admin/sqlnet. ora. ract1
# Generated by Oracle configuration tools.

NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

ADR_BASE =/grid/app

# Tcp. validnode_checking = yes

[Oracle @ ract1 admin] $ cat listener. ora
LISTENER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER) # line added by Agent
# Listener. ora. ract1 Network Configuration File:/grid/product/11.2.0/network/admin/listener. ora. ract1
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER_SCAN1 ))
)
)

Listener status:

[Oracle @ ract1 ~] $ Lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0-Production on 15-JAN-2013 16:40:42

Copyright (c) 1991,201 0, Oracle. All rights reserved.

Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0-Production
Start Date 15-JAN-2013 16:06:59
Uptime 0 days 0 hr. 33 min. 43 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/grid/product/11.2.0/network/admin/listener. ora
Listener Log File/grid/app/diag/tnslsnr/ract1/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = LISTENER )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 10.20.31.36) (PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 10.20.31.37) (PORT = 1521 )))
Services Summary...
Service "+ ASM" has 1 instance (s ).
Instance "+ ASM1", status READY, has 1 handler (s) for this service...
Service "racdb" has 1 instance (s ).
Instance "racdb1", status READY, has 1 handler (s) for this service...
Service "racdbXDB" has 1 instance (s ).
Instance "racdb1", status READY, has 1 handler (s) for this service...
The command completed successfully

The log for reporting ORA-12537: TNS: connection closed is as follows:

[Grid @ ract1 alert] $ pwd
/Grid/app/diag/tnslsnr/ract1/listener/alert
[Grid @ ract1 alert] $ cat log. xml
Type = 'unknown 'level = '16' host_id = 'ract1'
Host_addr = '10. ipv31.36 'version = '1'>
15-JAN-2013 16:43:01 * (CONNECT_DATA = (CID = (PROGRAM =) (HOST = ract1) (USER = grid) (COMMAND = status) (ARGUMENTS = 64) (SERVICE = LISTENER) (VERSION = 186647040) * status * 0


Type = 'unknown 'level = '16' host_id = 'ract1'
Host_addr = '10. ipv31.36 '>
15-JAN-2013 16:43:03 * (CONNECT_DATA = (SERVICE_NAME = racdb) (CID = (PROGRAM = sqlplus @ ract1) (HOST = ract1) (USER = oracle ))) * (ADDRESS = (PROTOCOL = tcp) (HOST = 10.20.31.36) (PORT = 47268) * establish * racdb * 12518


Type = 'unknown 'level = '16' host_id = 'ract1'
Host_addr = '10. ipv31.36 '>
TNS-12518: TNS: listener cocould 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


Type = 'unknown 'level = '16' host_id = 'ract1'
Host_addr = '10. ipv31.36 '>
15-JAN-2013 16:43:05 * service_update * racdb1 * 0