4.2 Using Oracle Database with Exascale

This topic outlines how Exascale storage natively supports Oracle Database.

Starting with Oracle Database 23ai (release 23.5.0), you can use Exascale to natively store Oracle Database files such as data files, control files, log files, and so on.

Following is a high-level overview of the procedure for using Oracle Database in conjunction with Exascale. This procedure is automated for you when you use Oracle Exadata Deployment Assistant (OEDA) to create an Oracle database that uses Exascale storage.

1. Provision an Exascale user to manage the Oracle Database files.

   The same Exascale user must be used to access the database files on all nodes in the database cluster.

2. Create an Exascale vault for the Oracle Database files.

   You can dedicate a vault to store the files for one database, or you can use a vault to store the files for many databases.

3. Install the Exascale user wallet on every node in the database cluster.

4. Use the Exascale vault as the location for Oracle Database files.

   Referencing Oracle Database files on Exascale is essentially the same as using Oracle Automatic Storage Management (ASM). The fundamental difference is that you use an Exascale vault instead of an ASM disk group.

   In the following fully-qualified file name example, @MYVAULT specifies the vault that contains the data file.

   SQL> CREATE TABLESPACE mytbs1 DATAFILE '@MYVAULT/mydbfiles/data/mytbs1.dbf' SIZE 10G;