OraFAQ Forum: Networking and Gateways » ORA-12154: TNS:could not resolve the connect identifier specified

Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve the connect identifier specified (Oracle 10.1.0.2.0 IBM AIX, MS SQL Server 2005 on MS windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve the connect identifier specified [message #459569]

Mon, 07 June 2010 02:15

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi all,

we have oracle
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Productio
NLSRTL Version 10.1.0.2.0 - Production

and SQL Server 2005 on MS windows Server 2003

i followed the article and i get succeed on each steps

http://www.databasejournal.com/features/oracle/article.php/10893_3442661_2/Making-a-Connection-from-Oracle-to-SQL-Server.htm

when i execute the select statement under user by name NEW I got below error
ORA-02019: connection description for remote database not found

please help me out to solve this problem

Report message to a moderator