Results 1 to 3 of 3

Thread: Oracle 8i Question

  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Question 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

  2. #2
    Join Date
    Mar 2003
    Location
    New Zealand
    Posts
    1
    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.

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    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
  •