Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: When to go for ORACLE NAMES Server

RE: When to go for ORACLE NAMES Server

From: Jesse, Rich <>
Date: Fri, 11 May 2001 12:54:36 -0700
Message-ID: <>

Too much of a kill? Not at all. We are currently running ONAMES, and are planning on going OID as soon as we can get some time. OID (Oracle's LDAP) has other benefits like being able to authenticate more than just Oracle connections.

ONAMES is relatively easy to setup. For your configuration, you will probably want to have a region database (repository), as well as more than one NAMES server running on different boxes for redundancy. With that setup, you can lose the region DB with no loss of service (each NAMES server keeps a local cache which is updated periodically), or either ONAMES server with no loss of connection for your clients.

I hate to say it, but the Java Net8 Assistant does help quite a bit in setting up ONAMES. That is, when it doesn't hang or crash...

When your ONAMES is setup, you will need to modify every client's SQLNET.ORA file to tell the client to resolve database aliases thru Names. Something like this:

          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1)(PORT = 1575))
            (ADDRESS = (PROTOCOL = TCP)(HOST = myserver2)(PORT = 1575))


> -----Original Message-----
> From: Johnson Poovathummoottil []
> Sent: Friday, May 11, 2001 11:15
> To: Multiple recipients of list ORACLE-L
> Subject: When to go for ORACLE NAMES Server
> There is another thread going on about no database on
> a single server, I have another question to ask.
> We have nearly 30 databases across Sun and Win 2000
> Platforms. We are finding it tedious to keep track of
> tnsnames.ora. While looking out for a solution we hit
> at ORACLE Names server. I hear it is going to give way
> to ORACLE Internet directory. But after reading a
> little I think using either would be too much of a
> kill for the problem.
> Any opinions?

Please see the official ORACLE-L FAQ:
Author: Jesse, Rich

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri May 11 2001 - 14:54:36 CDT

Original text of this message