Re: Database link 8.1.6 <-> 7.3.4

On the 7.3.4 node a listener must be running, listening for the ORCL database
Configure listener.ora file and start the listener with lsnrctl, command start.

But first configure SQL*Net on the 8.1.6 node because error TNS-12154 means that the service name used in the database link can't be resolved in the SQL*Net configuration on that node. Remember that the database behaves like a client in SQL*Net terms when you use a database link.

Anton Buijs,

Yann CAUCHARD <yann.cauchard_at_spcconsultants.com> schreef in berichtnieuws 9m5pma$2c3f$1_at_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 - 13:57:47 CDT