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