Re: Coexisting Oracle 7.3.4 and 8i on Solaris

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 12 Apr 2001 16:52:30 +0100
Message-ID: <987090764.23569.0.nnrp-02.c30bdde2@news.demon.co.uk>

Here's my personal experience of doing this - others may have better (different) ideas as well.

First off, I never used dbstart/dbstop to bring up the databases, but my own bespoke scripts (I have other things I need to do at the same time). You should perhaps look into using dbstart etc for O8 as it will hopefully start the O7 databases as well (as long as oratab is changed appropriately).

What I did was create a new ORACLE_HOME (obv.), and install O8 into that. Then, I used the O8 listener with appropriate listener.ora to fire incoming connections off to the appropriate database. There's just not much more to it than that (well, that I can remember anyway).

Instead of migrating, you might like to consider this a good time to perform a full export/import instead, perhaps correcting any 'mistakes' or whatever.

"Philippe Gauthier" <elfelip_at_yahoo.com> wrote in message news:3AD5B5A2.48151524_at_yahoo.com...
> Hello
>
> I have 5 differents databases using Oracle 7.3.4 on my Solaris system
> and I have to migrate one of them to Oracle 8i. The remaing databases
> must stay on Oracle 7.3.4. I know that I have to install Oracle 8i on a
> different ORACLE_HOME and migrate my database with Oracle 8i tools. Is
> anyone have hints what is the best way to do that and how I have to
> configure my starting scripts to start automatically all the Oracle 7
> and 8i databases an listeners on boot time.
>
> Thankyou.
>
Received on Thu Apr 12 2001 - 10:52:30 CDT