Re: Oracle Conversion & replication

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Mon, 04 Nov 2002 18:08:11 GMT
Message-ID: <fIyx9.1540$Xf.104146114@newssvr21.news.prodigy.com>

Richard Cassidy wrote:
> I appreciate we live in the 21st century but business does not, this is my
> dilemma I have to live in, a band-aid mode, patch up until they finally
> agree to open their purse strings and allow supported versions. You would
> cringe if I mentioned the version of OS/390 & DB/2. Thus the only
> communication is converting the Oracle 8 to Oracle 7 and replicating it down
> to the NT Servers. There is no need to read the Oracle 7 data from the
> Oracle 8 server at all . So what do you mean communication will not work
> from 8 to 7.
>

It will work, but I'm not sure what your question is. I assume you have a plan to do the download from v8 to v7? One of the companies where I worked had written their own set of procedures to do this. They didn't like the inflexible, trigger-based replication offered by Oracle (since they wanted to dynamically shuffle around the parent-child-grandchild relationships among databases). Their procedures worked whether v8 or v7 was the parent or the child.

 From the number of Oracle 7 questions posted on this NG, I think you're in good company. Lots of DBAs have to work with unsupported versions.

>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:joc7such1fmsjkuq8judsofn5ne2ctvmu0_at_4ax.com...
>

>>On Sat, 2 Nov 2002 20:13:40 +1100, "Richard Cassidy"
>><richardcassidy_at_ozemail.com.au> wrote:
>>
>>
>>>Need to export OS/390 DB/2 to Oracle 8.1.7 on IBM pSeries running AIX
>>

> 4.1.3
>

>>>then replicate the database to Oracle 7.1 running on NT 4.0 SP6 Servers.
>>

> The
>

>>>static Oracle data is read heavily, the database is updated hence
>>

> replicated
>

>>>maximum once a day.
>>>
>>>Does any one see areas to be observed with data conversion or reasons to
>>>force the workstation application accessing the Oracle 7.1 database to be
>>>re-certified (to ensure availability and no confliction with other
>>

> desktop
>

>>>applications) to version 8. Note the Unix server Oracle 8.1.7 is
>>

> mandatory.
>

>>>Cheers
>>>
>>
>>
>>Oracle 7.1 has been desupported long ago in the previous century.
>>Also communication from 8.1.7 to 7.1 will NOT work.
>>
>>
>>Sybrand Bakker, Senior Oracle DBA
>>
>>To reply remove -verwijderdit from my e-mail address

>
>
>
Received on Mon Nov 04 2002 - 12:08:11 CST