Oracle Requirements
Stages supports the following Oracle versions:
- 12c
- 19c
For Oracle 12.2, this patch needs to be installed: Patch #25818707: PLSQL COMPILATION FAILS WITH ORA-06555 WHEN USING STANDARD OBJECT NAME IN 12.2
Stages requires a separate tablespace on the Oracle server.
To access Oracle with Stages a technical/proxy user with at least the following permissions is necessary:
- CREATE SESSION
- CREATE SEQUENCE
- CREATE TABLE
- CREATE TRIGGER
- CREATE PROCEDURE
- CREATE VIEW
- CREATE MATERIALIZED VIEW
- EXECUTE ON SYS.DBMS_CRYPTO
- QUERY REWRITE
- UNLIMITED TABLESPACE (or enough tablespace)
Stages needs a database with NLS_LENGTH_SEMANTICS set to “CHAR”.
It is recommended to set NLS_CHARACTERSET to “AL32UTF8” and NLS_NCHAR_CHARACTERSET to “AL16UTF16”.
For optimal performance, set the “cursor_sharing” parameter to “force”.