• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

What is the Search Order for TNS files – listener.ora, sqlnet.ora, tnsnames.ora

by admin

This post explains how Oracle Net searches for the configuration files listener.ora, sqlnet.ora, tnsnames.ora and cman.ora. Oracle Net Services configuration files are not always located in the $ORACLE_HOME/network/admin directory. Depending on the file, Oracle Net uses a different search order to locate the file.

Search order for the sqlnet.ora

1. The directory specified by the TNS_ADMIN environment variable, if set.
2. The $ORACLE_HOME/network/admin directory.
3. In RAC, the sqlnet.ora file referenced by the instance would be in RDBMS_HOME/network/admin and NOT the GRID_HOME/network/admin.

Search order for the cman.ora, listener.ora, and tnsnames.ora

1. The directory specified by the TNS_ADMIN environment variable, if set.
2. One of the following directories:
On Solaris: /var/opt/oracle
On other platforms: /etc
3. The $ORACLE_HOME/network/admin directory.

Note: If TNS_ADMIN is set at the system level, that is the ONLY location that will be searched.
Oracle Database : What Is The Search Order For The LDAP.ORA File

Filed Under: oracle

Some more articles you might also be interested in …

  1. Oracle Database 12c New Feature – Move a Datafile Online
  2. Truncate Table Statement: REUSE STORAGE VS DROP STORAGE
  3. How to Verify if Oracle Active Data Guard is Enabled
  4. How to connect sqlplus without tnsnames.ora
  5. How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6
  6. Log file locations for Enterprise Manager Cloud Control 13c (OMS)
  7. Beginners Guide to Oracle Temporary Tablespaces
  8. Oracle RMAN Pluggable Database Point in Time Recovery
  9. How to Backup and Restore Java Classes and Privileges only in Oracle Database
  10. Oracle 12.2 : RMAN Cross-Platform Transport of PDB into Destination CDB

You May Also Like

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright