4.2.2 Installing an Oracle Database

OAA, OARM, and OUA uses a database schema to store information. You must install and configure an Oracle Database either on OCI or on-premises. The database must support partitioning feature/capabilities.

OAA, OARM, and OUA supports Oracle Database 12c (12.2.0.1+), 18c, and 19c. For more detailed information on supported database versions, see http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html.

The Kubernetes cluster where OAA, OARM, and OUA is to be installed, must have network connectivity to the database.

Note:

If using a non ASM database, you must make sure that the database has the parameter DB_CREATE_FILE_DEST set. For example:

SQL> connect SYS/<password> as SYSDBA;
Connected.
SQL> show parameter DB_CREATE_FILE_DEST;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string      /u01/app/oracle/oradata

If the parameter is not set, run the following:

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata' scope=both;

where /u01/app/oracle/oradata is the path where your datafiles reside.