OCI Fails With ORA-12153: TNS: Not Connected After Migrating to Linux
(Doc ID 1420127.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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:
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 |