Oracle REST Data Services (ORDS) 3.X Configuration Raises Error for Remote Connections - ORA-01031: insufficient privileges
Last updated on NOVEMBER 21, 2017
Applies to:Oracle REST Data Services - Version 3.0.0 and later
Information in this document applies to any platform.
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.
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