dbTalk Databases Forums  

Oracle SQL Developer && LDAP Connection

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle SQL Developer && LDAP Connection in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #51  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM






Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #52  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM






Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #53  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM



Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #54  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM



Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #55  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM



Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #56  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM



Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
  #57  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle SQL Developer && LDAP Connection - 10-07-2008 , 01:10 PM



Shakespeare wrote:
Quote:
"Dmitry V. Krivenok" <krivenok.dmitry (AT) gmail (DOT) 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.