ORA-12537 When Using a 10gR2Listener to Service a 10gR1 Database (Doc ID 343536.1)

Last updated on DECEMBER 15, 2011

Applies to:

Oracle Net Services - Version: to - Release: 10.1 to 10.2
Information in this document applies to any platform.
Checked for relevance on 24-DEC-2009.
This problem is limited to Unix platforms.


This problem occurs when a statically defined service handler of a 10.2 listener is used to connect to a 10.1 (or other version) database. The same clients connecting through dynamic service handlers work properly.

[mseibt]/u01/app/oracle/product/10.1.0> sqlplus scott/tiger@n101

SQL*Plus: Release - Production on Tue Dec 6 14:40:44 2005
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ORA-12537: TNS:connection closed


Errors reported in sqlnet client trace:

nioqper: ns main err code: 12537
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 507
nioqper: nt (2) err code: 0
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12537 error as ORA-12537


Errors reported in the listener trace:

sntpcall: Can't read from pipe; err[1] = 32
sntpcall: exit
ntpctl: exit
nserror: entry
nserror: nsres: id=5, op=72, ns=12547, ns2=12560; nt[0]=517, nt[1]=32, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms