Home » RDBMS Server » Networking and Gateways » ORA-12154:TNS:could not resolve the connect identifier specified (Oracle,10g,XP)
ORA-12154:TNS:could not resolve the connect identifier specified [message #377937] Fri, 26 December 2008 09:42 Go to next message
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 #380164 is a reply to message #377937] Fri, 09 January 2009 06:28 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You may have a syntax error in your TNSNAMES.ORA file, however, it's difficult to tell, as all indentation was lost when you've pasted it into the forum.

Can you please post it with proper indentation as in your TNSNAMES.ORA file?
Re: ORA-12154:TNS:could not resolve the connect identifier specified [message #380263 is a reply to message #377937] Fri, 09 January 2009 18:08 Go to previous messageGo to next message
Anvesh REddy
Messages: 7
Registered: December 2008
Location: Charlotte,NC
Junior Member
Hi Frank

Thankyou for your reply.The issue has been resolved!!

you were right I had a issue in my TNSNAMES.ora file.

Thanks
Anvesh
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 messageGo to next message
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
Re: ORA-12154:TNS:could not resolve the connect identifier specified [message #514970 is a reply to message #514904] Thu, 07 July 2011 08:33 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Select * from tblemployee@payroll;

tnsalias "payroll" could not be resolved.
post content of tnsnames.ora & sqlnet.ora, if it exists
Previous Topic: Find list of database links
Next Topic: Ask : connection time out
Goto Forum:
  


Current Time: Fri Dec 02 18:29:45 CST 2016

Total time taken to generate the page: 0.39122 seconds