Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database link 8.1.6 <-> 7.3.4

Re: Database link 8.1.6 <-> 7.3.4

From: Guy ZIMMER <gzimmer_at_pt.lu>
Date: Sat, 25 Aug 2001 20:27:59 +0200
Message-ID: <3b87edfb$1_2@news.vo.lu>


Hi..

Try to change the port number...

Ora8 is using TNS Port : (Port = 1521)
Ora7 is using TNS Port : (Port = 1526)

I think that was the error ;-)

"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> schrieb im Newsbeitrag 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 Sat Aug 25 2001 - 13:27:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US