For the complete syntax for the ODACLI create database options, please refer to the CLI Documentation from Oracle.

First list the database homes available for you to leverage:

# odacli list-dbhomes
ID                                       Name                 DB Version                               Home Location                                 Status    
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
2fb3858a-61a7-4f49-b792-695c619d7cee     OraDB18000_home1     18.1.0.0.0                               /u01/app/oracle/product/18.0.0.0/dbhome_1     CONFIGURED
880eca0b-eed7-497f-8a69-fedc1db34130     OraDB12102_home2     12.1.0.2.160419                          /u01/app/oracle/product/12.1.0.2/dbhome_2     CONFIGURED
c1c52e57-53e9-4791-b553-32cc2c280ca4     OraDB12102_home1     12.1.0.2.160419                          /u01/app/oracle/product/12.1.0.2/dbhome_1     CONFIGURED
d5003afa-ba43-4453-add6-67444ed83d9d     OraDB19000_home1     19.9.0.0.201020                          /u01/app/oracle/product/19.0.0.0/dbhome_1     CONFIGURED

We are going to create an Oracle 19c database, so we will use the ID from the OraDB19000_home1. Execute the following ODACLI command to create a 2-node RAC database on ASM called DEV with a pluggable database called pdb1. For the SYS, SYSTEM and PDB Admin user password, we must meet the following requirements for passwords:

password length (minimum: 9 / maximum: 30) characters
password should contain ALL of the following:
a) at least two uppercase letters
b) at least two lowercase letters
c) at least two numbers
d) at least two special characters, valid characters are # _ –

[root@odax8a ContentsXML]# odacli create-database -n DEV -cl oltp -dh d5003afa-ba43-4453-add6-67444ed83d9d -s odb1 -p pdb1 -r ASM -c -y RAC

Enter SYS, SYSTEM and PDB Admin user password: OraBora123##
Retype SYS, SYSTEM and PDB Admin user password:

Job details                                                      
----------------------------------------------------------------
                     ID:  c2cbce12-82bd-41a1-ae5d-86dd363ce5b6
            Description:  Database service creation with db name: DEV
                 Status:  Created
                Created:  May 24, 2021 7:22:01 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------

We can obtain the status of the database creation job with the describe-job option:

[root@odax8a ContentsXML]# odacli describe-job -i c2cbce12-82bd-41a1-ae5d-86dd363ce5b6

Job details                                                      
----------------------------------------------------------------
                     ID:  c2cbce12-82bd-41a1-ae5d-86dd363ce5b6
            Description:  Database service creation with db name: DEV
                 Status:  Running
                Created:  May 24, 2021 7:22:01 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance               May 24, 2021 7:22:02 PM CDT         May 24, 2021 7:22:02 PM CDT         Success   
Database Service creation                May 24, 2021 7:22:04 PM CDT         May 24, 2021 7:22:04 PM CDT         Running   
Database Creation                        May 24, 2021 7:22:04 PM CDT         May 24, 2021 7:22:04 PM CDT         Running   

We can review the dcs-agent.log file to see the details of the tasks that Oracle is performing:

