Database Networking (MOSC)

MOSC Banner

12c: Where does the DB reference a SQLNET.ORA when GRID and RDBMS are present?

edited Apr 25, 2016 4:31PM in Database Networking (MOSC)

In both RAC and standalone installations where both an RDBMS_HOME and GRID_HOME are present, the database will reference a sqlnet.ora file in its own home.  In other words, for any sqlnet.ora file changes that are to impact the database (including Oracle Net tracing, DCD, etc), the sqlnet.ora file that should be edited would be located in:   RDBMS_HOME/network/admin

Obviously, this would not be the case if a $TNS_ADMIN variable is set in the database's environment AND it points to a different directory.  We can verify this using the following LSNRCTL commands:

LSNRCTL>set current_listener <listener name here>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center