Re: Oracle 8 DB link to Oracle 7.3.4

You probably performed the following command, or something like the following:

create public database link oracle7_db_link connect to user
identified by password
using 'oracle7_db';

Where the part that has "oracle7_db", this alias needs to be defined in your "tnsnames.ora" file.

I hope this helps.

Russ Frier wrote:

> I have a puzzling situation. In an Oracle 8 database, I create a db link
> to an oracle 7 database. I know that this oracle 7 database is up and
> reachable from the same machine that the oracle 8 database is running on
> (via sqlplus,svrmgrl). However, when I create the link and attempt to
> use it, I get the message:
> 'ORA-12154: TNS:could not resolve service name'. Any ideas?
> Russ

--
Peter Chan, Nortel Networks email: chanp_at_nortelnetworks.ca Received on Fri Jan 15 1999 - 09:31:33 CST