[root@odax8a ContentsXML]# tail -30f /opt/oracle/dcs/log/dcs-agent.log
    "tags" : [ ],
    "reportLevel" : "Info"
  }, {
    "updatedTime" : "Mon May 24, 2021 19:22:04.449 (CDT) [1621902124449]",
    "startTime" : "Mon May 24, 2021 19:22:04.445 (CDT) [1621902124445]",
    "endTime" : "Mon May 24, 2021 19:22:04.449 (CDT) [1621902124449]",
    "taskId" : "TaskZJsonRpcExt_402",
    "status" : "Running",
    "taskResult" : "",
    "taskName" : "Database Creation",
    "taskDescription" : null,
    "parentTaskId" : "TaskSequential_401",
    "jobId" : "c2cbce12-82bd-41a1-ae5d-86dd363ce5b6",
    "tags" : [ ],
    "reportLevel" : "Info"
  } ],
  "createTimestamp" : "Mon May 24, 2021 19:22:01.097 (CDT) [1621902121097]",
  "resourceList" : [ {
    "updatedTime" : "Mon May 24, 2021 19:22:02.743 (CDT) [1621902122743]",
    "resourceId" : "203ee5ff-53ed-41aa-bb3e-b8a4fa5d0681",
    "jobId" : "c2cbce12-82bd-41a1-ae5d-86dd363ce5b6",
    "resourceType" : "DB"
  }, {
    "updatedTime" : "Mon May 24, 2021 19:22:02.500 (CDT) [1621902122500]",
    "resourceId" : "f8d5de58-1763-4959-b2f3-cdd8f9675b2c",
    "jobId" : "c2cbce12-82bd-41a1-ae5d-86dd363ce5b6",
    "resourceType" : "Storage"
  } ],
  "description" : "Database service creation with db name: DEV"
}

We can display the details of the database creation job again to see that it completed successfully within 20 minutes.

[root@odax8a ContentsXML]# odacli describe-job -i c2cbce12-82bd-41a1-ae5d-86dd363ce5b6

Job details                                                      
----------------------------------------------------------------
                     ID:  c2cbce12-82bd-41a1-ae5d-86dd363ce5b6
            Description:  Database service creation with db name: DEV
                 Status:  Success
                Created:  May 24, 2021 7:22:01 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance               May 24, 2021 7:22:02 PM CDT         May 24, 2021 7:22:02 PM CDT         Success   
Database Service creation                May 24, 2021 7:22:04 PM CDT         May 24, 2021 7:41:20 PM CDT         Success   
Database Creation                        May 24, 2021 7:22:04 PM CDT         May 24, 2021 7:37:59 PM CDT         Success   
Change permission for xdb wallet files   May 24, 2021 7:37:59 PM CDT         May 24, 2021 7:37:59 PM CDT         Success   
Add Startup Trigger to Open all PDBS     May 24, 2021 7:37:59 PM CDT         May 24, 2021 7:38:00 PM CDT         Success   
SqlPatch upgrade                         May 24, 2021 7:39:21 PM CDT         May 24, 2021 7:39:59 PM CDT         Success   
Running dbms_stats init_package          May 24, 2021 7:39:59 PM CDT         May 24, 2021 7:40:01 PM CDT         Success   
updating the Database version            May 24, 2021 7:40:02 PM CDT         May 24, 2021 7:40:04 PM CDT         Success   
Set CPU pool                             May 24, 2021 7:40:04 PM CDT         May 24, 2021 7:40:04 PM CDT         Success   
create Users tablespace                  May 24, 2021 7:41:20 PM CDT         May 24, 2021 7:41:24 PM CDT         Success   
Clear all listeners from Database {203ee5ff-53ed-41aa-bb3e-b8a4fa5d0681} May 24, 2021 7:41:24 PM CDT         May 24, 2021 7:41:25 PM CDT         Success

We can login to our DEV container database and see that the pluggable database called pdb1 is open in read-write mode:

