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: Upgrade from Oracle 7.3 to 9i and migrate from HPUX to Linux

Re: Upgrade from Oracle 7.3 to 9i and migrate from HPUX to Linux

From: Edzard <edzard_at_volcanomail.com>
Date: 2 Aug 2002 02:32:43 -0700
Message-ID: <5d75e934.0208020132.1aaa115c@posting.google.com>


Hello,

In my opinion the server platform is a black-box, that is the great thing of Oracle. So it should not matter if you install Oracle9i on HP/UX or Linux (assuming you are purely moving the database, not any application things). I do not see how you can move to Linux if you first have to do an expensive test setup with HP/UX.

But:
- Test or scan your application for the use of rowids! The rowid-structure is changed in 8 and 9i (may be longer than 18 when converted to char).
- You can import a Oracle7 dumpt straight into Oracle9i, but you can not import a Oracle9i dump back into Oracle7. So there is no way back after the cut-over.

Edzard

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D49A2B5.494A0348_at_exesolutions.com>...
> Don Seiler wrote:
>
> > Hullo.
> >
> > I am planning on doing the double-whammy. I want to upgrade from
> > Oracle 7.3.4.5 to Oracle 9i (presumably 9.2.0 unless someone objects).
> > Currently this is on HP-UX.
> >
> > I also want to migrate off of HP and onto x86 Linux.
> >
> > I know that 9i comes with handy documentation on the version upgrade.
> > I'm wondering if it is possible to simultaneously do the platform
> > change. Better question is: Is it wise or insanely dangerous?
> >
> > Any advice will be appreciated.
> >
> > Thanks.
>
> Incremental change is safer.
>
> Running through it a few times on a test server safer still.
>
> Don't pull the plug on the old one until you are absoutely sure you have
> been successful.
>
> Daniel Morgan
Received on Fri Aug 02 2002 - 04:32:43 CDT

Original text of this message

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