Re: Name Server questions

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

Received on Fri Jul 24 1998 - 16:48:43 CDT