Home -> Mailing Lists -> Oracle-L -> RE: Where does sqlnet.ora live

RE: Where does sqlnet.ora live

From: <TESTAJ3_at_nationwide.com>
Date: Thu, 17 Sep 2009 10:53:02 -0400
Message-ID: <OFFBD5686A.99ADAD4D-ON85257634.0051B75D-85257634.0051C2A2_at_lnotes-gw.ent.nwie.net> 





Then there is the "hidden" files in unix, it should read .sqlnet.ora file 
in $HOME and/or local directory if i remember right.



joe





Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668


(Cell) 614-312-6715



Interested in helping out your marriage?
Ask me about "Weekend to Remember"


Dec 11-13, 2009 here in Columbus.






From:


Herald ten Dam <Herald.ten.Dam_at_superconsult.nl>
To:


"Richard.Goulet_at_parexel.com" <Richard.Goulet_at_parexel.com>
Cc:


Oracle-L Freelists <oracle-l_at_freelists.org>
Date:


09/17/2009 10:44 AM


Subject:


RE: Where does sqlnet.ora live


Sent by:


oracle-l-bounce_at_freelists.org





According to Metalink document 464410.1 the sequence is the next:
 
 


Search order for the sqlnet.ora


    
  
  1.   The directory specified by the TNS_ADMIN environment variable, if 
set .
  
  2.   The $ORACLE_HOME/network/admin directory. 
 





Search order for the cman.ora, listener.ora, and tnsnames.ora


    
  
  1.   The directory specified by the TNS_ADMIN environment variable, if 
set.
  
  2.   One of the following directories: 
        On Solaris:
              /var/opt/oracle
        On other platforms: 
             /etc 
  
  3.   The $ORACLE_HOME/network/admin directory
 





Herald ten Dam


www.superconsult.nl
 
 


Van: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] namens 
Goulet, Richard [Richard.Goulet_at_parexel.com]
Verzonden: donderdag 17 september 2009 16:31
Aan: oracle-l


Onderwerp: Where does sqlnet.ora live



This is a post for a friend who at the moment does not have posting 
privileges.  Steve could I kindly ask you to check on that fact for me?? 
Thanks.


Dick Goulet 


Senior Oracle DBA/NA Team Lead 


PAREXEL International 


900 Chelmsford St, Suite 310 


Lowell, MA 01821 


978.614.2857 


Richard.Goulet_at_PAREXEL.COM 


SUBJECT: Default Search Hiearchy for Oracle 
EMAIL ADDRESS: george.rusnak.ctr_at_deca.mil 



Please, I need some help/clarification. 
What is the default search hierarchy for Oracle to locate the sqlnet.ora 
file and the tnsnames.ora file(s)? 


I found an Oracle doc that stated: 


By default, Oracle Net configuration files are sought and resolved from 
the following locations: 


  1 TNS_ADMIN environment variable (incl. Windows Registry Key) 
  2 /etc or /var/opt/oracle (Unix) 


  3 $ORACLE_HOME/network/admin (Unix) 


  4 %ORACLE_HOME%/Network/Admin or %ORACLE_HOME%/Net80/Admin (Windows) 
I ran: 


truss tnsping 'sqlplus opsdba/xxxxxxxx_at_pcrpi' 2>&1 | grep sqlnet.ora 
access("/opt/oracle/product/10.2.A/network/admin/sqlnet.ora", F_OK) 
ERR#2 ENOENT 



access("/opt/oracle/product/10.2.A/network/admin/sqlnet.ora", F_OK) 
ERR#2 ENOENT 



I do not have an sqlnet.ora file at this location, so the error message 
is correct but I do have a sqlnet.ora in /etc yet it did not find it. 
ls -lai /etc/sqlnet.ora 


   -rw-r--r--   1 oracle     dba           1049 Sep 10  2008 
/etc/sqlnet.ora 


Next test: 


truss tnsping 'sqlplus opsdba/xxxxxxx_at_pcrpi' 2>&1 | grep tnsnames.ora 
access("/home/rusnakga/.tnsnames.ora", F_OK) 
ERR#2 ENOENT 



access("/etc/tnsnames.ora", F_OK) 


= 0 



stat("/etc/tnsnames.ora", 0x800003fffb0f4de0) 


= 0 



open("/etc/tnsnames.ora", O_RDONLY|O_LARGEFILE, 0666) 


= 3 



I do not have a .tnsnames.ora in my home directory so, I can understand 
that error and it continued its search. 
I do not have a tnsnames.ora in $ORACLE_HOME but no indication Oracle 
looked there. 


I do have a tnsnames.ora in /etc and it found it. 
TNS_ADMIN was not set. 


So, what is the search order for sqlnet.ora and tnsnames.ora?? How can I 
verify the search it goes through? 


The server is: HP-UX XXXXXXXXX B.11.11 U 9000/800 


      Oracle:   10.2.0.4.0 



TIA, 



Al Rusnak 


Database Administrator 


ManTech International Corporation 


Fort Lee, Virginia 


Phone: 804.734.8000  ex. 48210 


Email: george.rusnak.ctr_at_deca.mil 



The information transmitted in this communication is intended only for the 
person or entity to which it is addressed and may contain confidential 
and/or privileged material. Any review, retransmission, dissemination or 
other use of, or taking of any action in reliance upon, this information 
by persons or entities other than the intended recipient is prohibited. If 
you received this in error, please destroy any copies, contact the sender 
and delete the material from any computer.




--
http://www.freelists.org/webpage/oracle-l


Received on Thu Sep 17 2009 - 09:53:02 CDT












Original text of this message