Re: Oracle Names Server - Help!

To get around namesctl prompting you upon a start or stop, you can add these lines to your sqlnet.ora:

    namesctl.noconfirm = on
    namesctl.server_password = your_password

In our setup a "namesctl reload" always works (and we update our configuration often).

I'm not sure I understand the original problem, but I would think that if names was unsuccessful in resolving a name in cache, you would NOT want it to check the database. If it did, then every typo someone made would degrade nameserver's performance. What we do is: update the namesserver database with NETMAN (pre net8, but should be similar?), then from within netman, click on "reload namesservers" which forces a reload on all of our nameservers, and everyone can see the new tnsname. If you can still force the reload from net8's configuration tool, then you won't need to bother with scripts to start, stop or reload nameservers.

joe kazimierczyk
kazimiej_at_bms.com

carl christianson wrote:

> 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
Received on Mon Mar 08 1999 - 15:14:21 CST