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>
>
> 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
>
>
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 BortelReceived on Tue Oct 07 2008 - 20:10:21 CEST