Error: "Unable to resolve priviledged username and password. Ora-00942: table or view does not exist" When Configuring Database Connection Using 'dbconfigpv' Tool

(Doc ID 2376002.1)

Last updated on APRIL 05, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Primavera P6 Professional Project Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to configure database connection by executing dbconfigpv.cmd (or .sh), after entering the correct public username and password then Next, the following error occurs.

ERROR
-----------------------
"Unable to resolve priviledged username and password. ORA-00942 table or view does not exist".


STEPS TO REPRODUCE
---------------------------
The issue can be reproduced at will with the following steps:

  1. Run dbconfigpv.sh, enter the correct Public username and password then press Next.
  2. Pop up above error.

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