Oracle REST Data Services (ORDS) 3.X Configuration Raises Error for Remote Connections - ORA-01031: insufficient privileges (Doc ID 2070058.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Symptoms

Attempts to configure ORDS  fail with both the ORDS command line and the ORDS configuration utility in SQL Developer. The error is largely the same. These configuration attempts are being performed on a machine separate from the database server.
At the point where the SYS account and password is supplied, to confirm the presence of or create the ORDS_METADATA and ORDS_PUBLIC_USER schemas, the SYS account credentials are rejected with an error.

From the Command Line:

However, it is confirmed that the SYS account and password are valid, connections to the database using SQL Plus on the server as SYS AS SYSDBA are successful.

Changes

Cause

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