Oracle 9.2.0.5 to 10.2.0.2 error in structure upgrade

[Former Member]

On AIX 5.2 64bit with ECC 5.0 and Oracle 9.2.0.5

Going through guide and notes and have installed software and applied patches and intereim patches. When doing structure upgrade with dbua, I get an error:

ERROR at line 1:

ORA-04063: package body "SYS.DBMS_DATAPUMP" has errors

ORA-06508: PL/SQL: could not find program unit being called:

"SYS.DBMS_DATAPUMP"

any ideas?

[Former Member]

Hi Michael,

I had DBUA problem when I was upgrading Oracle 9.2.0.5 to 10g, but problem got resolved when I upgraded the source to 9.2.0.7. This I was upgrading as SCM upgrade pre-requisite.

One more thing do not forget to increase temp tablespace size and other recommendations of upgrade check sql.

I am sure you will not face problem, if you adopt these things.

If you have still find difficulty, do mail me in harsh.praveen@gmail.com I have customise upgrade document.

Thanks & Regards

Praveen Verma.

[Former Member]

Increase the Shared Pool Size and restard the Database, that may resolve your problem.

Thanks & Regards

Prabakaran.S