How To Reset Sys, System, and P6 Schema Passwords In An Oracle XE Instance For P6 Standalone Installations

(Doc ID 1228402.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Goal

The purpose of this document is to provide a utility that can be run to automatically reset all schema user passwords in an Oracle XE instance when the passwords have been forgotten or wish to be reset.

Passwords for the following Oracle XE schema users are defined during P6 v7 Standalone installation and will be reset by this utility:
  • System Schema Users:
    • SYS
    • SYSTEM
  • Project Management Schema Users:
    • ADMPRM$PM
    • PRIVPRM$PM
    • PUBPRM$PM
  • Methodology Management Schema Users:
  • ADMPRM$MM
  • PRIVPRM$MM
  • PUBPRM$MM
*If Methodology Management is not currently installed, you may receive errors resetting those users. This is OK and you may ignore those errors.*

Solution

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