Re: Upgrade from 8.0.5 to 9iR2 on AIX 4.3.3

Rauf,

There should be no problems having seperate Oracle homes for both 8.0.5 and 9.2.0 on the same server.

We currently have 8.0.6 and 9.2.0 on the same server running AIX 4.3.3 Maintenance Level 10 with all Oracle recommended patches for Oracle 9i plus we have the latest certified ANSI 'C' and 'Microfocus' cobol compilers installed. We have had no problems compiling Pro*C or Pro*Cobol under Oracle 8.0.6 or Oracle 9.2.0.

The only problem we encountered was with 'oraenv' after the upgrade. Refer to this note on Metalink.
http://support.oracle.com.sg/metalink/plsql/ml2_documents.showDocument?p_dat abase_id=NOT&p_id=1014906.102
This problem has been outstanding for quite sometime and it still isn't fixed in Oracle 9.2.0.3

By the way AIX 4.3.3 will be desupported this year. If you move to AIX 5.1 or AIX 5.2 (5L) you will have to reinstall Oracle 9.2.0.3 for AIX 5L you cannot use Oracle 9.2.0.3 for AIX 4.3.3.

HTH Roger.

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0304151830.7293564_at_posting.google.com... > "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<SwZma.15166$1s1.240214_at_newsfeeds.bigpond.com>...
> > "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> > news:xvZma.15164$1s1.240138_at_newsfeeds.bigpond.com...
> > >
> > > "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> > > news:92eeeff0.0304151044.3ab51a9d_at_posting.google.com...
> > > > "Roger Jackson" <rjackson1_at_hotkey.net.au> wrote in message
> > news:<3e9befcc_1_at_news.iprimus.com.au>...
> > > > > Rauf,
> > > > >
> > > > > I would recommend that you goto the latest patchset for AIX 4.3.3
> > which
> > is
> > > > > Oracle 9.2.0.3.0 rather than 9.2.0.1.0 and secondly make sure the
> > latest
> > O/S
> > > > > patches are applied to your server or else you will have problems
> > installing
> > > > > Oracle 9.2.
> > > > >
> > > > > By the way you need to be on Oracle 8.0.6 to do a direct upgrade
to
> > 9.2.
> > >
> > > PMFJI: that's not quite true. Upgrades from 7.3.4 are supported, too.
> > >
> > > The doco. for 9i Release 1 erroneously stated that 7 had to migrate to
8
> > > before it could go to 9.
> > >
> > > Regards
> > > HJR

> >
> > PS, but in the context of the original question, you are quite right:
8.0.5
> > has to be patched first to 8.0.6 before the move to 9. My mistake for
> > reading your words literally, and not being careful enough about seeing
what
> > you were replying to. Apologies.

> >

>
>
> Direct upgrade is not an option as mentioned in my previous post.
>
> 1) As far as applying the OS patches, I did not realize this before
> but I can apply the patch and then bring up Oracle 8.0.5 to see if it
> agrees with it. If OK then I can commit the patch or else rollback.
>
> 2) As far as 9i install in the second home... I guess I have to
> install it and hope that both versions will behave with each other as
> they should.
>
> Regards
> /Rauf Sarwar
>