oracle 12537,在线等解决ora-12537错误

Subject:         ORA-12537 When Using a 10.2 Listener to Service a 10.1 Database

Doc ID:         343536.1         Type:         PROBLEM

Modified Date:         07-FEB-2008         Status:         PUBLISHED

In this Document

Symptoms

Cause

Solution

Checked for relevance on 07-FEB-2008

Applies to:

Oracle Net Services - Version: 10.1 to 10.2

This problem can occur on any platform.

This problem occurs on Unix.

Symptoms

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 10.1.0.4.0 - Production on Tue Dec 6 14:40:44 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

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

Cause

With a dynamically registered service handler, the 10.1 database supplies the 10.2 listener with its local environment variables including the path to (10.1) libraries that the client must use to make the connection.

In a situation where the service handler is statically defined, the listener may not have the appropriate library path needed for the connection.

Solution

Provide the library path of the target database home in the static handler definition of the listener.ora.

To do this, use the listener parameter ENVS parameter to specify environment variables for the listener to set prior to executing

(as a child process) a dedicated server process.

Usage:   (ENVS="variable=value")

Example (Solaris):

(SID_DESC =

(GLOBAL_DBNAME = N101.us.oracle.com)

(ORACLE_HOME = /u01/app/oracle/product/10.1.0)

(SID_NAME = N101)

(ENVS = "LD_LIBRARY_PATH=/u01/app/oracle/product/10.1.0/lib")

)

Keywords

ENVS; LISTENER.ORA; STATIC;

Help us improve our service. Please email us your comments for this document. .