-
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
Thanks for your help sbrock
John316
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|