Database Requirements

Oracle Database requirement for OCI360

OCI360 is compatible to execute in Autonomous Database (even in the Always Free option). No DB installation steps are required in this case.

However, you can also run OCI360 on any Oracle Database that meets the following requisites:

• Must be 12.2 or newer release (as DBMS_JSON is only available from this release).
• COMPATIBLE parameter must be set to at least '12.2' (for Long Identifiers).
• MAX_STRING_SIZE parameter must be set to EXTENDED (for DBMS_JSON.CREATE_VIEW procedure).
• The database must run on same server where the oci360 tool will be executed (UTL_FILE and DIRECTORY). - TO BE IMPROVED

If you don't have a database already available, you can follow the steps to create a local Oracle Database 18c XE just for this tool.

Don't forget to enable the Extended String for the database. This is required by OCI360. More details at https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321.

[ORACLE]$ sqlplus sys/xxx@localhost:1521/xepdb1 as sysdba
SQL> shutdown immediate;
Pluggable Database closed.
SQL> startup upgrade;
Pluggable Database opened.
SQL> alter system set MAX_STRING_SIZE='EXTENDED' scope=both;
System altered.
SQL> @?/rdbms/admin/utl32k.sql
Session altered.
...
SQL> shutdown immediate;
Pluggable Database closed.
SQL> startup;
Pluggable Database opened.
SQL> @?/rdbms/admin/utlrp.sql
Session altered.
...
SQL>