Re: Database link 8.1.6 <-> 7.3.4

"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message news: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
>
>
>

If you consider including the 7.3.4 service definition in the *servers* tnsnames.ora 'a special configuration of Oracle 7' : yes Chances are however it is not going to work, because sqlnet 2 can talk to 8(i) databases, but not necessarily the other way around.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 24 2001 - 10:58:22 CDT