Creating a Database on PMEM Storage Using Oracle DBCA

Starting with Oracle Database 23ai, you can use Oracle DBCA, in either interactive or silent mode, to select persistent memory (PMEM) as your storage option when creating a single-instance database.

1. Start Oracle Database Configuration Assistant (Oracle DBCA).

   $ cd $ORACLE_HOME/bin
   $ ./dbca

2. In the Select Database Operation screen, select Create a database and click Next.
3. In the Select Database Creation Mode screen, select Advanced configuration and click Next.
4. In the Select Database Deployment type screen, select Oracle single instance database, as the Database type. Select an appropriate template for your database. Click Next.
5. In the Specify Database Identification Details page, for the Global database name, enter the database name in the form database_name.domain_name. In the SID field, enter the system identifier. The SID defaults to the database name and uniquely identifies the instance that runs the database.

   You can choose to create either an empty container database (CDB) or a CDB with one or more pluggable databases (PDB). Enter the number of PDBs to create in the Number of PDBs field. In the PDB Name field, specify a name to use for the PDB or PDBs to be created. When you create multiple PDBs, the PDB name you specify is used as a prefix for the PDBs to be created. Click Next.

6. In the Select Database Storage Option screen, select Use following for the database storage attributes.

   Specify the Database files storage type as PMEM File System. Browse to specify the location of your PMEM storage in the Database files location field.

   Specify the PMEM File System. The PMEM File System can use either a PMEM filestore, a DAX-enabled file system, or the Oracle Memory Speed file system. Specify the PMEM File System Size.

   Select Use Oracle-Managed Files (OMF), to directly manage operating system files comprising an Oracle Database.

7. Respond to the configuration screens and prompts as needed to complete the database creation process. Configuration screens vary depending on the configuration option that you select.

   Note:

   Click Help if you have any questions about the information you are asked to submit during database creation.