Message-Id: <10586.114347@fatcity.com> From: =?ISO-8859-1?Q?J=E4ck_Stephan?= Date: Fri, 11 Aug 2000 14:00:44 +0200 Subject: RE: Linux dblink issue You need the correct TNS-definition in the tnsnames.ora on the DB-Server where the dblink is created from, not on the client. HTH Stephan -----Original Message----- From: McGlaughlin,Stewart [mailto:mcglaughlin@attws.com] Sent: Thursday, August 10, 2000 5:17 PM To: Multiple recipients of list ORACLE-L Subject: Linux dblink issue Hello everyone, I'm hoping that someone on the list can shed some light on a Linux/dblink issue a fellow DBA is experiencing. But the ORA2019 means that you db-link is not correct created. Send the DDL you used to create the link. Stephan ----- BEGIN FORWARD ----- I have two Oracle 8.1.5 databases on a RedHat Linux 6.2 server. I have created a database link in one database to access the second database. I have used the correct connect strings but when I try to describe a table using the database link I receive ORA-02019. I have tried everything. GLOBAL_NAMES is set to true so I am using the database name as the link name. I have also tried using the connect string from TNSNAMES as my using clause. I still receive this error. I can access my Linux DB (from a NT DB). I can *not* access a NT DB from my Linux DB (via dblink). I receive the same error. ----- END FORWARD ---- TIA ----- Stewart McGlaughlin Oracle DBA On-site at AT&T Wireless Services Oracle Links @ http://www.stewartmc.com/oracle