ORA-12154 TNS:could not resolve the connect identifier specified

P

PaulIsen

Member
PLSQL Developer Sign-on data

Username: ifsapp
Password: ifsapp
Database: PAUL_RACE.WORLD
Connect As: Normal

Fails with the ORA-12154

------------------

Connecting with SQLPlus

sqlplus ifsapp/ifsapp@paul_race.world

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 23 11:30:53 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

----------------

No failure.

Could not figure out how to add attachment so here is additional data:

-------- PLSQL Developer - Tools / Preferences -----------

Session Mode - Single Session
Oracle Home - empty
OCI Library - f:\oracle\product\10.2.0\Client_1\oci.dll

---------- PLSQL Developer - Support Info Tab ------------

--------------------- Info Tab ---------------------------

PL/SQL Developer
Version 7.1.5.1397
01.48513 - 1 user license
Windows 2003 (64-bit) 5.2 Build 3790 (Service Pack 2)

Physical memory : 4,194,304 kB (2,852,304 available)
Paging file : 4,194,304 kB (3,154,404 available)
Virtual memory : 2,097,024 kB (1,899,992 available)

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

Preferences
Session mode: Single
OCI Library: f:\oracle\product\10.2.0\client_1\oci.dll
Use OCI7: False

Preference Files
F:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
F:\Program Files (x86)\PLSQL Developer\Preferences\Administrator\default.ini

Plug-Ins

Aliases
EXTPROC_CONNECTION_DATA
ORCL.world
PAUL_RACE.world
RACE

Homes
OraDb10g_home1 (f:\oracle\product\10.2.0\db_1)

DLLs
f:\oracle\product\10.2.0\db_1\bin\oci.dll

TNS File
f:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

Using
Home: OraDb10g_home1
DLL: f:\oracle\product\10.2.0\client_1\oci.dll
OCI: version 9.2

--------------------- Registry Tab ---------------------------

SOFTWARE\ORACLE
inst_loc = F:\Program Files (x86)\Oracle\Inventory
ORACLE_HOME = f:\oracle\product\10.2.0\db_1
ORACLE_HOME_NAME =

SOFTWARE\ORACLE\IFS Applications
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = f:\oracle\product\10.2.0\Client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1

SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_HOME = f:\oracle\product\10.2.0\db_1
ORACLE_HOME_NAME = OraDb10g_home1
ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
NLS_LANG =
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = f:\oracle\product\10.2.0\db_1\oledb\mesg
StmtCacheSize = 0
ORACLE_SID = RACE
SQLPATH = f:\oracle\product\10.2.0\db_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
MSHELP_TOOLS = f:\oracle\product\10.2.0\db_1\MSHELP
ORACLE_BASE = f:\oracle\product\10.2.0
RDBMS_CONTROL = f:\oracle\product\10.2.0\db_1\DATABASE
RDBMS_ARCHIVE = f:\oracle\product\10.2.0\db_1\DATABASE\ARCHIVE

SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
CacheType = Memory
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

--------------------- Path Tab ---------------------------

f:\oracle\product\10.2.0\client_1
f:\oracle\product\10.2.0\db_1\bin
F:\Program Files (x86)\Business Objects\Common\3.5\bin\NOTES\
F:\Program Files (x86)\Business Objects\Common\3.5\bin\NOTES\DATA\
F:\WINDOWS\system32
F:\WINDOWS
F:\WINDOWS\System32\Wbem
F:\Program Files (x86)\jZip
F:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\
F:\Program Files (x86)\Common Files\Roxio Shared\10.0\DLLShared\
F:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\

--------------------- TNS Names Tab ---------------------------

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.10.10.10)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

PAUL_RACE.world=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(Host=10.10.10.10)
(Port=1521)
)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=RACE)
)
)

RACE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(Host=10.10.10.10)
(Port=1521)
)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=RACE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

------------------ Windows Set Parameters --------------------

