Oracle 8i Question

I am trying to do a name server on oracle 8i - I have it all installed and I used the wizard in order to create a database and I just want to be able to connect to the database without writing the Tnsnames.ora file on the client. Do you know an easier way to do that? Also do I need a DHCP server to get the Nameserver to work?

John316

Your client does not need a tnsnames.ora file. It will need a sqlnet.ora in the oracle\network\admin folder. The sqlnet.ora would look something like:

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = prodbox)(PORT = 1526))
)
NAMES.DIRECTORY_PATH = (ONAMES)

You would replace "prodbox" with the name of the server running Oracle Names. As a prerequisite, the client PC must be able to successfully ping prodbox.

Thanks for your help sbrock

John316