RE: Oracle Names

From: Odland, Brad <Brad.Odland_at_qtiworld.com>
Date: Thu, 12 Jun 2003 12:09:42 -0700
Message-ID: <F001.005B086A.20030612114205@fatcity.com>

Use names...

We have two Linux oracle boxes onames1 and onames2 serving up names for serveral hundred clients. In the past 40 days over 600,000 requests have gone through these two boxes.

We alias the hostnames in DNS to onames1 and onames2 so in the sqlnet.ora the preferred names section will never have to be changed.

Names is forgotten because Oracle wanted everyone to use OID...(yuk). Names is small fast and robust. Configure and forget it. YOu use netasst or netmgr to manage the entries or namesctl....easier in the GUI. There are some patches to install on a client to fix the netasst crash when selecting a names server. It is really noce to not have to dick with TNSNAMES files and associated entries. Security wise if people do not know the host, SID and port they can't get logon. Names is able to hid the details of this from people. A tnsnames file that is shared is horrible because if it is unavailalbe then everyone is out. Pushing TNSNAMES is a pain. (for who ever has to do it) You can use aliases within names too...

I have never seen a names server process fail once configured.

Go gor it. YOu'll be glad you did.

Brad O.

-----Original Message-----
Sent: Thursday, June 12, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L

We are starting a project that will eventually have 500 laptops wandering around in the wild. These will have an Access database for untethered use, and will periodically connect to Oracle via Net8 to resynchronize itself. The idea of changing 500 tnsnames.ora files sometime down the line is daunting. I've been studying for the OCP Net8 exam, and they mention Oracle Names.

Are any of you using the Oracle Names?
Is it as easy to configure as Oracle makes it sound, or is it difficult?
Is Names reasonably robust? I can see this as yet another single point of failure.
Oracle hinted that Oracle Names is going away in favor of LDAP. Is this imminent, or just a scare tactic? I had held off using Names because of this, but the company has made a commitment to MS Active Directory, which I gather from the list postings isn't very compatible with Oracle's LDAP.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------