I recently switched over to Windows 7 Enterprise 32 bit. I reinstalled PL/SQL Developer version 9.0.6.1665. I could have swarn that I got everything working last week, but when I tried to login today using TNS names, I get the following error: ORA-12154: TNS: could not resolve the connect identifier specified.

Support Info Below.

--- Info ---

PL/SQL Developer
Version 9.0.6.1665
01.80170 - 5 user license
Windows 7 6.1 Build 7601 (Service Pack 1)

Physical memory : 2,061,636 kB (863,448 available)
Paging file : 4,123,272 kB (2,163,468 available)
Virtual memory : 2,097,024 kB (1,960,616 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\239507\AppData\Roaming\PLSQL Developer\Preferences\239507\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
devl
func1
Fyec
IFACTI
IFACTI1
...

Homes
OraClient11g_home1 (C:\oracle\product\11.2.0\client_1)

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

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

Using
Home: OraClient11g_home1
DLL: C:\oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory

SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\oracle\product\11.2.0\client_1\oledb\mesg
OO4O = C:\oracle\product\11.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1

SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0

SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\11.2.0\client_1\oo4o

SOFTWARE\ORACLE\ODP.NET

SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0

--- Path ---

C:\oracle\product\11.2.0\client_1\bin
C:\Program Files\CA\DCS\CAWIN\
C:\Program Files\Business Objects\Common\3.5\bin\NOTES\
C:\Program Files\Business Objects\Common\3.5\bin\NOTES\DATA\
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\Microsoft Application Virtualization Client
C:\Program Files\IBM\Personal Communications\
C:\Program Files\IBM\Trace Facility\
c:\Program Files\IBM\Client Access\Emulator
c:\Program Files\IBM\Client Access\Shared
c:\Program Files\IBM\Client Access\
C:\Windows\ESISOFT
C:\Program Files\Internet Explorer
C:\SQLLIB\BIN
C:\SQLLIB\FUNCTION
C:\Program Files\CheckPoint\File Encryption\Program\

--- TNS names ---

#8:03 AM 5/30/2012# TNSNAMES.ORA Network Configuration File: c:\orant91\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
# Last Updated 11/17/2009
# 5/30/12 - replace s0b1205.ssa.gov With s0b1205.ba.ssa.gov
# 5/30/12 - replace s0b1206.ssa.gov With s0b1206.ba.ssa.gov

devl=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dsel-u0211.ssa.gov)(PORT=1531))
(CONNECT_DATA=
(SID=devl)
)
)


IFACTI=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1200-vip.ssa.gov)(PORT=55000))
)
(CONNECT_DATA=
(SERVICE_NAME=IFACTI)
)
)


IFACTI1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1200-vip.ssa.gov)(PORT=55000))
(CONNECT_DATA=
(SERVICE_NAME=IFACTI)
(INSTANCE_NAME=IFACTI1)
)
)

IFACTI2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1201-vip.ssa.gov)(PORT=55000))
(CONNECT_DATA=
(SERVICE_NAME=IFACTI)
(INSTANCE_NAME=IFACTI2)
)
)


PRFACT01=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1202-vip.ssa.gov)(PORT=55000))
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1203-vip.ssa.gov)(PORT=55000))
)
(CONNECT_DATA=
(SERVICE_NAME=prfact01)
)
)


VFACTI=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1200-vip.ssa.gov)(PORT=10910))
)
(CONNECT_DATA=
(SERVICE_NAME=VFACTI)
)
)



sandold=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206-vip.ssa.gov)(PORT=1550))
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205-vip.ssa.gov)(PORT=1550))
)
(CONNECT_DATA=
(SERVICE_NAME=sand)
)
)

sand2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205.ba.ssa.gov)(PORT=1550))
(CONNECT_DATA=
(SERVICE_NAME=sand)
(INSTANCE_NAME=sand2)
)
)




vtest=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206.ba.ssa.gov)(PORT=1566))
)
(CONNECT_DATA=
(SID=vtest2)
)
)



VTESTold=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205-vip.ssa.gov)(PORT=1566))
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206-vip.ssa.gov)(PORT=1566))
)
(CONNECT_DATA=
(SERVICE_NAME=vtest)

)
)



UTEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dsel-u0211.ssa.gov)(PORT=1536))
(CONNECT_DATA=
(SID=utest)
)
)



tech2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206.ba.ssa.gov)(PORT=1572))
(CONNECT_DATA=
(SERVICE_NAME=tech2)
(INSTANCE_NAME=tech2)
)
)



Fyec=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=dsel-u0211.ssa.gov)(PORT=1581))
(CONNECT_DATA=
(SID=Fyec)
)
)

func1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206-vip.ssa.gov)(PORT=1555))
(CONNECT_DATA=
(SERVICE_NAME=func)
(INSTANCE_NAME=func1)
)
)



tppsdev = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205.ba.ssa.gov)(PORT=1591))
(CONNECT_DATA=(SID=tppsdev))
)


tte1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206.ba.ssa.gov)(PORT=1591))
(CONNECT_DATA=
(SID=te1)
)
)

Also, I am able to connect to the database using the same TNS names file and Oracle SQL Developer tool, so I think the TNS Names and sqlnet files are good.

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

I just tried, but sqlplus.exe is not there; I guess the network admin didn't include that as part of the 11g home install. Verified with my coworker who is still on Vista / oracle 11g that he also does not have sqlplus.exe installed, but PL/SQL Develop is working correctly on his machine.

Thanks for your help

Hi there!

I have the same problem but with
PL/SQL Developer
Version 9.0.6.1665
293.81420 - 6 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Oracle Client version 10.1.0.2

PL/SQL - ORA-12154: TNS:could not resolve the connect identifier specified
tnsping.exe prodcu2 - OK
sqlplus.exe apps/<somepass>@prodcu2 - OK
sqlplusw.exe - OK

Can you start PL/SQL Developer without connecting, go to Help > Support Info and send me the text from the "Info" tab page?

Yes, sure!

PL/SQL Developer
Version 9.0.6.1665
293.81420 - 6 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 1752632 kB (559004 available)
Paging file : 2801208 kB (1256284 available)
Virtual memory : 2097024 kB (1926860 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

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

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
CUTEST
HRTEST2
PRODCU2
PRODHR2

Homes
OraClient10g_home1 (C:\Oracle\product\10.1.0\Client_1)

DLLs
C:\Oracle\product\10.1.0\Client_1\bin\oci.dll

TNS File
C:\Oracle\product\10.1.0\Client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
OCI: Version 10.1

You will get this error when you are using an Oracle10g client (or earlier) from a directory with parentheses like "C:\Program Files (x86)". You will need to upgrade to an 11g client (recommended, especially on Windows 7) or reinstall PL/SQL Developer in a directory without parentheses. See Oracle Note 334528.1 for more information.

Thanks Marco!
It works (C:\Program Files)!

[quote=Ian S]I just tried, but sqlplus.exe is not there; I guess the network admin didn't include that as part of the 11g home install. Verified with my coworker who is still on Vista / oracle 11g that he also does not have sqlplus.exe installed, but PL/SQL Develop is working correctly on his machine.

Thanks for your help [/quote]

Good Morning,
Just looking for an update. My issue doesn't seem to be related to 10g or folder names.

I was able to use Oracle SQL Developer tool with TNS lookup to successfully connect to the database.

Thanks,
Ian

Oh thanks Marco Kalter .... its also work for me.

Just remove my old installation from (c:\program files (x86)) and install at following path c:\program files. Thanks to all.