ora-01031 insufficient privileges When upgrading an OPPM database (Doc ID 1663276.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera Portfolio Management - Version 9.0 SP2 and later
Information in this document applies to any platform.

Symptoms

On :  9.0 SP2 version, Installation

When attempting to upgrade an existing OPPM 9SP1 database to 9SP2,
the following error occurs.

ERROR
-----------------------
ora-01031 insufficient privileges

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. in the OPPM console select to add a database
2. type the information of the exiting instance using TNS connection settings
3. Make this database the current OPPM database is selected
4. the console will stop the services during the process and then the error occur

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upgrade the database

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms