Re: oracle names server question

From: Karel Novotny <knovotny_at_per4mance.cz>
Date: Sun, 10 Jan 1999 14:29:13 GMT
Message-ID: <3698B938.D53AAED4@per4mance.cz>

You do not have to use well-known server but you must (in this case) set up sqlnet.ora file on all Oracle clients where you want to use name server naming. New SQLNET.ORA lines:

---

names.directory_path = (TNSNAMES,ONAMES,HOSTNAME) names.preferred_servers =

                (ADDRESS_LIST =
                  (ADDRESS =


                     (COMMUNITY = tcp.world)


                     (PROTOCOL = TCP)


                     (Host = oranamesrvr0)


                     (Port = 1575)


                  )
                  (ADDRESS =


                     (COMMUNITY = tcp.world)


                     (PROTOCOL = TCP)


                     (Host = oranamesrvr1)


                     (Port = 1575)


                  )
                )
--------------------------------------------

Of course, you can change your own host and port parameters, and create more or fewer name server sections.
You can specify different parameter order in names.directory_path. ONAMES means nameserver info querying order position. TNSNAMES is for local tnsnames.ora file, HOSTNAME is new feature of finding database through database hostname - see guide.
Additionally - well-known servers was functionality of SQLNet 2.3 clients and I'm not sure that it is functional in SQLNet versions 8.x - it means - set up sqlnet.ora parameters anyway if you want to use Oracle nameserver.

For configuration of OracleNameServer there is simple way I used on WinNT and so SGI Indy and Oracle 8.04:

---

Start OracleNameServer service - according to guide (namesctl start) Start Net8Assistant
Configure Net parameters (tnsnames.ora file) for all aliases your Oracle clients refers/need
Save It!!!
In menu - start "Discover Name Servers" Restart Net8Assistant as recommended
Expand NameServer tree
previously started nameserver appears (maybe) Select discovered nameserver line in tree Select Data configuration (or as it names) in DropDownList Select load from file
Browse tnsnames.ora file from disk
push LOAD
Save all configuration
Restart name server service
Well, it's running! Or not?

!!!!!!!!! Do not start Net8Assistant or any other Oracle java-based Assistant on machine with less then 256 colors display. It hangs. !!!!!!!!!!!!

Jia He wrote:

> Continue with this thread, any one has information about a good starting
> point to set up the
> Oracle Names Server?  Do I have to use well-known server?   I want to avoid
> it, because this
> will invovle our network admin guy ......
>
> Eric He
> DBA
> Phoenix Interantional
> mgogala_at_rocketmail.com wrote in message <776ro6$kja$1_at_nnrp1.dejanews.com>...
> >In article <7766gb$2ve$1_at_nnrp1.dejanews.com>,
> >  steve_young_at_my-dejanews.com wrote:
> >> I have the oracle names server up by using the net8 assistant. I am still
> >> getting confused and have few questions: 1. Do I need to bring the
> listener
> >> down on the server where oracle names server are built(and also all other
> >> servers)? 2. How to load the service names into the names server?  I
> tried to
> >> put the same configuration in the manage data manual in net8 assistent
> and I
> >> got the NL- 00051 and NPL-00103 error. What port number should be input
> >> there?
> >>
> >> Thank you!!
> >>
> >> Steve
> >>
> >> -----------== Posted via Deja News, The Discussion Network ==----------
> >> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own
> >>
> >Oracle*Names and Net8 listener are two different services and should be
> >using two different ports. I use 1526 for listeners and 7777 for
> Oracle*Names.
> >Listener doesn't have anything to do with the name server. Name server will
> >continue to work even if listener is down. Database is only needed when
> >the initial values are read during Oracle*Names startup.
> >Mladen Gogala
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Sun Jan 10 1999 - 08:29:13 CST