OCI Fails With ORA-12153: TNS: Not Connected After Migrating to Linux
(Doc ID 1420127.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation 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)
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |