sqlnet.ora problem
- From: Chris Newman <cjnewman@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 18 Aug 2007 09:49:50 -0500 (CDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
