ldap and pl/sql developer : 7.0.3.1123

[YSR]

Was anyone able to connect from PL/SQL developer v7.0.3 to Oracle 11g using LDAP ?

I do have correct LDAP.ORA and SQLNET.ORA files.
I am able to connect from SQL*PLUS.
I am also able to connect from pl/sql developer using tnsnames.ora

Does version 7.0.3 of PL/SQL Developer look at LDAP.ORA and SQLNET.ORA ?

OS : windows xp
Oracle : 11g

Appreciate your input.

 

[Marco Kalter]

It should work fine. What exactly is the error message when you try to connect with PL/SQL Developer?

 

[YSR]

I am getting :
ora-12154: TNS:could not resolve the connect identified specified

In in SQLNET.ORA, I have this (LDAP as first priority):
-------------------------------------------------------
NAMES.DEFAULT_DOMAIN = mycompany.com
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT)

TNSNAMES.ORA Entry :
--------------------
PAYN_D.mycompany.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.mycompany.com)(PORT = nnnn))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = payn_d.mycompany.com)
)
)

From PL/SQL Developer, if I login using my uid, pwd and database as PAYN_D.mycompany.com, I am able to connect. However, if I just use PAYN_D, I am not able to connect.

My understanding is that it needs to first look at LDAP and connect ( I am able to connect from SQL*PLUS). Even if it fails, it needs to look at sqlnet.ora and get default domain ('mycompany.com') and append it and connect using tnsnames entry (payn_d).

I should note that other colleagues are able to connect using pl/sql developer without any issues. It seems to be only with me :-(

 

[Marco Kalter]

Maybe this is an environment issue. Can you go to Help > Support Info and let me know the information from the "Info" tab page?

 

[YSR]

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
142.38620 - 20 user license
Windows XP version 6.0 (build 2600) Service Pack 3

Physical memory : 2,097,152 kB (1,178,944 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (2,006,000 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: c:\oracle\10_2\bin\oci.dll
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\yells01\default.ini

Plug-Ins
*Shortcuts Plug-In v1.2 by Tiger (C:\Program Files\PLSQL Developer\PlugIns\shortcuts.dll)
(* is Active)

Aliases
11g
AUTO_DEV.world
AUTOBCP.world
AUTOPROD.world
AUTOTRN.world
...

Homes
OraHome10_2 (c:\oracle\10_2)

DLLs
c:\oracle\10_2\bin\oci.dll

TNS File
c:\oracle\10_2\Network\Admin\tnsnames.ora

Using
Home: OraHome10_2
DLL: c:\oracle\10_2\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

Is this the sqlnet.ora file you posted above?

c:\oracle\10_2\Network\Admin\sqlnet.ora