Error in DBUA while upgrading oracle 9.2 - 10.2 with sistem copy

[Former Member]

Hi experts!

we are in a critical upgrade project, and faced the following

error while performing a system copy/upgrade of oracle version

from 9.2 to 10.2 (windows 2000 32bit to win 2003 64bits) acording to the procedure indicated in

sapnote: Note 932722 - Upgrade to Oracle 10.2 during a database copy

we checked all the prerequisites, followed all the steps with

sucess, until the part where DBUA was invocated.

in that step the following java exception was launched:

output from the remotedbua.pl script atached in the note 932722:

-

---

Sun Oct 11 04:53:10 2009 - verifying file locations.

Instance created.

Sun Oct 11 04:53:28 2009 - new TIO service created.

Sun Oct 11 04:53:38 2009 - database started.

Sun Oct 11 04:53:38 2009 - starting database upgrade. AQUI

J:/oracle/MAE/102/assistants/dbua/jlib/dbma.jar,

J:/oracle/MAE/102/assistants/dbua/jlib/dbma.jar.0

J:/932722/Upgrade10g64bit_v3/dbma.jar,

J:/oracle/MAE/102/assistants/dbua/jlib/dbma.jar

Exception in thread "main" java.lang.NoClassDefFoundError:

oracle/sysman/assistants/util/em/ManagementOptionsPage

at oracle.sysman.assistants.dbma.ui.UICompManager.<init>

(UICompManager.java:153)

at oracle.sysman.assistants.dbma.Dbma.getCompManager

(Dbma.java:154)

at oracle.sysman.assistants.dbma.Dbma.execute(Dbma.java:98)

at oracle.sysman.assistants.dbma.Dbma.statusMain(Dbma.java:199)

at oracle.sysman.assistants.dbma.Dbma.main(Dbma.java:180)

Sun Oct 11 04:53:39 2009 - Error: database upgrade failed.

-

---

dbua, while loading, cant find all the necessary classes, in

the dbma.jar archive. that is suplied in the note.

we tried to run dbua in -verbose mode and it seems that

the problem is not in java classpath, since the dbua.bat

loads sucessfully other classes present in dbma.jar, but not

all, giving the exception that indicates that not all of them

are presente in the dbma.jar file, suplied int the note!

[Loaded oracle.sysman.assistants.dbma.ui.SPFilePage from

file:/J:/oracle/MAE

[Loaded oracle.sysman.assistants.dbma.ui.BackupPage from

file:/J:/oracle/MAE

Exception in thread "main" java.lang.NoClassDefFoundError:

oracle/sysman/ass

at oracle.sysman.assistants.dbma.ui.UICompManager.<init>

(UICompManag

at oracle.sysman.assistants.dbma.Dbma.getCompManager

(Dbma.java:154)

at oracle.sysman.assistants.dbma.Dbma.execute(Dbma.java:98)

at oracle.sysman.assistants.dbma.Dbma.statusMain(Dbma.java:199)

at oracle.sysman.assistants.dbma.Dbma.main(Dbma.java:180)

[Loaded java.lang.Shutdown from J:\oracle\MAE\102\jdk\jre\lib\rt.jar]

[Loaded java.lang.Shutdown$Lock from J:\oracle\MAE\102

\jdk\jre\lib\rt.jar]

we also tried to execute the dbua.bat, and the same error insues.

we cant pass to the next upgrade step, until this critical echo is

resolved!

Please Advise!! Best Regards Ricardo

[Former Member]

many thanks. I'm still awaiting response from SAP

could you mail the JAR to jonathan.ward @ chelfordgroup.com pls?

[Former Member]

was your target release 10.2.0.4?

I have the same error running a system copy/upgrade

Can you provide the revised jar file as I'm waiting on SAP

Did you just restart remotedbua.pl after the error or did you need to copy the database again from the source system?

[Former Member]

Hi Jon,

- yes, our target version is 10.2.0.4

-the dbma.jar file from note 932722 is still the wrong one, the correct one has 1.185KB, you need to provide

a way for me to send it to you, because sdn doenst allow attachments

- when you have the correct dbma.jar, you just have to restart remotedbua.pl, and you Dont have to copy

the database again

When you have the correct dbma.jar file, the DBUA gui pops up and the rest of the upgrade is smooth... we had

only some, minor, strange errors on the sysaux size miscalculation

Best Regards,

Ricardo Caramona

[Former Member]

Hi Mark, first of all thanks for the reply.

after talking to sap support, we came to the conclusion that the problem was on the dbma.jar file

atached to the note 932722.

the file is missing java classes, so the dbua doenst work, because, the remotedua.pl script,

copies the file dbma.jar of the note, to the original one in the oracle instalation.

it renames the original to ".0", so if you run the script two times, the original is lost.

the problem was solved by requesting another dbma.jar file from sap.

sap probably will correct note 932722, in order to update the attached dbma.jar file to a good one.

Best Regards,

Ricardo Caramona

[markus_doehr2]

> we cant pass to the next upgrade step, until this critical echo is

> resolved!

I would run the "manual upgrade" without using DBUA. This avoids any problem with the upgrade tool.

Markus