Database link 8.1.6 <-> 7.3.4

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Fri, 24 Aug 2001 16:52:31 +0200
Message-ID: <9m5pma$2c3f$1@news5.isdnet.net>

Hi !

I have a problem with database links from a 8.1.6 database to a 7.3.4 database.
(the link from 7.3.4 to 8.1.6 works fine !).

The 8.1.6 database runs on a distant server. The 7.3.4 database runs on my computer (SID=ORCL). I created on my computer a service name called GEMMS connecting to SID=ORCL with TCP.
(i also tried bequeath).

I connect to 8.1.6 and create a public database link to an named user (GEMMS with DBA privs) of the 7.3.4. It works fine. When i try selecting i have the following message :

select table_name from tabs_at_DBTEST

                            *

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

Can it be an interference between oracle 7 server an oracle 8 client ? Something about directories for tnsnames ? Is there a special configuration of oracle 7 for accepting database links ?

Thanks for help.

Yann Received on Fri Aug 24 2001 - 09:52:31 CDT