pl/sql developer could not resolve the connect identifier specified

[starboy007]

Hi,

After re-installation of pl/sql developer, I get the 'could not resolve connect identifier specified' error. The TNSNAMES file looks good and I am able to connect using sqlplus. See below the info file details.I read in a lot of forums that it is the issue with '(' in Program files folder name. But its not the case with me. I installed it in C:\Program Files.

Any help is appreciated.

==============================
PL/SQL Developer
Version 7.1.5.1398
01.69819 - 20 user license
Windows Vista (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,816,356 available)

Parameters
C:\Program Files\PLSQLDeveloper\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Users\vanamp\AppData\Roaming\PLSQL Developer\Preferences\VANAMP\Default.ini
C:\Users\vanamp\AppData\Roaming\PLSQL Developer\Preferences\VANAMP\default.ini

Plug-Ins

Aliases
BRDEV1
BRTEST3
CRP1
CRP2
DACTEST
...

Homes
OH1882086053 (C:\Oracle\OSB11117\Oracle_OSB1)
OH304287517 (C:\Oracle\OSB11117\oracle_common)
OraClient11g_home1 (C:\app\pope1j\product\11.2.0\client_1)
OraClient11g_home4 (C:\app\pope3j\product\11.2.0\client_1)

DLLs
C:\app\pope3j\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\app\pope3j\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home4
DLL: C:\app\pope3j\product\11.2.0\client_1\bin\oci.dll
OCI: version 9.2
=====================================

 

[Marco Kalter]

Can you connect to the same database with C:\app\pope3j\product\11.2.0\client_1\bin\sqlplus.exe?

Enter the complete username/password@database on the "Enter user-name:" prompt after starting SQL*Plus.

I notice you have 4 Oracle Homes. You can also try to select a different Oracle Home than the current OraClient11g_home4 from the Oracle Home selection list at Tools > Preferences > Oracle / Connection. You need to restart PL/SQL Developer to make the home switch effective.