PL/SQL Developer 7.1.5.1397 Not working on Windows 7 64 bit

[Krishna Vaddadi]

Recently we upgraded our System (windows Xp 32 Bit) to Windows 7 64 bit. When we upgraded our PL/SQL Developer tool stopped working. When we tried to log in it gave the following error "ORA-12154: TNS: could not resolved Service names".

On few of the forums we found, the Tool is not compatible with 64 bit Oracle client, but you have a work around. Can you guide us in getting the tool working.

Here the Details of the PL/SQL Developer and other information from the Support Info.

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

Physical memory : 3,636,400 kB (1,191,460 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,936,496 available)

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

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

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files (x86)\PLSQL Developer\Preferences\43395132\default.ini

Plug-Ins

Aliases

Homes
OraHome92 (C:\ORACLE\ORA92)

DLLs
C:\ORACLE\ORA92\bin\oci.dll

TNS File
C:\ORACLE\ORA92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\ORACLE\ORA92\bin\oci.dll
OCI: version 9.2

Registry:

SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory
ORACLE_HOME = C:\ORACLE\ORA92
ORACLE_HOME_NAME = OraHome92
API = C:\ORACLE\ORA92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = C:\ORACLE\ORA92
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\ORACLE\ORA92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = C:\ORACLE\ORA92\dbs

 

[T-Gergely]

AFAIR the problem is parentheses in the path of PSD: "C:\Program Files (x86)\PLSQL Developer" AND using older Oracle Client. Try installing the latest 32 bit 11.2 Oracle client instead of 9.2, or install PSD into another directory.