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

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

Re: sqlnet.ora problem

From: Chris Newman <cjnewman_at_uiuc.edu>
Date: Mon, 20 Aug 2007 15:41:47 -0500
Message-ID: <46C9FC8B.4070300@uiuc.edu>


Hello,

Nilo's truss recommendation worked great, I was able to see that the sqlnet.ora was in fact getting picked up. I actually ran it again on a box with no sqlnet.ora and got the exact same messages you show below in your tracefile.

The 'good' trace looks like this:

20274: access("/services/oraclesp/10g/network/admin/sqlnet.ora", 0) = 0 20274: open("/services/oraclesp/10g/network/admin/sqlnet.ora", O_RDONLY) = 3

So no problems there. It turns out that my issue was a syntax problem... I'm not sure how I missed this, but TCP.VALIDNODE_CHECKING=TRUE is not correct, it has to be set to 'YES'. Strange, because most Oracle parameters are 'TRUE', this is actually the first instance I've run across in my limited experience that requires a 'YES'. The logging issue I'm sure is syntax as well, but the IP filtering capability works well.

Thanks- Chris

Ted Coyle wrote:
>
> Grabbed the following from truss tnsping on AIX with no sqlnet.ora.
>
> ORACLE_HOME=u01/app/oracle/product/10.2.0/db_1/
>
> TNS_ADMIN was not set.
>
> * *
>
> *access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora",
> 0) Err#2 ENOENT*
>
> **
>
> *access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora",
> 0) Err#2 ENOENT*
>
> *open("/u01/app/oracle/product/10.2.0/db_1/network/names/.sdns.ora",
> O_RDONLY) Err#2 ENOENT*
>
>
>
> *access("/home/oracle/.tnsnames.ora", 0) Err#2 ENOENT*
>
> *access("/etc/tnsnames.ora", 0) Err#2 ENOENT*
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 20 2007 - 15:41:47 CDT

Original text of this message

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