Re: Oracle Names - config files wanted

Andreas Moroder <amoroder_at_se-nord.provinz.bz.it> wrote in article <01bd7cb6$dd4c5020$1405350a_at_andreas.se-nord.provinz.bz.it>...
> Hallo Connor,
>
> on the client side you must do the following things
>
> 1. change to the orawin95\network\admin directory
>
> 2. delete the tnsnames.ora file ( dont forget to back it up )

Why delete the file??? You can use both TNSNAMES and ORANAMES.

>
> 3. open the sqlnet.ora file
>
> change the line
>
> names.directory_path = (TNSNAMES)
>
> to
>
> names.directory_path = ORANAMES

Or you can use names.directory_path = (ORANAMES,TNSNAMES) This allows for centrally managed Oracle Names and private TNSNAMES if the user so desires.
>
> Thats all for the client side
>

Well, not quite.
In order to use Oracle Names you must have a NameServer running. How do you know where the NameServer is located? The following are additional SQLNET.ORA parameters.

NAMES.PREFERRED_SERVERS =

      (ADDRESS_LIST =
        (ADDRESS = 
          (COMMUNITY = TCP1)
          (PROTOCOL = TCP)
          (Host = host1)
          (Port = 1527)
        )
        (ADDRESS = 
          (COMMUNITY = TCP1)
          (PROTOCOL = TCP)
          (Host = host2)
          (Port = 1527)
        )
        (ADDRESS = 
          (COMMUNITY = TCP1)
          (PROTOCOL = TCP)
          (Host = host3)
          (Port = 1527)
        )
      )

This gives the hierarchy of NameServer searching; obviously for redundancy.  

The NAMES.ORA file required on the NameServer host is not quite as easily exampled. Much depends on your particular environment. I would strongly suggest using Oracle Network Manager to create the configuration files.

I'll gladly provide any other specifics if I can.

Thomas Vanya
Database Administrator
Eastman Chemical Company
>
>
> Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> schrieb im Beitrag
> <3556973E.7FA2_at_bhp.com.au>...
> > We're looking at setting up Oracle Names...If anyone could mail/post
> > some sample config files (server and client), it would be most
> > appreciated
> >
> > Cheers
> > C.
> >
> > --
> > ==========================================
> > Connor McDonald
> > BHP Information Technology
> > Perth, Western Australia
> > "These views mine not BHP..etc etc"
> >
> > "The only difference between me and a madman is that I am not mad."
> >
>
Received on Wed May 13 1998 - 00:00:00 CDT