"ORA-01031: Insufficient Privileges" When Connecting to OracleXE for Schema Password Change

(Doc ID 1352169.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Primavera P6 Professional Project Management - Version 7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jan-2014***


When attempting to login to Project Management, the the following error occurs:


"Unable to connect to the database. Would you like to configure the database connection now?"

When attempting to configure the database connection, the Oracle XE schema passwords are unknown making a successful database configuration not possible.

Therefore, when attempting to login to SQLPlus to change the schema passwords (sqlplus /@xe as sysdba), the following error occurs:


ORA-01031: insufficient privileges


Bad public user name or password. ORA-12546: TNS:permission denied;



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