AW: Oracle and OpenLDAP server

Thanks. So it looks like I either have to

... create an OID, export everything and change the stuff to be standard LDAP,
... or, maybe: Sniff the network traffic while having Oracle create the Schema (LDAP, not DB)
on a win2k Active Directory (if that is standard LDAP stuff, let's see ;).

Sounds fabulous. Why the h*&%ll doesn't Oracle just comply to the standard, since they're
always all hyper about open standards and complain about Microsoft ?!

Stefan

-----Ursprüngliche Nachricht-----
Von: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Gesendet: Montag, 28. Juli 2003 16:59
An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server

Yes, but it isn't pretty. Actually, we chose SunOne, but the concept is the same. I can't take any credit for it though as the local LDAP expert employee-turned-consultant figured out how to create the Oracle schema (LDAP schema, not DB schema). I don't know the exact details, but I remember that most of the problem was that the OiD tools don't create LDIFs to RFC standards. This means that while you can export the entire Oracle schema from OiD using ldifwrite, you have to massage the resulting LDIF in order to make it standards-compliant. Once you have that LDIF, you can use it to recreate the schema in OpenLDAP.

We only used (TRIED to use) OiD for Oracle network names resolution (i.e. instead of ONAMES) and not user authentication. And at least on 9.0.1 under Linux, we couldn't get the damn thing stable. So we dumped OiD in favor of SunOne for non-Oracle user authentication, and are still using ONAMES for name resolution.

Rich

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

> -----Original Message-----
> From: Stefan Jahnke [mailto:Stefan.Jahnke_at_bov.de]
> Sent: Monday, July 28, 2003 4:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle and OpenLDAP server
>
>
> Hi
>
> Is there a way to get Oracle to work with OpenLDAP instead of
> OID, NDS or AD
> ?
> If so, does anybody know of a good How-To ?
>
> TIA,
> Stefan

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


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