Re: OID setup guide....

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Wed, 31 Mar 2004 20:05:35 +0200
Message-ID: <03c501c4174a$c4d18260$c701a8c0@sys3>

I am currently testing this configuration. Here are the main guide lines ( this is on windows) :

Go with 9.2.0.4. Install 9.2.0.1, upgrade to 9.2.0.4 then install the 9.2.0.1 OID tools and run upgrade to 9.2.0.4 again. After you install the 9.2.0.1 OID, Oracle activate the OID configuration assistance. Exit and upgrade.
Build a new database and select new database option. If you select OID database you get 9.2.0.1 database.
Ensure that you can connect to the new database.
Activate OIDCA and select the option to build OID in the database.
Activate the directory manager and build a new entry for your data. You can do this by selecting entry com, right click and select create like. write in the upper window something like DC=MYENTRY. in the lower window just write MYENTRY. You need a new entry as OID will not work if you build your oracle schema under root.
Close directory manager.
Open net configuration assistance and select directory usage configuration. in the next screen select the third option: create additional context. In the following screens you are asked for the tree entry to create the context in (the default is root). write dc=MYENTRY there.
after the work is done you return to the first screen and select directory usage configuration. You then select the server and schema you just created.
Go to naming method configuration and add directory to the right panel. Close the tool. do not put directory before tnsnames on the OID server as it needs to resolve the access to the OID database via tnsnames.
Activate oracle net manager. select directory and press on the tab: command. select export service names (it really does import from tnsnames.ora). do not forget to put dc= before the administrator name and to select your entry on the screen that ask where put the data.
open a dos window and do tnsping to a database. If it writes that it use tnsnames to resolve the name remove this entry from tnsnames and try again. you should see it resolve the address via the directory.

One more thing to think about: Survival. You need to have two OID servers with the same data (you can use OID replication, I have not got to that yet) and to configure the clients to fall back to the second OID if one is down. This is a central resource and your all oracle application will stop if this server goes down.

Yechiel Adar
Mehish
----- Original Message -----
From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> To: <oracle-l_at_freelists.org>
Sent: Wednesday, March 31, 2004 6:29 PM
Subject: OID setup guide....

> Hi all,
>
> I'm looking at ways of getting us away from using tnsnames.ora files. We
have way too many servers and clients, and maintenance is going to kill us. So, I think the correct solution is OID. Has anyone (successfully) set up OID? Is there a step-by-step guide? Should I stick w/ 9i or go straight to 10g? I tried running 'oidca' on my test 10g instance, but it kept complaining about a 1/2 dozen command line parameters that I didn't know anything about.
>
> So, I'm not an LDAP expert, and I don't want to be. I just want to
centrally administer my database service names. Can anyone offer a clue? I did some MetaLink searching without any luck.
>
> I'm just looking for a basic "do these things in this order, then enter
your service names here and do this to make all your clients see the OID service".
>
> Thanks in advance,
>
> -Mark
>
> Mark J. Bobak
> Oracle DBA
> ProQuest Company
> Ann Arbor, MI
> "Post Hoc Ergo Propter Hoc"
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 31 2004 - 11:54:07 CST