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
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----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: [EMAIL PROTECTED]
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: [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).
