DBUA screen stucked to 73% during oracle upgrade from 3-4 hrs

[former_member610738]

Hi

I started upgrade thru dbua tool but it got stucked at 73% from last 4-5 hrs.

Now i ave cancelled it.

I am going to start it again.

Can any1 advice me wht measures i can take so that it must not get stucked again.

Where i can see the error logs and reason why it happened

Please advice

WR

Swati

[former_member188883 · Accepted solution]

Hi Swati,

Apply bundle patch from March. It has most of the bugs fixed.

Regards,

Deepak Kori

[former_member610738 · Accepted solution]

Now as i have cancelled DBUA.

When i try to startup the server for DBUA , it is showing erorr - "

>

ORA-00205: error in identifying control file, check alert log for more info"

How to resolve this control file issue now.

WR

Swati

[former_member188883 · Accepted solution]

Hi Swati,

You will need to restore your database and oracle binaries and then start again. As you mentioned your dbua has reached 73% when it hanged It implies changes to database has been made.

Also could you check details from alert_SID.log file what is says ?

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Swati,

You will need to restore your database and oracle binaries and then start again. As you mentioned your dbua has reached 73% when it hanged It implies changes to database has been made.

Also could you check details from alert_SID.log file what is says ?

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Swati,

You will need to restore your database and oracle binaries and then start again. As you mentioned your dbua has reached 73% when it hanged It implies changes to database has been made.

Also could you check details from alert_SID.log file what is says ?

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Swati,

You will need to restore your database and oracle binaries and then start again. As you mentioned your dbua has reached 73% when it hanged It implies changes to database has been made.

Also could you check details from alert_SID.log file what is says ?

Regards,

Deepak Kori

[former_member610738 · Accepted solution]

Hi deepak

resolved the above error code but now when i start dbua it is showing new error

"Ora00600 - Internal error"

I think databse has been corrupted and now need to restore it. right?

Also i checked alert_sid.log file , but i cannot see any error.It is just pointing some usertraces files.

Cross verified the location of control files and location given in spfile.

Please advice if i can do something without restoing the d/b or is it compulsory now?

WR

Swati

[former_member188883 · Accepted solution]

Hi Swati,

You need to restore database and oracle binaries. Make you system up and running with source database version. Then begin from scratch.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Swati,

>> resolved the above error code but now when i start dbua it is showing new error

"Ora00600 - Internal error"

Check the trace file(s) belong to the ORA-00600 error located under usertrace.

Best regards,

Orkun Gedik

[former_member610738]

Hi

We retored the backup and started again wth correct MOpatch and Opatch.

But again DBUA screen got stucked at 73%.

What to do next?

Can any1 advice

WR

swati

[former_member610738]

Hi

As nothing helped so going to restore the d/b and perform again the same activity

WR

Swati

[former_member188883]

Hi Swati,

There is no other alternative apart from restore. You may close this thread now.

Make sure you apply bundle patch from March this time.

Regards,

Deepak Kori