Re: Oracle SQL Developer && LDAP Connection

[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? Received on Thu Oct 02 2008 - 13:15:58 CEST