Error 'ORA-01031: Insufficient Privileges' When Connecting to OracleXE for a Schema Password Change
(Doc ID 1352169.1)
Last updated on MARCH 22, 2022
Applies to:
Primavera P6 Professional Project Management - Version 7.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to login to P6 Professional, 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 (ex. sqlplus /@xe as sysdba), the following error occurs:
ORA-01031: Insufficient privileges
or
Bad public user name or password. ORA-12546: TNS:permission denied;
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |