ORA-12154:TNS:could not resolve the connect identifier specified [message #377937] |
Fri, 26 December 2008 09:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Anvesh REddy
Messages: 7 Registered: December 2008 Location: Charlotte,NC
|
Junior Member |
|
|
Dear members
I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).
When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.
D:\Documents and Settings\BAR>tnsping appdev
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:22:57
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\DevSuiteHome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters
D:\Documents and Settings\BAR>tnsping vislinux
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\DevSuiteHome_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
and when I use TOAD to connect the schema's I get the following error
ORA-12154:TNS:could not resolve the connect identifier specified
Here are the contents of my TNSNAMES.ora file
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
APPDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 70.63.134.203)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = APPDEV)
)
)
VISLINUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 75.182.87.181)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VISLINUX)
)
)
|
|
|
|
|
Re: ORA-12154:TNS:could not resolve the connect identifier specified [message #514904 is a reply to message #380263] |
Thu, 07 July 2011 04:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jeevan452
Messages: 2 Registered: June 2010 Location: Chennai
|
Junior Member |
|
|
ORA-12154:TNS:could not resolve the connect identifier specified[/font]
Hi;
The Same Error is appearing to me also because i am link with sql server to oracle tns names and ping everything is working fine but when i am give select stmt
Select * from tblemployee@payroll;
it display this errors
pls send the mail how to solve this
|
|
|
|