Newsgroups: comp.databases.oracle.server
Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news3.optonline.net!cyclone.rdc-nyc.rr.com!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news
From: Brian Peasland <dba@remove_spam.peasland.com>
Subject: Re: DBLINK between Oracle 7 and Oracle 9
X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov
Content-Type: text/plain; charset=us-ascii
Message-ID: <401E9A79.74C604D2@remove_spam.peasland.com>
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: U.S. Geological Survey, Reston VA
X-Accept-Language: en
References: <5b4dae09.0402020923.3e766175@posting.google.com>
Mime-Version: 1.0
Date: Mon, 2 Feb 2004 18:44:09 GMT
X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U)
Lines: 33
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253484

The Oracle 7 database and the Oracle 9i database uses different network
stacks. Connecting to an Oracle 7 database from Oracle 9i software (db
link, etc) has been full of difficulties. Can you upgrade the Oracle 7
database to a much newer, and supported version? Otherwise, I know
others who have gotten the whole thing to work by using an Oracle 8
database in the middle. Ugly, but it has worked.

HTH,
Brian

Abe wrote:
> 
> Hi,
> 
> I'm trying to acces data on an Ora 7 DB from an Ora 9 DB. Using
> Enterprise manager I've created a db link which should provide this
> functionality. However, when I try to test it I get and error message
> "The Database link is not active". Can anyone assist.
> 
> Thanks
> Abe

-- 
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"