Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> sqlnet.ora problem
Hello,
Running 10.2.0.3 on Solaris 10, 64bit. I'm attempting to implement tcp.validnode_checking. It appears however that my sqlnet.ora file is *not* being read.
TNSLSNR for Solaris: Version 10.2.0.3.0 - Production on 18-AUG-2007
System parameter file is
/services/oraclesp/10g/network/admin/listener.ora
Log messages written to /services/oraclesp/10g/network/log/listener.log
Trace information written to
/services/oraclesp/10g/network/trace/listener.trc
Trace level is currently 0
This is what shows when starting the listener; the sqlnet.ora file however has these parameters:
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
TCP.VALIDNODE_CHECKING = TRUE
TCP.INVITED_NODES = (localhost,10.10.10.10, etc, etc)
TRACE_LEVEL_SERVER = 16
TRACE_DIRECTORY_SERVER = /services/oracle/sqltrace
It looks like the sqlnet.ora is NOT being picked up, based on both the trace level and the trace directory.
Lsnrctl status also reports the 'wrong' information as the trace being set to 'off' and the trace directory as
'/services/oraclesp/10g/network/trace/listener.trc'.
So why isn't my sqlnet.ora being picked up? I've verified that it is the only one on the box, its permissions are RW for oracle and it is located in the listener directory (in this case /services/oraclesp/10g/network/admin'. I've also grepped for 'listener.trc' and it doesn't appear in any file on the box, so it must be a default.
Any thoughts would be great.
Thanks- Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 18 2007 - 09:49:50 CDT