Solved: DB upgrade error

Former Member · ‎01-03-2009

Hi,

I have a wierd problem.

I had ERP04 on Oracle 9.2.0.6. We are going to ERP05

So i was upgrading my DB to 10.2.0.2

I had completed all the prerequisites, installed 10.0.0.1 and upgraded to patch 10.0.0.2 according to DB upgrade guide.

I was running DBUA, it was upgrading and was around 10-12% complete.

Then suddenly network broke for a min or 2. And DBUA screen went off.

When I am starting to restart DBUA, it is working.

I changed again name back to my old DB in /etc/oratab.

Old DB is getting mounted but not getting opened.

My trace file under /oracle/RD1/saptrace/usertrace gives the below listed error

-

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01406: fetched column value was truncated

-

And alert log files says that there was an error shown in trace file above.

Is there anything i can do to solve this?

Regards,

Tajinder

stefan_koehler · ‎01-03-2009

Hello Tajinder,

> Is there anything i can do to solve this?

Unfortunately not. This problem is described in metalink note #427585.1.

Solution: Restore a cold backup of the database from before the upgrade attempt was made and then reaccomplish the upgrade

I had this issue once. Also restored the database and restarted.

Regards

Stefan

DB upgrade error