[ORACLE] 19c DBCA Silent mode command

내가 자주 써먹으려고 찌는 dbca command

$ORACLE_HOME/bin/dbca -createDatabase -silent -gdbName [GLOBAL_DB_NAME] -sid [ORACLE_SID] \
-sysPassword "SYSPASSWORD" -systemPassword "SYSPASSWORD" \
-databaseType MULTIPURPOSE  -responseFile NO_VALUE \
-dvConfiguration false  -olsConfiguration false \
-registerWithDirService false  -asmSysPassword "ASM SYSPASSWORD" \
-asmsnmpPassword "ASM SYSPASSWORD" -storageType ASM -diskGroupName +DATA \
-recoveryGroupName +FRA -nodelist [node1,node2] -databaseConfType RAC \
-ignorePreReqs  -templateName /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates/New_Database.dbt \
-runCVUChecks false -emConfiguration NONE

---> 내 환경에 적용

/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca -createDatabase -silent -gdbName EM19 -sid EM19 \
-sysPassword "welcome1" -systemPassword "welcome1" \
-databaseType MULTIPURPOSE  -responseFile NO_VALUE \
-dvConfiguration false  -olsConfiguration false \
-registerWithDirService false  -asmSysPassword "We1come$" \
-asmsnmpPassword "We1come$" -storageType ASM -diskGroupName +DATA \
-recoveryGroupName +FRA -nodelist em191,em192 -databaseConfType RAC \
-ignorePreReqs  -templateName /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates/New_Database.dbt \
-runCVUChecks false -emConfiguration NONE

 

log

[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
4% complete
Creating and starting Oracle instance
5% complete
6% complete
8% complete
Creating database files
9% complete
13% complete
Creating data dictionary views
14% complete
16% complete
17% complete
18% complete
20% complete
21% complete
23% complete
25% complete
Oracle JVM
31% complete
38% complete
44% complete
46% complete
Oracle Text
47% complete
49% complete
50% complete
Oracle Multimedia
63% complete
Oracle OLAP
64% complete
65% complete
66% complete
67% complete
Oracle Spatial
68% complete
75% complete
Creating cluster database views
76% complete
83% complete
Completing Database Creation
85% complete
87% complete
88% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/EM19.
Database Information:
Global Database Name:EM19
System Identifier(SID) Prefix:EM19
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/EM19/EM19.log" for further details.
[EM191]oracle@em191:/u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates# ps -ef | grep pmon
oracle    1930     1  0 11:32 ?        00:00:00 ora_pmon_EM191
grid      6409     1  0 09:59 ?        00:00:00 asm_pmon_+ASM3
oracle   32761 18827  0 13:15 pts/0    00:00:00 grep --color=auto pmon
[EM191]oracle@em191:/u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates# ps -ef | grep LISTENER
oracle     472 18827  0 13:15 pts/0    00:00:00 grep --color=auto LISTENER
grid      7435     1  0 09:59 ?        00:00:00 /u01/app/19c/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid      7449     1  0 09:59 ?        00:00:00 /u01/app/19c/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit
grid      7457     1  0 09:59 ?        00:00:00 /u01/app/19c/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit

[EM191]oracle@em191:/u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/templates# sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 19 13:15:42 2023
Version 19.17.0.0.0

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


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

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      EM19
SQL> show parameter global

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
allow_global_dblinks                 boolean     FALSE
global_names                         boolean     FALSE
global_txn_processes                 integer     1
SQL> show parameter unique

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      EM19