RE: OID questions

Failover information in Oracle Internet Directory (OID) is entered like Net8 configuration information. You can import the exact information that is in your TNSNAMES.ORA into OID, so if you can code failovers in TNSNAMES.ORA you can put it in OID as well. So you would handle failovers using OID thru a combination of how you set up your databases and Net8.  

You will also want to make sure that you have a failover for the OID database if you decide to use it. If it is your connection server and it isn't up clients obviously can't connect. You can place failover options in SQLNET.ORA and/or the LDAP.ORA file that is used by OID, such as having multiple OID databases or Advanced Replication.  

I have learned the hard way (not on MetaSlop) that OID is not available on Parallel Server yet so thats not an option.  

There is no concise or clear directions available that I know of to get OID installed and working (at least from Oracle). The steps to install and get OID working are found not only in the OID manual. They involve installing OID from the Enterprise Edition CD under Management Infrastructure which creates an OID database or populates one of your choosing, starting OID services, using Oracle Directory Manager to create your particular LDAP context (i.e. banknorth.com), Net8 Configuration Assistant for adding Oracle Administration context under your context, and Net8 Assistant for adding entries from TNSNAMES.ORA under your context. Entries can also be bulk loaded by Oracle scripts which I haven't done yet.  

Piecing it all together the first time took me a week because of the lack of clear directions. I documented it myself and then 2 months later did a complete install on another server in an hour using my own documentation.  

Migrating from Oracle Names would undoubtedly involve some different steps
(probably at my TNSNAMES import). There will be an Oracle Names proxy in
9i.  

After saying all this I believe it will all be worth it once it comes time to cofigure hundreds of Oracle clients. Also, since OID is an LDAP directory it will have many other uses as well. Its too bad that Oracle couldn't have put together clear documentation on installing and using it but that's nothing new.  

Greg Nelson
gnelson_at_banknorth.com <mailto:gnelson_at_banknorth.com>

-----Original Message-----
Sent: Wednesday, February 28, 2001 12:01 PM To: Multiple recipients of list ORACLE-L

I'm considering the switch from Oracle Names to Oracle Internet Directory. One feature I liked about names was the dynamic discovery. Does dynamic discovery also work with OID? For example if one of my databases fails over to another machine in it's cluster, the names server is automatically updated by the listener as soon as the database starts up on the new machine. Will that also happen with OID? If not, can it easily be scripted
(korn shell).

Also, is there a consicise, easy to follow reference, that tells you how to add a database to OID so you can use OIS to resolve a name to it? I've gone through the entire OID manual and found nothing on the subject.

Do You Yahoo!?
Yahoo! Mail Personal <http://personal.mail.yahoo.com/?.refer=mailiyfoot> Address - Get email at your own domain with Yahoo! Mail.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nelson, Greg
  INET: GNelson_at_banknorth.com

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: ListGuru_at_fatcity.com (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).