Re: Name Server questions

Scott, Heidi:

Your well known Names Servers are called oranamesrvr0, oranamesrvr1, etc., must be assigned well known port 1575, and are known to your IP address hostname resolution method, e.g., /etc/hosts, DNS, etc.

Scott Cote wrote:

> Heidi,
>
> If you run the name server in its default mode with Oracle8, then your clients
> should not need ANY client software to find the name server. This is achieved
> through the dynamic discovery option (ddo) of the name server. If you configure
> the listener properly, it will register any service that it represents (a
> service could be a SID or another program) into the name server (this is the
> plug and play - plug and pray part).
>
> Gotchas that you need to be aware of:
>
> 1. This stuff is only good for "simple" networks meaning one protocol.
> 2. A name server has to be running before you start the listeners so that the
> listerners can register their services into the nameserver on startup.
> 3. The listeners have to be configured to look for the nameservers (there can
> be more than one name server).
> 4. The machines that runs the preferred(?) name server needs to have a special
> name - on the tip of my tongue but can't get the name - something like onames0,
> or onames2, ora onames3 (somebody help me with this).
> 5. Name servers on 7.2 => are not as friendly to work with.
>
> I'm sure that there are other issues (just can't remember at this moment).
>
> Programmatically, you should be able to query the name server for all of the
> services that it stores.
>
> If you have Oracle 8 on NT, you can use the Net8 Assistant to configure the
> nameserver.
>
> For your clients, the sqlnet.ora file can be put in place so that if the
> nameserver(s) cannot be found, they can look at a tnsnames.ora file instead.
>
> Hope this helps,
>
> SCott
>
> heidi wrote:
>
> > According to the documentation if you use the name server you don't need to
> > have tnsnames.ora. If this is true I have the following questions:
> >
> > - Is the name server OracleNamesService80?
> > - There is no names.ora file - should I create it? Where?
> > - If I create a new database does this name server have to be refreshed? If
> > yes, how?
> > - Are there any other files that I should be concerned with?
> >
> > What I am trying to do is to hide the creation of a database in our
> > application and allow the user to access it right away. I have found no
> > programatic approach to this in the documentation or through the news
> > groups. It all seems to point to a series of script files, utilities, and
> > commands. My current method involes altering the tnsnames.ora, which may be
> > a nightmare, especially on a network. This is all quite messy, but I have
> > sorted it out and currently I can create a new database, but cannot use it
> > until the ORCL service is restarted or the whole system is rebooted (not
> > quite sure why?). As I was sifting through some documentation I came across
> > the name server approach which may be easier to implement, but I can't seem
> > to find the answers to my questions in the documentation.
> >
> > Should anyone know of even a better way, or perhaps something that I may be
> > out-to-lunch on I would appreciate any bit of advice I can get!
> >
> > thank you,
> > heidi
>
> ------------------------------------------------------------------------
>
> Scott Cote <scottcotexy_at_contractor.net>
> Oracle DBA Consultant
> Hive Software, Inc.
>
> Scott Cote
> Oracle DBA Consultant <scottcotexy_at_contractor.net>
> Hive Software, Inc.
> 710 Rockcrossing Lane Work: (972) 672 - 6484
> Allen Fax: (972) 396 - 7761
> Tx Netscape Conference Address
> 75002 Netscape Conference DLS Server
> USA
> Remember to remove the xy when replying. I had to do this due to spammers.
> Additional Information:
> Last Name Cote
> First Name Scott
> Version 2.1
Received on Fri Jul 24 1998 - 20:44:23 CDT