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

[lrkwz]

I can connect using sqlplus but plsql developer refuses connection.

Please help me.

--- Info ---

PL/SQL Developer
Version 7.0.2.1076 (MBCS)
01.29947 - 10 user license
Windows XP version 6,0 (build 2600) Service Pack 2

Physical memory : 2.087.024 kB (1.057.492 available)
Paging file : 1.930.232 kB (1.143.496 available)
Virtual memory : 2.097.024 kB (1.943.564 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\lrkwz\default.ini

Plug-Ins

Aliases
DB9I.NOVELLO.LABS.INFERENTIA.IT

Homes
OraClient10g_home2 (C:\oracle\product\10.2.0\client_2)

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

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

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

--- Registry ---

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

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1

SOFTWARE\ORACLE\KEY_OraClient10g_home2
ORACLE_HOME = C:\oracle\product\10.2.0\client_2
ORACLE_HOME_NAME = OraClient10g_home2
ORACLE_GROUP_NAME = Oracle - OraClient10g_home2
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH = C:\oracle\product\10.2.0\client_2\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home2

--- Path ---

C:\oracle\product\10.2.0\client_2\bin
C:\oracle\product\10.2.0\client_1
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem

--- TNS names ---

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

DB9I.NOVELLO.LABS.INFERENTIA.IT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = novello.labs.inferentia.it)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db9i.novello.labs.inferentia.it)
)
)

 

[Marco Kalter]

Did you try to connect with C:\oracle\product\10.2.0\client_2\bin\sqlplus.exe?