OCI Fails With ORA-12153: TNS: Not Connected After Migrating to Linux

(Doc ID 1420127.1)

Last updated on JULY 05, 2017

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

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