I can login with sqlplus but not PL/SQL Developer

[BlackVX]

I looked into the help support info from the software and it's picking up the right tnsnames.ora file. It's working with SQLPLUS but not PL/SQL Developer. I get the error "TNS: Could not resolve the connect identifier specified."

I'm using XP64 but the Oracle client was installed as 32bit.

Here are more details about the Support Info:

PL/SQL Developer
Version 6.0.5.931 (MBCS)
01.0957 - Unlimited user license
Windows XP version 6.0 (build 2600)

Physical memory : 2,095,092 kB (1,400,016 available)
Paging file : 4,057,808 kB (3,471,700 available)
Virtual memory : 2,097,024 kB (1,975,756 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

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

Plug-Ins

Aliases
devdb
scitech

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2

-----
Help please.
Thanks,
Michael

 

[Marco Kalter]

Did you use C:\oracle\product\10.2.0\client_1\bin\sqlplus.exe and connect to the same database? It should result in the same error.

 

[BlackVX]

Marco,
Yes, I just retried using the exact sqlplus.exe program and it worked.

PL/SQL auto-populate the right databases from the drop down list at the login. I have no other TNSNAMES.ORA files on my PC. I tried different user/password and none of them work.

Would you like me to send you other information about the system info?

Thanks for your help,
Michael

 

[Marco Kalter]

I just noticed that you are using XP64. This probably means that PL/SQL Developer is installed here:

C:\Program Files (x86)\PLSQL Developer

There are some Oracle Net bugs concerning parentheses in application directories. Can you uninstall PL/SQL Developer, and reinstall it in a directory without parentheses?

 

[BlackVX]

Marco,
You're a genius! It worked after I installed it under C:\Program Files\PLSQL Developer.

Thanks a bunch!!!

Michael