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

Search Discussions

  • Hatzistavrou John at Dec 9, 2003 at 2:39 pm
    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 at Dec 9, 2003 at 2:59 pm
    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).
  • Jesse, Rich at Dec 9, 2003 at 3:04 pm
    We had some issues here with OpenLDAP. So we went with SunOne instead,
    which is still free for low usage (<100K LDAP entries). AFAIK, perfect
    uptime and replication in the past year or so...

    Just another option to consider...

    Rich

    Rich Jesse System/Database Administrator
    rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA

    -----Original Message-----
    Sent: Monday, December 08, 2003 11:19 PM
    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
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Jesse, Rich
    INET: Rich.Jesse_at_qtiworld.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).
  • DENNIS WILLIAMS at Dec 9, 2003 at 3:14 pm
    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).
  • Mladen Gogala at Dec 9, 2003 at 3:49 pm
    Then I have to apologize to each and every Dennis Williams for slanderous
    allegations. It wasn't my intention to hurt any Dennis Williams.
    On 12/09/2003 10:14:25 AM, DENNIS WILLIAMS wrote:
    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).
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 9, '03 at 5:19a
activeDec 9, '03 at 3:49p
posts6
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase