Tested version.
[oracle@ol7-19-lax1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)
OPatch succeeded.
[oracle@ol7-19-lax1 ~]$
Create database using dbca silent.
--- Set environment variables to be used by dbca.
export ORACLE_UNQNAME=owl
export PDB_NAME=mice
export NODE1=ol7-19-lax1
export NODE2=ol7-19-lax2
export SYS_PASSWORD=Oracle_4U
export PDB_PASSWORD=Oracle_4U
Note: -gdbName global_database_name (-gdbname oradb.example.com)
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname ${ORACLE_UNQNAME} -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword ${SYS_PASSWORD} \
-systemPassword ${SYS_PASSWORD} \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName ${PDB_NAME} \
-pdbAdminPassword ${PDB_PASSWORD} \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1024 \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs \
-nodelist ${NODE1},${NODE2} \
-storageType ASM \
-diskGroupName +DATA \
-recoveryGroupName +RECO \
-useOMF true \
-asmsnmpPassword ${SYS_PASSWORD}
[oracle@ol7-19-lax1 ~]$ dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -gdbname ${ORACLE_UNQNAME} -responseFile NO_VALUE \
> -characterSet AL32UTF8 \
> -sysPassword ${SYS_PASSWORD} \
> -systemPassword ${SYS_PASSWORD} \
> -createAsContainerDatabase true \
> -numberOfPDBs 1 \
> -pdbName ${PDB_NAME} \
> -pdbAdminPassword ${PDB_PASSWORD} \
> -databaseType MULTIPURPOSE \
> -automaticMemoryManagement false \
> -totalMemory 1024 \
> -redoLogFileSize 50 \
> -emConfiguration NONE \
> -ignorePreReqs \
> -nodelist ${NODE1},${NODE2} \
> -storageType ASM \
> -diskGroupName +DATA \
> -recoveryGroupName +RECO \
> -useOMF true \
> -asmsnmpPassword ${SYS_PASSWORD}
Prepare for db operation
7% complete
Copying database files
27% complete
Creating and starting Oracle instance
28% complete
31% complete
35% complete
37% complete
40% complete
Creating cluster database views
41% complete
53% complete
Completing Database Creation
57% complete
59% complete
60% complete
Creating Pluggable Databases
64% complete
80% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/owl.
Database Information:
Global Database Name:owl
System Identifier(SID) Prefix:owl
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/owl/owl.log" for further details.
[oracle@ol7-19-lax1 ~]$
Log files are located at ORACLE_BASE/cfgtoollogs/dbca/${ORACLE_UNQNAME}
[oracle@ol7-19-lax1 ~]$ cd $ORACLE_BASE/cfgtoollogs/dbca/${ORACLE_UNQNAME}
[oracle@ol7-19-lax1 owl]$ pwd
/u01/app/oracle/cfgtoollogs/dbca/owl
[oracle@ol7-19-lax1 owl]$ ls -l
total 23576
-rw-r-----. 1 oracle oinstall 10422 Jun 8 21:20 catclust0.log
-rw-------. 1 oracle oinstall 201621 Jun 8 21:20 catclust_catcon_31776.lst
-rw-r-----. 1 oracle oinstall 2450 Jun 8 21:14 cloneDBCreation.log
-rw-r-----. 1 oracle oinstall 380 Jun 8 20:57 CloneRmanRestore.log
-rw-r-----. 1 oracle oinstall 44272 Jun 8 21:20 CreateClustDBViews.log
-rw-r-----. 1 oracle oinstall 1711 Jun 8 21:49 DBDetails.log
-rw-r-----. 1 oracle oinstall 9948 Jun 8 21:19 execemx0.log
-rw-------. 1 oracle oinstall 200759 Jun 8 21:19 execemx_catcon_31544.lst
-rw-r-----. 1 oracle oinstall 910 Jun 8 21:20 lockAccount.log
-rw-r-----. 1 oracle oinstall 9560 Jun 8 21:18 ordlib0.log
-rw-------. 1 oracle oinstall 200561 Jun 8 21:18 ordlib_catcon_31269.lst
-rw-r-----. 1 oracle oinstall 796 Jun 8 21:51 owl0.log
-rw-r-----. 1 oracle oinstall 952 Jun 8 21:34 owl.log
-rw-r-----. 1 oracle oinstall 0 Jun 8 21:33 PDBCreation.log
-rw-r-----. 1 oracle oinstall 28 Jun 8 21:34 plugDatabase1R.log
-rw-r-----. 1 oracle oinstall 4105 Jun 8 21:18 plugDatabase.log
-rw-r-----. 1 oracle oinstall 46082 Jun 8 21:33 postDBCreation.log
-rw-r-----. 1 oracle oinstall 24 Jun 8 21:34 postPDBCreation.log
-rw-r-----. 1 oracle oinstall 88296 Jun 8 21:19 postScripts.log
-rw-r-----. 1 oracle oinstall 0 Jun 8 21:50 rmanUtil
-rw-r-----. 1 oracle oinstall 1479 Jun 8 21:49 ShutdownInst.log
-rw-r-----. 1 oracle oinstall 18726912 Jun 8 20:57 tempControl.ctl
-rw-r-----. 1 oracle oinstall 2670547 Jun 8 21:34 trace.log_2021-06-08_08-55-55PM
-rw-r-----. 1 oracle oinstall 1649779 Jun 8 21:51 trace.log_2021-06-08_09-49-34PM
-rw-r-----. 1 oracle oinstall 15420 Jun 8 21:32 utlrp0.log
-rw-------. 1 oracle oinstall 200463 Jun 8 21:32 utlrp_catcon_3004.lst
[oracle@ol7-19-lax1 owl]$
Here is the created database.
[oracle@ol7-19-lax1 owl]$ srvctl config database -d owl
Database unique name: owl
Database name: owl
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/OWL/PARAMETERFILE/spfile.311.1074720717
Password file: +DATA/OWL/PASSWORD/pwdowl.298.1074718605
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: owl1,owl2
Configured nodes: ol7-19-lax1,ol7-19-lax2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@ol7-19-lax1 owl]$ srvctl status database -d owl
Instance owl1 is running on node ol7-19-lax1
Instance owl2 is running on node ol7-19-lax2
--- Newly created database was not added to oratab.
[oracle@ol7-19-lax1 owl]$ cat /etc/oratab
#Backup file is /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/oratab.bak.ol7-19-lax1.oracle line added by Agent
+ASM1:/u01/app/19.0.0/grid:N
hawk1:/u01/app/oracle/product/19.0.0/dbhome_1:N
[oracle@ol7-19-lax1 owl]$ Delete database using dbca silent.
dbca -silent -deleteDatabase -sourceDB ${ORACLE_UNQNAME} -sysDBAUserName sys -sysDBAPassword ${SYS_PASSWORD}
[oracle@ol7-19-lax1 ~]$ dbca -silent -deleteDatabase -sourceDB ${ORACLE_UNQNAME} -sysDBAUserName sys -
sysDBAPassword ${SYS_PASSWORD}
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
39% complete
42% complete
45% complete
48% complete
52% complete
55% complete
58% complete
65% complete
Updating network configuration files
68% complete
Deleting instances and datafiles
77% complete
87% complete
97% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/owl/owl0.log" for further details.
[oracle@ol7-19-lax1 ~]$
Thinking Out Loud 