Oracle DataBase Upgradation Time

[Former Member]

Hello Experts,

Database size is 97GB,

I want to Upgrade database from 10.2.0.1.0 To 10.2.0.2.0.

How much time it will take for Upgradation process ??.

Thanks,

Rahul S.S.

[markus_doehr2 · Accepted solution]

> I want to Upgrade database from 10.2.0.1.0 To 10.2.0.2.0.

And just to add:

If you installed the system with 10.2.0.1 you may now already have corruptions in the database. That release was never officially supported (but in the Rampup).

Markus

[Former Member]

Hi,

Why not upgrade to 10.2.0.5 instead .... ???

You should be able to test how long it will take if you do the upgrade on your DEV/QA box.

[Former Member]

Why not upgrade to 10.2.0.5 instead .... ???

No we cant do that its not a suported version from SAP.

Only option you have is 10.2.0.2 or 10.2.0.4 or else is 11.2.0

Also as mentioned in above thread 10.2.0.1 was never supported, may be you want to upgrade to 10.2.0.4 which may be a job of hours , but always depends upon your skills as well.

Regards,

[stefan_koehler]

Hello Rahul,

> How much time it will take for Upgradation process ??

the duration of the upgrade process has nothing to do with the database size itself (the application data itself remains the same).

Only the oracle dictionary and the binaries are updated in this process, so the time depends on your hardware (mostly on CPU and I/O).

Regards

Stefan