Upgrade failed

All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Upgrade failed

Postby royalyogi » Fri May 03, 2013 4:06 am

We are handling more then 6000 databases. So we are getting more issue

Generally database upgrade will run 1.30 Hrs. But one day database run 60minutes then upgrade failed due to Power/some issue.
we don't want restart upgrade from starting point(rerun - catupgrd.sql) How can we complete our upgrade in another 30minutes.

Please help me here.

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Upgrade failed

Postby Tim... » Fri May 03, 2013 6:45 am


You can't. Your system is in an inconsistent state. I would suggest you run the catupgrd.sql script again. If you have any issues, restore a backup prior to the upgrade and start again.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests