Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sqlnet.ora problem

sqlnet.ora problem

From: Chris Newman <cjnewman_at_uiuc.edu>
Date: Sat, 18 Aug 2007 09:49:50 -0500 (CDT)
Message-Id: <20070818094950.ATB87401@expms6.cites.uiuc.edu>


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-l
Received on Sat Aug 18 2007 - 09:49:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US