RE: Linux dblink issue

From: Jäck Stephan <Jaeck.Stephan_at_REAL.DE>
Date: Fri, 11 Aug 2000 14:00:44 +0200
Message-Id: <10586.114347@fatcity.com>

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_at_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 Received on Fri Aug 11 2000 - 07:00:44 CDT