RE: OpenLDAP instead of OID

Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, December 09, 2003 8:59 AM To: Multiple recipients of list ORACLE-L

Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote:
> Dear All,
>
> I have emailed to Jeff and his link is back up.
>
> Kind Regards,
>
>
> Hatzistavrou Yannis
>
>
>
> -----Original Message-----
> Sent: Tuesday, December 09, 2003 7:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Stefan Jahnke and Denis Williams have recently posted recipe for
> replacing OiD with OpenLDAP.
> The road runner page is no longer accessible. Does anybody have a copy?
> If so, please publish
> the location, because I'm trying it right now. Please, if anybody has
> that page, post it again or forward it
> privately. Thanks in advance. The message I'm talking about is below.
>
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> -----Original Message-----
> DENNIS WILLIAMS
> Sent: Monday, August 18, 2003 11:30 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Congratulations Stefan!
> Thanks for posting this.
> Do you (or anyone else) have any ideas for doing this with Micro$oft
> Active
> Directory?
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Monday, August 18, 2003 8:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi list
>
> Some people where interested in feedback regarding the usage of OpenLDAP
> instead of OID or Names to resolve TNS strings. Seems to work ;). Here
> is
> what to do:
>
> Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use
> CygWin to test it locally on my laptop.
>
> Bill of materials:
>
> CygWin http://www.cygwin.com, I used the latest version, 1.5.2-1test
>
> Oracle Client, version >= 8.1.6.x
>
> OID LDIFS, can be taken from $ORACLE_HOME/ldap/admin, if the OID option
> is
> installed, or from
> Oracle Disks:
> Disk3\stage\Components\oracle.oid.server\9.2.0.1.0\1\DataFiles\admin.1.1
> .jar
>
> HowTo: http://home.nc.rr.com/jtlayton/oid2openldap.html
>
> Simply follow the howto to get openldap running and include the OID
> schemas.
>
> Then, create an ldap.ora under $ORACLE_HOME/network/admin, which looks
> like
> this:
>
> DIRECTORY_SERVERS=localhost:389
> DIRECTORY_SERVER_TYPE=oid DEFAULT_ADMIN_CONTEXT="cn=Manager,dc=world"
>
> .. and change sqlnet.ora to contain:
>
> NAMES.DIRECTORY_PATH= (LDAP)
>
> Finished, enjoy.
> Stefan
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Tel.: +49 201/45 13-289
> mailto:stefan.jahnke_at_nospam.bov.de
> http://www.bov.de
> Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
>
> Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
> 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
> mailto:andrea.palluck_at_bov.de.
>
> Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht
> unter
> fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
> wir
> um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
> rechtliche
> Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the Internet can easily be
> copied or manipulated by third parties. For this reason we would ask for
> your understanding that, for your own protection and ours, we must
> decline
> all legal responsibility for the validity of the statements and comments
> given above.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stefan Jahnke
> INET: Stefan.Jahnke_at_bov.de
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: 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).
>
>
>
> Note:
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission.
> If you receive this message in error, please immediately delete it and
> all copies of it from your system, destroy any hard copies of it and
> notify the sender. You must not, directly or indirectly, use, disclose,
> distribute, print, or copy any part of this message if you are not the
> intended recipient. Wang Trading LLC and any of its subsidiaries each
> reserve the right to monitor all e-mail communications through its
> networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized
> to state them to be the views of any such entity.
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hatzistavrou John
> INET: John.Hatzistavrou.sema_at_mail.tellas.gr
>
> 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: 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).
>

Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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).