Re: Oracle Names Server

Answers embedded
I've read somewhere it will be replaced by LDAP in 9i.

Hth,

Sybrand Bakker, Oracle DBA

<dwilliams_at_lifetouch.com> wrote in message news:91ojds$i9n$1_at_nnrp1.deja.com...
> Does anyone use the Oracle Names Server?
Used it in the past, now on a webserver no need for it (The webserver is on the same server as the database)

> How many client systems do you need before it becomes fesable?

If you have a situation where developers start assembling their own tnsnames.ora, two clients is already sufficient, and anything above 10 mandatory.

> How difficult is it to configure?

Depends on version. In Oracle 7 it is somewhat difficult, Oracle 8 just use the Net8 assistant and click away and you are done.
> How do you test changes before making a change for everyone?

You can always use
names.directory_path=(tnsnames, onames) in your sqlnet.ora and configure your own tnsnames first.

> How do you insulate your ODBC users so they don't have to change their
> ODBC connection when you make an Oracle Names change?

As long as you don't change the service name, you should be safe.
> Are there any good ways to learn more? (I have always had trouble
> reading SQL*Net documentation)
>

The sqlnet doco is all there is.

> We have about a half-dozen client servers, a couple of test servers,
> and a dozen individual workstations with Net8 installed (developers,
> for example). Several times per year we add a new host server or change
> an instance name. Afterward we get calls from people we weren't even
> aware were accessing a particular Oracle.
>
> Thanks for your input.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Dec 19 2000 - 17:05:59 CST