Re: sqlnet.ora problem

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