AKAIK tnsnames.ora will always be supported. Oracle Names is being dropped in 9i in favor of LDAP, and since 8i Oracle ships a new LDAP compliant directory server called Oracle Internet Directory with the database. You can also use any other LDAP directory server such as Microsoft Active Directory. LDAP will allow you not only to resolve database service names, but also authenticate clients with an SSL connection. In fact with LDAP authenticated clients, you can map an LDAP user to a particular database and schema and have the database authenticate that user without even having to create a schema for him/her (or so the documentation states). It will also allow you to include Oracle in an enterprise-wide single sign-on solution. Since Onames is dropped in 9i, they will provide a program called Names Proxy. It will look and act like an Onames server from the client's perspective, but uses an LDAP back end.
HOSTNAME is another method they now support for database resolution. The way it works is you set up a DNS alias with the same name as the database SID, then specify that alias as the database service name. The listener needs to be on port 1521 for this to work. You can still have multiple databases on one server, just set up different DNS aliases for each one.
Paul Sheahan <[EMAIL PROTECTED]> wrote:
Can anyone shed some light on this?
I heard that Oracle is going toward a DNS solution and going away from
tnsnames.ora and the Oracle Naming Service. Is this true?
We are looking to place a naming solution in our environment and I want to
know which direction to head in. Also, if possible, I would like users to
only see the databases they need to see, which is the main problem we have
right now using a global tnsnames.ora file. Limiting users' views to only
what they have a business need to see is an important step in many steps to
secure the environment. I don't see how this would be accomplished using
DNS.
Comments?
Thanks,
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Sheahan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
S! ! an Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
