Installing an Oracle Database

5.1.5 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.

Administrators should be aware of the following:

For full details on supported database versions, see Oracle Fusion Middleware Supported System Configurations.
Pluggable databases (PDB) are supported.
The database parameters should be set as per Repository Creation Utility Requirements.

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.

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

5.1.5.1 Configuration Checkpoint

Before proceeding make sure you have the following information for the database where the OAA schemas will be loaded:

Variable	Sample Value	Description
<DB_HOST>	`db.example.com`	The fully qualified hostname of the database server.
<DB_PORT>	`1521`	The database listener port.
<DB_SERVICE>	`orcl.example.com`	The database service name.
<DB_NAME>	`orcl`	The database name.
<SYS_PWD>	`password`	The password of the SYS user in the database.

Make sure the database listener is running:
```
lsnrctl status
```

Make sure the database is running and DB_CREATE_FILE_DEST is set:

SQL>  connect SYS/<password> as SYSDBA;

show parameter DB_CREATE_FILE_DEST;

The output should be similar to the following:


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

If there above does not return a value, refer back to Installing an Oracle Database before proceeding.