Grokbase › Groups › Oracle › oracle-l › October 2005
FAQ
I've done a Metalink and a Google search and I am just not getting the
traction on this question. I want to investigate using LDAP to replace
pushing all those tnsnames.ora files around. I am on 9i and we have
Unix and MS Windows clients. (db''s on Unix) I've read the docs
(Oracle 9i Net Services Administraror's Guide etc.) and searched
Metalink ( 217270.1 ) and otn
(http://www.oracle.com/technology/products/oid/htdocs/namesmigration1.ht
ml, http://download-west.oracle.com/oowsf2004/1457_wp.pdf) etc. and it
seems like you can't just use LDAP, but have to create YAOD (yet another
Oracle Database) and use Oracle Internet Directory. That's great if I
want to buy and configure more Oracle stuff, but really I just want to
piggy back on our current LDAP servers. I don't want to fight the
political battle of adding yet another LDAP server to the islands of
data.


Anyone have a link to a white paper or more info? I'm looking for a
simple step by step brain dead example. eg I want to use the ldap
server on my desktop, add info to it and have it work as a small POC.


Thanks,
Jim

Search Discussions

  • Bobak, Mark at Oct 20, 2005 at 1:28 pm ⇧
    Jim,


    I'll be watching this thread closely, as I was about to ask a similar question. Sorry, I don't have an answer for you....


    -Mark

    From: oracle-l-bounce_at_freelists.org on behalf of Kennedy, Jim
    Sent: Thu 10/20/2005 8:20 PM
    To: oracle-l_at_freelists.org
    Subject: using LDAP for tnsnames.ora repalcement

    I've done a Metalink and a Google search and I am just not getting the traction on this question. I want to investigate using LDAP to replace pushing all those tnsnames.ora files around. I am on 9i and we have Unix and MS Windows clients. (db''s on Unix) I've read the docs (Oracle 9i Net Services Administraror's Guide etc.) and searched Metalink ( 217270.1 ) and otn (http://www.oracle.com/technology/products/oid/htdocs/namesmigration1.html, http://download-west.oracle.com/oowsf2004/1457_wp.pdf) etc. and it seems like you can't just use LDAP, but have to create YAOD (yet another Oracle Database) and use Oracle Internet Directory. That's great if I want to buy and configure more Oracle stuff, but really I just want to piggy back on our current LDAP servers. I don't want to fight the political battle of adding yet another LDAP server to the islands of data.


    Anyone have a link to a white paper or more info? I'm looking for a simple step by step brain dead example. eg I want to use the ldap server on my desktop, add info to it and have it work as a small POC.


    Thanks,
    Jim
  • Mercadante, Thomas F (LABOR) at Oct 20, 2005 at 1:40 pm ⇧
    Jim,



    I don't know how to do what you want, but we use OID/LDAP as a
    replacement for tnsnames. True, we have an Oracle database to support
    this. But we already have a generic Oracle database to support various
    Oracle tools like Rman, Oracle Designer and OEM. Creating another
    schema in this database to support OID was no big deal for us.



    Just something for you to think about.



    Tom



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Kennedy, Jim
    Sent: Thursday, October 20, 2005 2:21 PM
    To: oracle-l_at_freelists.org
    Subject: using LDAP for tnsnames.ora repalcement



    I've done a Metalink and a Google search and I am just not getting the
    traction on this question. I want to investigate using LDAP to replace
    pushing all those tnsnames.ora files around. I am on 9i and we have
    Unix and MS Windows clients. (db''s on Unix) I've read the docs
    (Oracle 9i Net Services Administraror's Guide etc.) and searched
    Metalink ( 217270.1 ) and otn
    (http://www.oracle.com/technology/products/oid/htdocs/namesmigration1.ht
    ml, http://download-west.oracle.com/oowsf2004/1457_wp.pdf) etc. and it
    seems like you can't just use LDAP, but have to create YAOD (yet another
    Oracle Database) and use Oracle Internet Directory. That's great if I
    want to buy and configure more Oracle stuff, but really I just want to
    piggy back on our current LDAP servers. I don't want to fight the
    political battle of adding yet another LDAP server to the islands of
    data.



    Anyone have a link to a white paper or more info? I'm looking for a
    simple step by step brain dead example. eg I want to use the ldap
    server on my desktop, add info to it and have it work as a small POC.



    Thanks,

    Jim
  • Yechiel Adar at Oct 20, 2005 at 1:43 pm ⇧
    AFAIK, you do not need to buy anything new.
    You install the OID, put the repository into a new, or existing, DB,
    configure the client and away you go.
    I tested it sometimes ago and it worked OK.

    Adar Yechiel
    Rechovot, Israel

    Kennedy, Jim wrote:
    I've done a Metalink and a Google search and I am just not getting the
    traction on this question. I want to investigate using LDAP to
    replace pushing all those tnsnames.ora files around. I am on 9i and
    we have Unix and MS Windows clients. (db''s on Unix) I've read the
    docs (Oracle 9i Net Services Administraror's Guide etc.) and searched
    Metalink ( 217270.1 ) and otn
    (http://www.oracle.com/technology/products/oid/htdocs/namesmigration1.html,
    http://download-west.oracle.com/oowsf2004/1457_wp.pdf) etc. and it
    seems like you can't just use LDAP, but have to create YAOD (yet
    another Oracle Database) and use Oracle Internet Directory. That's
    great if I want to buy and configure more Oracle stuff, but really I
    just want to piggy back on our current LDAP servers. I don't want to
    fight the political battle of adding yet another LDAP server to the
    islands of data.

    Anyone have a link to a white paper or more info? I'm looking for a
    simple step by step brain dead example. eg I want to use the ldap
    server on my desktop, add info to it and have it work as a small POC.

    Thanks,
    Jim
    --
    http://www.freelists.org/webpage/oracle-l
  • Vergara, Michael (TEM) at Oct 21, 2005 at 10:35 am ⇧
    Adar, & Everyone:

    It's all well and good to have the view that the Oracle products work, and you
    can just install them and it will work. However, I have management who says
    (in effect) "Thou shalt have but one directory, and it shall be Active".

    So I'm in the same boat as these other folks who are required or constrained
    by company policy and management to a single infrastructure. If we cannot
    work with that then we don't do it. Then, of course, they tell us to move
    towards Single-Sign-on.

    The upshot of this is that I too am listening for another member of this list
    who has done this, or has tried and failed and here's what tripped them up,
    any sort of war story that could help me out.

    I cannot believe that there are only three of us who have (or have had) this
    problem.

    Anybody?

    Cheers,
    Mike

    Michael P. Vergara Be good and you will be lonesome
    Guidant Corporation Mark Twain

    Oracle Database Administrator
    (951) 914-2000 (Voice)
    (951) 914-2990 (FAX)

    www.guidant.com

    Any views expressed herein are not necessarily those of Guidant Corporation.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org On Behalf Of Yechiel Adar
    Sent: Thursday, October 20, 2005 12:41 PM
    Cc: oracle-l_at_freelists.org
    Subject: Re: using LDAP for tnsnames.ora repalcement

    AFAIK, you do not need to buy anything new.
    You install the OID, put the repository into a new, or existing, DB,
    configure the client and away you go.
    I tested it sometimes ago and it worked OK.

    Adar Yechiel
    Rechovot, Israel

    --
    http://www.freelists.org/webpage/oracle-l
  • Niall Litchfield at Oct 24, 2005 at 12:35 am ⇧

    On 10/21/05, Vergara, Michael (TEM) wrote:
    Adar, & Everyone:

    It's all well and good to have the view that the Oracle products work, and
    you
    can just install them and it will work.
    Although somewhat brave...

    However, I have management who says
    (in effect) "Thou shalt have but one directory, and it shall be Active".
    I think that, assuming you are a windows clients only shop (not the OPs
    position) this is sensible.

    So I'm in the same boat as these other folks who are required or constrained
    by company policy and management to a single infrastructure. If we cannot
    work with that then we don't do it. Then, of course, they tell us to move
    towards Single-Sign-on.

    The upshot of this is that I too am listening for another member of this
    list
    who has done this, or has tried and failed and here's what tripped them
    up,
    any sort of war story that could help me out.
    I went down the getting AD to work as a tnsnames.ora replacement route and
    failed. Windows 2000 AD and 9i OID (probably 9.0.1 in fairness) didn't play
    together, at least for names resolution. In the end I was told by someone
    out of the OID support team that really I needed to use a 10g system to
    setup and configure because the AD support in 9i wasn't going to be there at
    all "Thou shalt have only one infrastructure and it shall be Oracle" or
    something, but then got tagged back in in response to customer demand.
    Upshot was that as a client 9i was just fine but really wait until 10 to set
    it all up.

    The other thing that may be significant of course is that this was also
    win2000 AD and not a 2003 domain.
  • Oracle-l-bounce_at_freelists.org at Oct 23, 2005 at 6:54 pm ⇧
    Michael

    Four.

    Unfortunately I do not have a solution yet. Oracle Support told me that
    Windows oracle can talk to AD, but not UNIX oracle; this does not seem
    plausible to me but I have not had a chance to follow it up.

    My major gripe is the heavyweight footprint of Oracle OID (LDAP->HDAP).
    Compared with Oracle Names which is, more or less, up and running by
    firing up onames and running a script of register commands. I even feel
    guilty about the wasted disk space on the floppy containing my onames
    backups :).

    "They" tell me that databases are optimized for read-write whilst LDAP
    repositories are optimized for read: Is there some
    contradiction here when considering OID?

    Trevor

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Vergara, Michael

    (TEM)

    Sent: Friday, 21 October 2005 11:33 PM
    To: adar76_at_inter.net.il
    Cc: oracle-l_at_freelists.org
    Subject: RE: using LDAP for tnsnames.ora repalcement

    Adar, & Everyone:

    It's all well and good to have the view that the Oracle products work,
    and you
    can just install them and it will work. However, I have management who
    says
    (in effect) "Thou shalt have but one directory, and it shall be Active".

    So I'm in the same boat as these other folks who are required or
    constrained
    by company policy and management to a single infrastructure. If we
    cannot
    work with that then we don't do it. Then, of course, they tell us to
    move
    towards Single-Sign-on.

    The upshot of this is that I too am listening for another member of this
    list
    who has done this, or has tried and failed and here's what tripped them
    up,
    any sort of war story that could help me out.

    I cannot believe that there are only three of us who have (or have had)
    this
    problem.

    Anybody?

    Cheers,
    Mike

    Michael P. Vergara Be good and you will be
    lonesome
    Guidant Corporation Mark

    Twain
    Oracle Database Administrator
    (951) 914-2000 (Voice)
    (951) 914-2990 (FAX)

    www.guidant.com

    Any views expressed herein are not necessarily those of Guidant
    Corporation.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Yechiel Adar
    Sent: Thursday, October 20, 2005 12:41 PM
    Cc: oracle-l_at_freelists.org
    Subject: Re: using LDAP for tnsnames.ora repalcement

    AFAIK, you do not need to buy anything new.
    You install the OID, put the repository into a new, or existing, DB,
    configure the client and away you go.
    I tested it sometimes ago and it worked OK.

    Adar Yechiel
    Rechovot, Israel

    --
    http://www.freelists.org/webpage/oracle-l

    DISCLAIMER:
    Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail.
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 20, '05 at 1:23p
activeOct 24, '05 at 12:35a
posts7
users7
websiteoracle.com

7 users in discussion

Oracle-l-bounce_at_freelists.org: 1 post Yechiel Adar: 1 post Niall Litchfield: 1 post Kennedy, Jim: 1 post Bobak, Mark: 1 post Mercadante, Thomas F (LABOR): 1 post Vergara, Michael (TEM): 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase