Oracle Database Discussions

Hi folks,

Hope you can help, new user to the Oracle forum in search of some assistance.

I have oracle client 6i installed and have a centralised TNS_ADMIN share setup. I have this included in the registry under both the HKLM\SOFTWARE\ORACLE\HOME0 (only home on the PC) and HKLM\SOFTWARE\ORACLE . I also have it definied in a system envionment variable. The good news is that when I tnsping80 a database instance, it sees the path defined in TNS_ADMIN and then reads the tnsnames.ora file on the network share and resolves successfully. However, it does not read the settings from the sqlnet.ora file stored on the network share, instead it nly looks at $ORACLE_HOME\NET80\ADMIN and does not attempt to look in the TNS_ADMIN path for a sqlnet.ora file (I verified this using procmon).

Can you guys perhaps advise why this is the case? There are no local SQLNET.ora or TNSNAMES.ora stored on the PC (the whole idea was we wanted to centralise both of these files to a network share using TNS_ADMIN).

Any ideas at all?

Best Regards,
Will.