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

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