Oracle REST Data Services system requirements are as follows:

• A currently supported version of Oracle Database.

  See Also:

  Oracle Lifetime Support Policy
• Use one of the following:
  • Oracle Java version 11, 17, or 21
  • Oracle GraalVM Enterprise Edition for Java version 11, 17, or 21

  Note:

  On Linux system, if the Oracle Java version is lower than 11, then the installation fails with an error message. For example:

  Error: ORDS requires Java 11 and above to run.
         Found Java version 1.
         Please set JAVA_HOME to appropriate version and update PATH if necessary.

  So, you must set JAVA_HOME to the appropriate version and update the PATH if required.

  On Windows system, the user is re-directed to the Java download page.

• Web browser requirements: Refer to Oracle Software Web Browser Support Policy for more information.

Oracle REST Data Services supports the following Java EE application servers:

Oracle REST Data Services supports the currently supported versions of APEX.

As part of the Oracle REST Data Services installation, privileges are granted to several users and roles:

• ORDS_RUNTIME_ROLE role
  • ORDS_RUNTIME_ROLE is granted EXECUTE on the following packages if these packages are not granted EXECUTE to PUBLIC:
    • SYS.DBMS_LOB
    • SYS.DBMS_SESSION
    • SYS.DBMS_UTILITY
    • SYS.WPIUTL
  • ORDS_RUNTIME_ROLE is granted the necessary ORDS_METADATA object privileges to determine the repository version and to access the connection pool configurations.
• ORDS_PUBLIC_USER user
  • ORDS_PUBLIC_USER is granted connect to allow connection to the database.
  • ORDS_PUBLIC_USER is granted role, ORDS_RUNTIME_ROLE to allow the user to act as an ORDS runtime user
• ORDS_ADMINISTRATOR_ROLE role
  • ORDS_ADMINISTRATOR_ROLE is granted EXECUTE on ORDS_METADATA.ORDS_ADMIN PL/SQL package.
• PUBLIC
  • PUBLIC is granted EXECUTE on ORDS_METADATA.ORDS_REPVERSION view to allow the repository version to be queried by anyone.
  • PUBLIC is granted SELECT on many ORDS_METADATA views.
  • PUBLIC is granted EXECUTE on ORDS_METADATA PL/SQL packages that are available for developer users.
• ORDS_METADATA schema
  • ORDS_METADATA schema is granted on the following packages if these packages are not granted EXECUTE on PUBLIC:
    • SYS.DBMS_ASSERT
    • SYS.DBMS_LOB
    • SYS.DBMS_OUTPUT
    • SYS.DBMS_SCHEDULER
    • SYS.DBMS_SESSION
    • SYS.DBMS_UTILITY
    • SYS.DEFAULT_JOB_CLASS
    • SYS.HTP
    • SYS.OWA
    • SYS.WPG_DOCLOAD
  • ORDS_METADATA is granted SELECT (11g) or READ (12c or later) on the following view if it is not granted SELECT or READ to PUBLIC:
    • SYS.SESSION_PRIVS
  • ORDS_METADATA schema is granted EXECUTE on the following packages:
    • SYS.DBMS_CRYPTO
    • SYS.DBMS_METADATA
  • ORDS_METADATA schema is granted SELECT (11g) or READ (12c or later) on the following views:
    • SYS.DBA_OBJECTS
    • SYS.DBA_ROLE_PRIVS
    • SYS.DBA_TAB_COLUMNS
  • ORDS_METADATA schema is granted SELECT including WITH GRANT OPTION on the following views:
    • SYS.USER_CONS_COLUMNS
    • SYS.USER_CONSTRAINTS
    • SYS.USER_OBJECTS
    • SYS.USER_PROCEDURES
    • SYS.USER_TAB_COLUMNS
    • SYS.USER_TABLES
    • SYS.USER_VIEWS
  • ORDS_METADATA schema is granted the following system privileges:
    • ALTER USER
    • CREATE ANY TRIGGER
    • CREATE JOB
    • CREATE VIEW
    • CREATE PUBLIC SYNONYM
    • DROP PUBLIC SYNONYM
  • ORDS_METADATA schema is granted the necessary object privileges to migrate Application Express REST data to ORDS_METADATA tables.
  • ORDS_METADATA schema is granted ORDS_ADMINISTRATOR_ROLE, ORDS_RUNTIME_ROLE roles with administrator option.

• PUBLIC is granted SELECT on many ORDS_METADATA tables and views.

• PUBLIC is granted EXECUTE on PL/SQL packages that are available for users to invoke.

• ORDS_METADATA is granted EXECUTE on the following packages if these packages are not granted EXECUTE to PUBLIC:

  • SYS.DBMS_ASSERT
  • SYS.DBMS_LOB
  • SYS.DBMS_OUTPUT
  • SYS.DBMS_SCHEDULER
  • SYS.DBMS_SESSION
  • SYS.DBMS_UTILITY
  • SYS.DEFAULT_JOB_CLASS
  • SYS.HTP
  • SYS.OWA
  • SYS.WPG_DOCLOAD

• ORDS_METADATA is granted the necessary object privileges to migrate Application Express REST data to ORDS_METADATA tables.

Oracle REST Data Services uses the following database users: