Project and Portfolio Management Practitioners Forum
cancel

Exporting PPM's DB Schema!

Highlighted
M13
Respected Contributor.

Exporting PPM's DB Schema!

Hi everyone,

I am trying to export the schema of PPM's DB & the RML schema to import to a new DB in order to create a new PPM instance. But I am facing some problems regarding exporting..

When i run the following exp command:

$ORACLE_HOME/bin/exp USERID=system/@
FILE= OWNER= LOG=c:/export_
knta_750.log

I get the following errors:

EXP-00008: ORACLE error 29516 encountered
ORA-29515: Aurora assertion failure: Assertion failure at eox.c:317
Uncaught exception Root of all Java exceptions: java.lang.NullPointerException
EXP-00000: Export terminated unsuccessfully

Does anyone have any explanations .. i googled the errors but nothing is useful.

A snapshot is attached,
Thanks in advance for your help...
Ahmed
1 REPLY
Alexei Malinovs
Respected Contributor.

Re: Exporting PPM's DB Schema!

Please consider the following comment on your own risk and always make a backup of all data in DB before applying it.

In case you upgraded Oracle server or you use PPM database created in older Oracle version on a newer version you needed to patch your database before the Export if you have not done so. We upgraded Oracle 9.2.0.6 to 9.2.0.7 and we needed to run following commands in SQL Plus in order to Exp function to work:

shutdown
startup migrate
@?/rdbms/admin/catpatch.sql
shutdown immediate
startup
@?/rdbms/admin/catmeta.sql


Also, when you run those commands PPM server must be shut down as well. Otherwise "shutdown immediate" will hang.

Important! Above scripts will update your database tables. Execute them on you own risk. I give no garantee that it will not corrupt or destroy your DB. :)