Hi, im upgrading test databases before we do the production ones, and i have 1 database that is taking over 12 hours to upgrade using DBUA.
Im using Aix and currently on 10.2.0.5 going to 11.2.0.3.
After running the pre-upgrade script and addressing any issues the only 2 warnings left were:
Review any events or trace events and another saying EM Database Control Repository exists in the database.
.... Direct downgrade of EM Database Control is not supported.
I dont know of any events running and do not use EM Database control so have not done anything regarding these.
During the upgrade i get 2 red crosses for upgrading olap catalog and olap analytic workspace
After the upgrade everything seems ok but the time will not be acceptable in production.
I restored back to 10.2.0.5 and turned off flashback and archiving just in case this made any difference. Ran upgrade again but took the same amount of time.
Its a very small database with no other additional features. The other databases upgrade in around 2 hours.
Ive had a look in the dbua logs but cant see anything. Any ideas what could be causing this to take so long?
Many thanks