My Oracle Support Banner

Error: "SQL Error: ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges"" When Attempting to Establish a P6 DACS Connection (Doc ID 2371713.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.12.1.0 and later
Information in this document applies to any platform.

Symptoms

When trying to create a link to the P6 EPPM DACS connection, the following error occurs:

ERROR

Error at Command Line:1 Column:29
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password without the appropriate privilege. This error occurs if attempting to install a database without the necessary operating privileges.

STEPS

The issue can be reproduced at will with the following steps:
1. Connect to a local database
2. Run the command to create a public link to the DACS Database.
3. Observe the error.

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.