Skip to Content
Aug 05, 2010 at 06:08 PM

Oracle Upgrade -- Pre-Upgrade to



I want to do an Oracle Upgrade to version 11.2g!

At this point I did some things (in Windows Server 2003 X64):

1-) Install Oracle (DVD Media);

2-) Installation of Oracle patchset (note 871735);

3-) Installation of interim / last generics patch (note 1137346);

4-) Installation of SAP ECC 6.0 SR3 by SAPInst

5-) After SAP installation I did all the corrections in Oracle parameters as it mentioned in note 830576.

As you see above, all the SAP system was well installed!

But now I want to do the Oracle Upgrade process to the last version, Oracle DB 11.2g ( and so I´m following the Upgrade guide "Upgrade to Oracle Database 11g Release 2 (11.2) Windows.pdf" with some SAP notes for Upgrade process.

So I´m at this point in planning chapter where is recommended to check so things in actual database, one of this checks are running some SQL-scripts to perform an Oracle database upgrade with DBUA to release 11.2 (as mentioned in note 1431793 - Oracle 11.2.0: Upgrade Scripts)

I ran two Pre-Scripts, the @pre_upgrade_status.sql and @pre_upgrade_tasks.sql but both outputs showed some warnings and they are worrying me... so what I ask to you is some kind of help in analyse of them and tell me if this issues are relevant for the upgrading process and if so, what you recommend me to do to correct their!

Next I will post here this two log scripts... they are long!!!