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

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle REST Data Services - Version 3.0.0 and later
Information in this document applies to any platform.

Symptoms

Attempts to configure ORDS 3.0.1 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.

Cause

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