Re: Oracle Names Server - Help!

Further update,
talking to Oracle Support they indicated that the behaviour I'm seeing is how it works.
There is an entry for expire time which is in seconds. I set that to 1 but the names server doesn't seem to refresh itself. I therefore went down the path of just executing a "namesctl reload" to refresh the names server. Unfortunately that doesn't always work. The only guarnteed way to get it to reload the database information is to do a "namesctl stop", "namesctl start".
The problem with getting this to occur through a script is that "namesctl stop" then prompts you with a yes/no prompt. So having cron just stop/start the names server will be more difficult.

I would like to say that Oracle really doesn't get it. IF I hit the names server and it is unsuccessful resolving a name in the cache YOU WOULD THINK that it would then check the database to resolve the name. Support informs me that is not the way it works. Sigh. Sorry for the Rant...

If anyone has any suggestions on this I'm all ears.... thx
Carl Christianson

carl christianson wrote:

> Hi all,
> I need some information about setting up an Oracle Names Server.
> Oracle 8.0.5. I want to set this up with a database containing the
> information.
> I would then want to have a tracking program that I have that monitors
> my databases go through a dblink and put entries into the names
> database.
>
> To test this I put an entry in to the Names database when I tnsping it
> doesn't resolve the name. However, if I stop the names server and
> re-start it it then can resolve the name. Has anyone else done this
> successfully? It is acting like it reads the database information at
> startup time only. How do I change that behaviour?
>
> thx
> Carl Christianson
Received on Mon Mar 08 1999 - 10:12:43 CST