RE: sqlnet.ora problem

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <Andrew.Kerber@xxxxxxx>, <jkstill@xxxxxxxxx>, <cjnewman@xxxxxxxx>
  • Date: Mon, 20 Aug 2007 15:29:34 -0400

If you do:

truss tnsping some_connect_string

 

You should be able to see which order the various config files are
searched in.

 

-Mark

 

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kerber, Andrew W.
Sent: Monday, August 20, 2007 2:30 PM
To: jkstill@xxxxxxxxx; cjnewman@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: sqlnet.ora problem

 

I am not sure when it checks for .sqlnet.ora, though I have been told
its in the sequence.  Here are the other places I know it checks (in no
particular order):

 

 

 

$ORACLE_HOME/network/admin/sqlnet.ora

$TNS_ADMIN:sqlnet.ora

/var/opt/oracle/sqlnet.ora

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Monday, August 20, 2007 12:12 PM
To: cjnewman@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: sqlnet.ora problem

 

 

On 8/18/07, Chris Newman <cjnewman@xxxxxxxx> wrote:

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.


Is there a $HOME/.sqlnet.ora ?

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

------------------------------------------------------------------------
------
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system. Thank you.

========================================================================
======

Other related posts: