On 29/10/09 15:51, jeff wrote:
External connections Orcale 8: If the remoter server has a username that matches the username of the remote client it will still authenticate. This work in our setup. You don't necessarily have to be local.
This is so only if some idiot has set the parameter remnote_os_authent = true. It is false by default, and the description points to a warning in the Advanced Security Guide which explains why you should not set it true. The same parameter, with the same warning, still exists in 9, 10 and 11. At last, in 11, it is said to be deprecated.
Therefore if seemed to me that the only major thing ORACLE_HOME is being used for is tnsnames.ora.
tnsnales.ora is not used for a bequeather connection. In this case the client's ORACLE_HOME is used in the ways that server-site ORACLE_HOME is used by the listener for a network connection. In perticular it is usne to find the server instance. -- Charles Jardine - Computing Service, University of Cambridge [email protected] Tel: +44 1223 334506, Fax: +44 1223 334679
