Re: Oracle SQL Developer && LDAP Connection
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 3 Oct 2008 09:33:01 +0200
Message-ID: <48e5cab7$0$188$e4fe514c_at_news.xs4all.nl>
>> "Dmitry V. Krivenok" <krivenok.dmi..._at_gmail.com> schreef in
>> berichtnews:f43be21b-61d7-40e5-a4f7-8118efb32063_at_k7g2000hsd.googlegroups.com...
>>
>>
>>
>> > On Oct 2, 1:25 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
>> > wrote:
>> >> Dmitry V. Krivenok wrote:
>> >> > Hello!
>>
>> >> > I've configured openldap to store information from tnsnames.ora.
>> >> > Seehttp://oracle-cookies.blogspot.com/2007/01/get-tnsnamesora-from-openl...
>> >> > for details.
>> >> > Then I configured Naming Methods via netca as follows:
>>
>> >> > olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/
>> >> > network/admin/sqlnet.ora
>>
>> >> > 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/
>> >> > oracle/product/10.2.0/network/admin/sqlnet.ora
>> >> > 2. Generated by Oracle configuration tools.
>>
>> >> > NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES)
>>
>> >> > olimpico_work ~ #
>>
>> >> > This is my ldap.ora file:
>>
>> >> > olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/
>> >> > network/admin/ldap.ora
>> >> > DIRECTORY_SERVERS = (develop2:389:636)
>> >> > DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz"
>> >> > DIRECTORY_SERVER_TYPE = OID
>> >> > olimpico_work ~ #
>>
>> >> > As shown below tnsping works fine:
>>
>> >> > olimpico_work ~ # tnsping sumtel_fake
>>
>> >> > TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30-
>> >> > SEP-2008 11:58:48
>>
>> >> > Copyright (c) 1997, 2005, Oracle. All rights reserved.
>>
>> >> > Used parameter files:
>> >> > /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora
>>
>> >> > Used LDAP adapter to resolve the alias
>> >> > Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
>> >> > (HOST=sumtel.clients.net)(PORT=1521))
>> >> > (CONNECT_DATA=(SERVICE_NAME=ORANGE)))
>> >> > OK (690 msec)
>> >> > olimpico_work ~ #
>>
>> >> > The problem lies in that I can't create LDAP connection in Oracle
>> >> > SQL
>> >> > Developer.
>> >> > Doc says that sql developer should load entries from ldap.ora
>> >> > (http://
>> >> >www.oracle.com/technology/oramag/oracle/08-may/o38sql.html).
>> >> > However, I found that it even doesn't read ldap.ora file (I'm sure
>> >> > since I traced sqldeveloper via "strace" utility).
>>
>> >> > How to get it work?
>> >> > Any ideas?
>>
>> >> > Thank you beforehand!
>>
>> >> > P.S.
>> >> > I'm using the latest Gentoo Linux with kernel 2.6.22.
>> >> > The version of Oracle installed is 10.2.0.1.0.
>> >> > The version of Oracle SQL developer is 1.5.1.54.40.
>>
>> >> Try introducting TNS_ADMIN:
>>
>> >> export
>> >> TNS_ADMIN=/usr/local/oracle/app/oracle/product/10.2.0/network/admin
>> >> before starting sqldev. (That's one line...)
>> >> Use "set TNS_ADMIN=..." if you run sqldev on Windows
>>
>> >> --
>>
>> >> Regards,
>> >> Frank van Bortel
>>
>> > TNS_ADMIN is set:
>>
>> > krivenok_at_olimpico_work 15:13:23 ~ $ echo $TNS_ADMIN
>> > /usr/local/oracle/app/oracle/product/10.2.0/network/admin
>> > krivenok_at_olimpico_work 15:13:29 ~ $
>>
>> > Any ideas?
>>
>> I just tested this on a windows system. Without any configuration, I only
>> put your ldap.ora in my admin directory. SQLDeveloper does read the file,
>> and shows the ldap server connection.
>>
>> This may be a stupid question, but did you put the ldap.ora file on the
>> same
>> machine as you put SQLDeveloper?
>>
>> Shakespeare
>
Date: Fri, 3 Oct 2008 09:33:01 +0200
Message-ID: <48e5cab7$0$188$e4fe514c_at_news.xs4all.nl>
[Quoted] "Dmitry V. Krivenok" <krivenok.dmitry_at_gmail.com> schreef in bericht news:6b58eca2-886c-40ba-aa05-1efa8e380cae_at_d31g2000hsg.googlegroups.com...
> On Oct 2, 4:58 pm, "Shakespeare" <shakespe..._at_mi5.uk.com> wrote:
>> "Dmitry V. Krivenok" <krivenok.dmi..._at_gmail.com> schreef in
>> berichtnews:f43be21b-61d7-40e5-a4f7-8118efb32063_at_k7g2000hsd.googlegroups.com...
>>
>>
>>
>> > On Oct 2, 1:25 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
>> > wrote:
>> >> Dmitry V. Krivenok wrote:
>> >> > Hello!
>>
>> >> > I've configured openldap to store information from tnsnames.ora.
>> >> > Seehttp://oracle-cookies.blogspot.com/2007/01/get-tnsnamesora-from-openl...
>> >> > for details.
>> >> > Then I configured Naming Methods via netca as follows:
>>
>> >> > olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/
>> >> > network/admin/sqlnet.ora
>>
>> >> > 1. sqlnet.ora Network Configuration File: /usr/local/oracle/app/
>> >> > oracle/product/10.2.0/network/admin/sqlnet.ora
>> >> > 2. Generated by Oracle configuration tools.
>>
>> >> > NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES)
>>
>> >> > olimpico_work ~ #
>>
>> >> > This is my ldap.ora file:
>>
>> >> > olimpico_work ~ # cat /usr/local/oracle/app/oracle/product/10.2.0/
>> >> > network/admin/ldap.ora
>> >> > DIRECTORY_SERVERS = (develop2:389:636)
>> >> > DEFAULT_ADMIN_CONTEXT = "dc=itfits,dc=biz"
>> >> > DIRECTORY_SERVER_TYPE = OID
>> >> > olimpico_work ~ #
>>
>> >> > As shown below tnsping works fine:
>>
>> >> > olimpico_work ~ # tnsping sumtel_fake
>>
>> >> > TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30-
>> >> > SEP-2008 11:58:48
>>
>> >> > Copyright (c) 1997, 2005, Oracle. All rights reserved.
>>
>> >> > Used parameter files:
>> >> > /usr/local/oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora
>>
>> >> > Used LDAP adapter to resolve the alias
>> >> > Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
>> >> > (HOST=sumtel.clients.net)(PORT=1521))
>> >> > (CONNECT_DATA=(SERVICE_NAME=ORANGE)))
>> >> > OK (690 msec)
>> >> > olimpico_work ~ #
>>
>> >> > The problem lies in that I can't create LDAP connection in Oracle
>> >> > SQL
>> >> > Developer.
>> >> > Doc says that sql developer should load entries from ldap.ora
>> >> > (http://
>> >> >www.oracle.com/technology/oramag/oracle/08-may/o38sql.html).
>> >> > However, I found that it even doesn't read ldap.ora file (I'm sure
>> >> > since I traced sqldeveloper via "strace" utility).
>>
>> >> > How to get it work?
>> >> > Any ideas?
>>
>> >> > Thank you beforehand!
>>
>> >> > P.S.
>> >> > I'm using the latest Gentoo Linux with kernel 2.6.22.
>> >> > The version of Oracle installed is 10.2.0.1.0.
>> >> > The version of Oracle SQL developer is 1.5.1.54.40.
>>
>> >> Try introducting TNS_ADMIN:
>>
>> >> export
>> >> TNS_ADMIN=/usr/local/oracle/app/oracle/product/10.2.0/network/admin
>> >> before starting sqldev. (That's one line...)
>> >> Use "set TNS_ADMIN=..." if you run sqldev on Windows
>>
>> >> --
>>
>> >> Regards,
>> >> Frank van Bortel
>>
>> > TNS_ADMIN is set:
>>
>> > krivenok_at_olimpico_work 15:13:23 ~ $ echo $TNS_ADMIN
>> > /usr/local/oracle/app/oracle/product/10.2.0/network/admin
>> > krivenok_at_olimpico_work 15:13:29 ~ $
>>
>> > Any ideas?
>>
>> I just tested this on a windows system. Without any configuration, I only
>> put your ldap.ora in my admin directory. SQLDeveloper does read the file,
>> and shows the ldap server connection.
>>
>> This may be a stupid question, but did you put the ldap.ora file on the
>> same
>> machine as you put SQLDeveloper?
> > Yes I did. > SQL Developer and Oracle Client are installed on my client host, > while > openldap is installed on my server host. > > I will try a windows version of SQL Developer. > >
>>
>> Shakespeare
>
[Quoted] Ok, then you could try to change the TNSNAMES.ORA in the same directroy as your ldap.ora file, and add a (dummy) connection to it. Check if the tns-connections in SQLDeveloper reflect this change. If they do, the error is not in the location of the files. If they don't, SQL Developer is reading your *.ora files from a different location than you expect it to do. If you do see the changes, check if your ldap.ora filename is in lower case.
Shakespeare Received on Fri Oct 03 2008 - 09:33:01 CEST