My Oracle Support Banner

OCI Fails With ORA-12153: TNS: Not Connected After Migrating to Linux (Doc ID 1420127.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2013***

Symptoms

The application is written to the OCI 7 API rather than the newer version of OCI8.

Oracle's documentation states that while the OCI 7 functions are obsolete, they are still available and supported in the latest version of the database.

The application started failing after migrating to Linux RHEL 6 from the HP machine.

The application worked fine for years on HP.


Error Stack:

linux-vdso.so.1 => (0x00007fff9b8c8000)
libocci.so.11.1 => /oracle/orahome/product/11.2.0/lib/libocci.so.11.1 (0x00007f034d30f000)
libclntsh.so.11.1 => /oracle/orahome/product/11.2.0/lib/libclntsh.so.11.1 (0x00007f034ace4000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x000000318ec00000)
libc.so.6 => /lib64/libc.so.6 (0x000000318e800000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x000000319bc00000)
libm.so.6 => /lib64/libm.so.6 (0x000000318f800000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x000000319b800000)
libnnz11.so => /oracle/orahome/product/11.2.0/lib/libnnz11.so (0x00007f034a908000)
libdl.so.2 => /lib64/libdl.so.2 (0x000000318e400000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x000000319c000000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007f034a706000)
/lib64/ld-linux-x86-64.so.2 (0x000000318e000000)


When testing, no core files are produced but ultimately the failure was related to the ofetch OCI function call.

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!

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