Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Primavera P6 Upgrade Error: ORA-00942: table or view does not exist

Primavera P6 Upgrade Error: ORA-00942: table or view does not exist

I have recently upgraded the Primavera P6 database from 16.1 to 16.2 and got above error during the upgrade. It says table or view does not exist. Even I used Oracle SYSDBA account (sys). Still, it fails.

Instead of upgrading it through automatic, I followed the manual procedure to upgrade the database. That also fails and gives the following errors

I followed the Oracle doc for the manual Primavera P6 upgrade, Page 14

  1. Login as SYS as sysdba
  2. Cd \scripts\upgrade\PM_
  3. ORPM_P161.sql

SQL> @ORPM_P161.sql

DROP VIEW PRIVUSER.PRMAUDIT

*

ERROR at line 1:

ORA-00942: table or view does not exist

DROP VIEW PRIVUSER.PRMAUDITX

*

ERROR at line 1:

ORA-00942: table or view does not exist

Solution

The answer is simple. Use the Oracle SYSTEM user account to upgrade the Primavera P6 database. Also make sure to run the script manual_script_before_upgrade.sql in \database\scripts\install\PM_16_02_00 before running the upgrade script



This post first appeared on Oracle ADF, BPM, BI And Primavera P6 Tutorials, please read the originial post: here

Share the post

Primavera P6 Upgrade Error: ORA-00942: table or view does not exist

×

Subscribe to Oracle Adf, Bpm, Bi And Primavera P6 Tutorials

Get updates delivered right to your inbox!

Thank you for your subscription

×