Re: Accessing two oracle names server.

From: Al <al_at_work>
Date: 1998/05/13
Message-ID: <6jc7rg$7k66_at_piper.ncr.pwgsc.gc.ca>#1/1


You will always connect to the first names server, if it is available. The software does not "fall through" to the second server if the database name can not be resolved by the first names server.

We have set names.use_plug_and_play=on, and use the default oranamesrvr0 to keep our names servers syncronized.

names.preferred_servers =
 (address_list =
  (address =

   (protocol=tcp)
   (host = OTT41)
   (port = 1575)

  )
  (address =
   (protocol=tcp)
   (host = oranamesrvr0)
   (port = 1575)

  )
 )

Nancy Teh wrote in message <3557F57E.19655257_at_cc.monash.edu.au>...
>Hi there,
>
>Have someone out there ever try to access 2 oracle names from their PC
>oracle client8.
>
>I manage to use only one oracle names server.
>
>There is an option in sqlnet.ora on the PC client that allow the user to
>specified their NAMES.PREFERRED_SERVER. I tried specifying two oracle
>names servers from two different servers, but manage only to connect to
>instances from the first names server.
>
>What are the things I should look for?
>Does the domain play any significant role?
>
>Thank in advance.
>
>Reards,
>Nancy Teh
>______________________________________________________________________
>Nancy Teh
>Email:Nancy.Teh_at_cc.monash.edu.au
>Australia
>______________________________________________________________________
Received on Wed May 13 1998 - 00:00:00 CEST

Original text of this message