OCI Fails With ORA-12153: TNS: Not Connected After Migrating to Linux
Last updated on JULY 05, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2013***
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.
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)
When testing, no core files are produced but ultimately the failure was related to the ofetch OCI function call.
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