My Oracle Support Banner

ORA-12537 Report on Connection to 32 Bit RDBMS via 64 Bit TNS Listener (Doc ID 744383.1)

Last updated on NOVEMBER 03, 2008

Applies to:

Oracle Net Services - Version: 9.2.0.1.0 to 11.1.0.6.0
This problem can occur on any platform.

Symptoms

Connections to 32 bit database via a 64 bit TNS listener fail with error ORA-12537: TNS:connection closed. Connection is using (CONNECT_DATA=(SID=xxx))
Sqlplus screen output

Sqlplus scott/tiger@sample.com

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 16 15:06:46 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

Listener log shows
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=client)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.sample.com)(PORT=1412)) * establish * orcl * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Solaris Error: 32: Broken pipe

Truss of the TNS listener process upon connection attempt will show

5124: LD_LIBRARY_PATH=/home/oracle/product/v10gdb_1/lib:/usr/dt/lib:/usr/openwin/lib

5124: resolvepath("/usr/lib/ld.so.1", "/usr/lib/ld.so.1", 1023) = 16
5124: resolvepath("/oracle/software/v9208/bin/oracle", "/oracle/software/v9208/bin/oracle", 1023) = 44
5124: stat("/oracle/software/v9208/bin/oracle", 0xFFBFEC70) = 0
5124: open("/var/ld/ld.config", O_RDONLY) Err#2 ENOENT
5124: stat("/home/oracle/product/v10gdb_1/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: stat("/usr/dt/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: stat("/usr/openwin/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: stat("/opt/SUNWcluster/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: stat("/apps/oracle/product/9.2.0.8.2007Q1/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: stat("/usr/lib/libodm9.so", 0xFFBFE778) Err#2 ENOENT
5124: write(2, " l d . s o . 1 :   o r a".., 75) = 75
5124: lwp_self() = 1

LD_LIBRARY_PATH is picking up10g Oracle Home setting.
The connection required to use libodm9.so library, which was not found.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.