Re: Oracle SQL Developer && LDAP Connection

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 07 Oct 2008 20:10:21 +0200
Message-ID: <73679$48eba60e$524b5c40$17169_at_cache1.tilbu1.nb.home.nl>


Shakespeare wrote:
> "Dmitry V. Krivenok" <krivenok.dmitry_at_gmail.com> schreef in bericht

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

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

Should the next (even more stupid) question not be: Do you use the same Unix account and environment settings when testing the Oracle client and SQL Dev?

-- 

Regards,
Frank van Bortel
Received on Tue Oct 07 2008 - 20:10:21 CEST

Original text of this message