Database Networking (MOSC)

MOSC Banner

Listener not using sqlnet.ora file defined via TNS_ADMIN

edited Aug 2, 2012 7:11AM in Database Networking (MOSC) 3 commentsAnswered
I'm setting up a second listener for my DB.  I want this second listener to only accept encrypted connections. 

Here is how I attempted to do it:

- create $ORACLE_HOME/network/admin/secure directory

- in the secure directory, make links for the listener.ora, tnsnames.ora, ldap.ora.   Physically create a sqlnet.ora file and edit it with the appropriate encryption parameters.

- add the second listener to the listener.ora file.  In this second listener, use the ENVS variable to set the TNS_ADMIN variable to $ORACLE_HOME/network/admin/secure directory

Pretty simple right?  But it isn't working.  For some reason even though the TNS_ADMIN variable is set, the sqlnet.ora in the secure directory isn't be read.  Tracing the listener show that the encryption parameters aren't being set as expected.

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