Re: Database link 8.1.6 <-> 7.3.4

Assuming that you did create DBTEST tns entry on your server (8.1.6) database, and assuming you can reach your computer from the server you *might* be having the following problem

Look in sqlnet.ora file on your server and see if a GLOBAL_NAME entry is defined. If it is defined e.g. "SOMENAME" then you should refer to the 7.3.4
database as "DBTEST.SOMENAME" instead of just "DBTEST"

Anurag

...corrections welcome

"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
Received on Fri Aug 24 2001 - 15:48:24 CDT