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)
ORA-12154: TNS:could not resolve the connect identifier specified [message #459569] Mon, 07 June 2010 02:15 Go to next message
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
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #459636 is a reply to message #459569] Mon, 07 June 2010 10:15 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-02019: connection description for remote database not found
http://www.orafaq.com/forum/t/141990/0/
Previous Topic: compare table data from two different databases
Next Topic: ORA-12154: TNS:could not resolve the connect identifier..
Goto Forum:
  


Current Time: Thu Mar 28 15:56:21 CDT 2024