ALLUSERSPROFILE=F:\Documents and Settings\All Users
APPDATA=F:\Documents and Settings\Administrator\Application Data
CLIENTNAME=Console
CommonProgramFiles=F:\Program Files\Common Files
CommonProgramFiles(x86)=F:\Program Files (x86)\Common Files
COMPUTERNAME=PAUL
ComSpec=F:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=F:
HOMEPATH=\Documents and Settings\Administrator
LOGONSERVER=\\PAUL
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Path=f:\oracle\product\10.2.0\Client_1;f:\oracle\product\10.2.0\db_1\bin;F:\Prog
ram Files (x86)\Business Objects\Common\3.5\bin\NOTES\;F:\Program Files (x86)\Bu
siness Objects\Common\3.5\bin\NOTES\DATA\;F:\WINDOWS\system32;F:\WINDOWS;F:\WIND
OWS\System32\Wbem;F:\Program Files (x86)\jZip;F:\Program Files (x86)\Common File
s\Roxio Shared\DLLShared\;F:\Program Files (x86)\Common Files\Roxio Shared\10.0\
DLLShared\;F:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=f:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x64;f:\oracle\prod
uct\10.2.0\db_1\perl\5.8.3\lib;f:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWi
n32-x64;f:\oracle\product\10.2.0\db_1\perl\site\5.8.3;f:\oracle\product\10.2.0\d
b_1\perl\site\5.8.3\lib;f:\oracle\product\10.2.0\db_1\sysman\admin\scripts;f:\or
acle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x64;f:\oracle\product\10.2.0\db_
1\perl\5.8.3\lib;f:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x64;f:\ora
cle\product\10.2.0\db_1\perl\site\5.8.3;f:\oracle\product\10.2.0\db_1\perl\site\
5.8.3\lib;f:\oracle\product\10.2.0\db_1\sysman\admin\scripts
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=EM64T Family 6 Model 23 Stepping 10, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=170a
ProgramFiles=F:\Program Files
ProgramFiles(x86)=F:\Program Files (x86)
PROMPT=$P$G
RoxioCentral=F:\Program Files (x86)\Common Files\Roxio Shared\10.0\Roxio Central
36\
SESSIONNAME=Console
SystemDrive=F:
SystemRoot=F:\WINDOWS
TEMP=F:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=F:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TNS_ADMIN=f:\oracle\product\10.2.0\db_1\network\admin
USERDOMAIN=PAUL
USERNAME=Administrator
USERPROFILE=F:\Documents and Settings\Administrator
VS90COMNTOOLS=F:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\Tools\
windir=F:\WINDOWS

------------------ Oracle ORA Files --------------------

------------------ Listner.ora --------------------

# listener.ora Network Configuration File: f:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

------------------ Sqlnet.ora --------------------

# SQLNet.ora
#
#names.default_domain = world
#names.preferred_servers = (address_list =
# (address=(protocol=ipc)(key=n23))
# (address=(protocol=tcp)(host=nineva)(port=1383))
# (address=(protocol=tcp)(host=cicada)(port=1575))
# )
#
names.directory_path=(TNSNAMES)
names.log_directory = f:\temp\trace
names.trace_directory = f:\temp\trace
names.trace_level = ADMIN
trace_level_client = ADMIN
trace_directory_client = f:\temp\trace
trace_unique_client = ON
log_directory_client = f:\temp\trace
log_directory_server = f:\temp\trace
trace_directory_server = f:\temp\trace
trace_level_server = ADMIN
#names.log_file = names.log
#trace_file_client = /oracle/network/trace/cli.trc
#trace_file_server = /orace/network/trace/svr_.trc
#log_file_client = /oracle/network/log/sqlnet.log
#use_dedicated_server = ON

------------------ tnsnames.ora --------------------

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.10.10.10)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

PAUL_RACE.world=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(Host=10.10.10.10)
(Port=1521)
)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=RACE)
)
)

RACE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(Host=10.10.10.10)
(Port=1521)
)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=RACE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

-------------- Oracle Trace File --------------------------

(5988) [23-DEC-2009 11:26:17:781] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
(5988) [23-DEC-2009 11:26:17:781] New trace stream is f:\temp\trace\cli_5988.trc
(5988) [23-DEC-2009 11:26:17:781] New trace level is 6
(5988) [23-DEC-2009 11:26:17:781] --- TRACE CONFIGURATION INFORMATION ENDS ---
(5988) [23-DEC-2009 11:26:17:781] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
(5988) [23-DEC-2009 11:26:17:781] Attempted load of system pfile source f:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
(5988) [23-DEC-2009 11:26:17:781] Parameter source loaded successfully
(5988) [23-DEC-2009 11:26:17:781]
(5988) [23-DEC-2009 11:26:17:781] Attempted load of local pfile source F:\Program Files (x86)\PLSQL Developer\sqlnet.ora
(5988) [23-DEC-2009 11:26:17:781] Parameter source was not loaded
(5988) [23-DEC-2009 11:26:17:781]
(5988) [23-DEC-2009 11:26:17:781] -> PARAMETER TABLE LOAD RESULTS FOLLOW PARAMETER TABLE HAS THE FOLLOWING CONTENTS
 
This will happen is you are using Oracle Client 10.2 and an installation directory with parentheses. To solve this, reinstall PL/SQL Developer in a directory without parentheses, or upgrade to an Oracle11 Client.

See also Oracle Note 334528.1: "ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS"
 
Marco,

That was exactly what the problem was. I had seen the statement about the directory having () in the name while browsing the forum, but I thought they meant in the Oracle client install.

Thank you very much for your quick and accurate response.

Paul
 
You must log in or register to reply here.

Similar threads

C
  • Discussion Discussion
Recovery not working
Replies
11
Views
35K
Natalen
N
S
  • Discussion Discussion
pl/sql developer could not resolve the connect identifier specified
Replies
1
Views
3K
Marco Kalter
Marco Kalter
C
  • Discussion Discussion
Importing Tables using PLSQL fails - Ora 003114 Not Connected to Oracle
Replies
2
Views
4K
fairwaywood
F
M
  • Discussion Discussion
Getting ORA-12154 error while accessing database for only few Users
Replies
2
Views
5K
Manjeet
M
S
  • Discussion Discussion
Importing Tables using PLSQL fails - Ora 003114 Not Connected to Oracle
Replies
2
Views
5K
Marco Kalter
Marco Kalter
Back
Top