I am very very new to Oracle. Any help reg. the
below will be highly appreciated.
If in a networked environment I need to setup client access
to an Oracle server, how do I implement the following:
a) I have created different DNS entries for my server based on the
applications I use it for. I intend allowing users to use the DNS entry that applies to them.
b) I need a way to tie the DNS entries with the Oracle instance
and keep it on a shared drive on the network and let the clients
map to that drive and access the interface entries.
I am basically a Sybase DBA and those who are familiar with Sybase
will relate this to the SQL.INI file. My question is whether there is
an equivalent of SQL.INI in Oracle 9i and if so, how to set it up
so that the above is achieved.
Thanks for your reply. This is pretty much what I was looking for.
Can you clarify to me whether the TNSNAMES.ora can be kept in
a network drive and some environment variable can point to that
location from each client ?
Yes, you can keep the file on a shared resource. In fact it is highly recommended, as it is too easy to end up with multiple versions of TNSNAMES.ORA throughout an organization if client copies are kept locally. You can set this up through the SQLNET.ORA file in the same directory.