Re: Oracle SQL Developer && LDAP Connection
From: Shakespeare <shakespeare_at_mi5.uk.com>
Date: Thu, 2 Oct 2008 14:58:25 +0200
Message-ID: <48e4c571$0$183$e4fe514c_at_news.xs4all.nl>
>> 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
Date: Thu, 2 Oct 2008 14:58:25 +0200
Message-ID: <48e4c571$0$183$e4fe514c_at_news.xs4all.nl>
"Dmitry V. Krivenok" <krivenok.dmitry_at_gmail.com> schreef in bericht news:f43be21b-61d7-40e5-a4f7-8118efb32063_at_k7g2000hsd.googlegroups.com...
[Quoted] > 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 Received on Thu Oct 02 2008 - 14:58:25 CEST