[oracle@odax8a ~]$ . oraenv
ORACLE_SID = [DEV] ? DEV1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@odax8a ~]$ 
[oracle@odax8a ~]$ 
[oracle@odax8a ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 24 19:46:56 2021
Version 19.9.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0

SQL> 
SQL> 
SQL> show pdbs       

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO



In our example above, we created a RAC database. We can create a single instance database on the ODA as well. Here is an example ODACLI command to create a single instance database that is not containerized:

[root@odax8a ~]# odacli create-database -n oraqa -cl oltp -dh d5003afa-ba43-4453-add6-67444ed83d9d -s odb1 -r ACFS -y SI -g 1 

Enter SYS, SYSTEM and PDB Admin user password:
Retype SYS, SYSTEM and PDB Admin user password:

The “-g 1” specifics that we want the single instance database to run on the second node. If we specified “-g 0”, the database will run on the first node of the ODA.

Job details                                                      
----------------------------------------------------------------
                     ID:  fded47a6-1115-499e-90ee-5d01d7c4d182
            Description:  Database service creation with db name: oraqa
                 Status:  Created
                Created:  May 25, 2021 4:47:41 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------

[root@odax8a ~]# odacli describe-job -i fded47a6-1115-499e-90ee-5d01d7c4d182

Job details                                                      
----------------------------------------------------------------
                     ID:  fded47a6-1115-499e-90ee-5d01d7c4d182
            Description:  Database service creation with db name: oraqa
                 Status:  Success
                Created:  May 25, 2021 4:47:41 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Setting up ssh equivalance               May 25, 2021 4:47:47 PM CDT         May 25, 2021 4:47:47 PM CDT         Success   
Creating volume dcloraqa                 May 25, 2021 4:47:47 PM CDT         May 25, 2021 4:48:06 PM CDT         Success   
Creating volume datoraqa                 May 25, 2021 4:48:06 PM CDT         May 25, 2021 4:48:24 PM CDT         Success   
Creating volume rdooraqa                 May 25, 2021 4:48:24 PM CDT         May 25, 2021 4:48:43 PM CDT         Success   
Creating ACFS filesystem for DATA        May 25, 2021 4:48:43 PM CDT         May 25, 2021 4:49:03 PM CDT         Success   
Creating ACFS filesystem for FLASH       May 25, 2021 4:49:03 PM CDT         May 25, 2021 4:49:19 PM CDT         Success   
Database Service creation                May 25, 2021 4:49:21 PM CDT         May 25, 2021 5:00:12 PM CDT         Success   
Database Creation                        May 25, 2021 4:49:21 PM CDT         May 25, 2021 4:57:29 PM CDT         Success   
Change permission for xdb wallet files   May 25, 2021 4:57:29 PM CDT         May 25, 2021 4:57:29 PM CDT         Success   
Place SnapshotCtrlFile in sharedLoc      May 25, 2021 4:57:29 PM CDT         May 25, 2021 4:57:32 PM CDT         Success   
SqlPatch upgrade                         May 25, 2021 4:58:52 PM CDT         May 25, 2021 4:59:14 PM CDT         Success   
Running dbms_stats init_package          May 25, 2021 4:59:14 PM CDT         May 25, 2021 4:59:17 PM CDT         Success   
updating the Database version            May 25, 2021 4:59:17 PM CDT         May 25, 2021 4:59:20 PM CDT         Success   
Set CPU pool                             May 25, 2021 4:59:20 PM CDT         May 25, 2021 4:59:20 PM CDT         Success   
create Users tablespace                  May 25, 2021 5:00:12 PM CDT         May 25, 2021 5:00:15 PM CDT         Success   
Clear all listeners from Databse {fec53e5d-85f3-4481-badf-84ae113a796d} May 25, 2021 5:00:15 PM CDT         May 25, 2021 5:00:16 PM CDT         Success   
Copy Pwfile to Shared Storage            May 25, 2021 5:00:18 PM CDT         May 25, 2021 5:00:20 PM CDT         Success 

To create a containerized database, we add the -c option, and also specify the name for the PDB with the -p option:

[root@odax8a ~]# odacli create-database -n oraprod -cl oltp -dh d5003afa-ba43-4453-add6-67444ed83d9d -s odb1 -r ACFS -y SI -g 0 -c -p pdb

Enter SYS, SYSTEM and PDB Admin user password:
Retype SYS, SYSTEM and PDB Admin user password:

Job details                                                      
----------------------------------------------------------------
                     ID:  3ff6bf06-af2a-4f28-a3d5-9be8aced3451
            Description:  Database service creation with db name: oraprod
                 Status:  Created
                Created:  May 25, 2021 8:18:58 PM CDT
                Message:  

Task Name                                Start Time                          End Time                            Status    
---------------------------------------- ----------------------------------- ----------------------------------- ----------