Error: "ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", ORA-06512: at "ADMUSER.SECPAC"" When Attempting To Connect To An Oracle Database Using A P6 EPPM Schema User (Doc ID 1423794.1)

Last updated on APRIL 27, 2017

Applies to:

Symptoms

When attempting to connect to an Oracle database using the public user (by default, pubuser), the privileged user (by default, privuser) or the reporting database user ( by default, pxrptuser) the following error occurs:

ERROR
-------------------
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 90
ORA-06512: at "ADMUSER.SECPAC", line 8
ORA-06512: at "ADMUSER.SECPAC", line 36
ORA-06512: at "ADMUSER.SECPAC", line 52
ORA-06512: at line 2
;

Note: 

• This can occur when connecting to the Oracle database using a tool like SQL*Plus, SQL Developer or when using any P6 EPPM module to connect to the P6 EPPM schema.
• This can occur most frequently after a schema import from a dump file.

Changes

Cause