RE: database upgrade question
Date: Tue, 23 Apr 2013 19:35:55 +0000
Message-ID: <92C2516C1D75EB4A922A8EE402EC23D55540EC59_at_helo.usa.burton.com>
I did this same upgrade on our production system during scheduled downtime just three days ago, though I was using an SAP Bundle Patch (SAP's repackaged version of the regular PSU.)
To upgrade from 10.2.0.4 to 11.2.0.3 with a PSU (not the latest PSU, but a recent one) I first installed the 11.2.0.3 database home, then ran the opatch portion of the PSU to patch the 11g software home. After that I copied and adjusted the tnsnames.ora/listener.ora/sqlnet.ora files from the 10g database home to 11g, ran the various pre-upgrade checks on the 10g database and then ran the upgrade with DBUA.
After DBUA completed I started up the database from the 11g home and ran the catbundle portions of the PSU, then followed up with the rest of my post-upgrade tasks like updating dictionary and system statistics.
Everything has gone fine for us.
Good luck!
> All,
> I am planning to upgrade one 10.2.0.4 database to 11gR2
>
> So I see that it is supported for direct upgrade from 10.2.0.4 to 11.2.0.3
>
> But I also want to have the latest PSU applied .
>
> So should I install the 11.2.0.3 software +PSU patch and then perform
> the database upgrade
>
> or I have to do the database upgrade from 10.2.0.4 to 11.2.0.3 and then
> perform the PSU apply
>
> Please advise
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 23 2013 - 21:35:55 CEST