Search Order for TNS files - listener.ora, sqlnet.ora, tnsnames.ora ..etc.
(Doc ID 464410.1)
Last updated on SEPTEMBER 04, 2024
Applies to:
Oracle Net Services - Version 9.2.0.2 and laterOracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version All Versions and later
Generic UNIX
Note that this does not apply to Enterprise Manager which searches ORACLE_HOME/network/admin unless TNS_ADMIN is set.
Goal
The goal of this document is to explain how Oracle Net searches for the configuration files listener.ora, sqlnet.ora, tnsnames.ora and cman.ora.
Solution
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
| Goal |
| Solution |
Search order for the sqlnet.ora |
| Search order for the cman.ora, listener.ora, and tnsnames.ora |
Search order for ldap.ora |
| References |