Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2002
    Posts
    17

    Question Unanswered: Oracle Client Access

    Hi,

    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,
    Bujji
    Bujji

  2. #2
    Join Date
    Apr 2002
    Posts
    6
    In case of oracle client u need to install oracle on all the client machine AND just configure the TNSNAMES.ora file on the client machine with a entry like this.


    testserver.VSNL.NET.IN=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    )
    )

    I hope this is what u wanted.

  3. #3
    Join Date
    Apr 2002
    Posts
    17
    Hi Kalai,

    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 ?

    Thanks again.
    Bujji

  4. #4
    Join Date
    Apr 2002
    Posts
    5
    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.

    Regard,
    Jason Woosley

  5. #5
    Join Date
    Apr 2002
    Posts
    17
    Thanks so much Jason
    Bujji

  6. #6
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Easiest is to have a system variable on the client, pointing to the network drive.

    For instance, if you put the tnsnames on P:\settings\tnsnames.ora, add a variable
    TNS_ADMIN
    with value
    'P:\settings'
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  7. #7
    Join Date
    Apr 2002
    Posts
    17
    Hi Ruud,

    Thanks.

    Besides the variable TNS_ADMIN, are there any other variables needed at the client side ?

    How about the server ? Do we have to put the client piece on the box that runs the Oracle DB engine or even that can be pointing to a network drive ?

    Are there any variables that need to be set on the server side?

    Sorry ..there are too many questions !

    Thanks
    Bujji

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •