Create database via 19c dbca ...
[oracle@ora2 ~]$ hostname
ora2
check below first !!
export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/dell/srvadmin/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/u01/app/oracle/product/19.0.0/dbhome_3/bin
check this
which dbca
/u01/app/oracle/product/19.0.0/dbhome_3/bin/dbca
dbca -silent -nodelist 'ora2,ora3' -createDatabase -responseFile NO_VALUE -gdbName ORCLX -templateName General_Purpose.dbc -characterSet AL32UTF8 -datafileDestination '+DATA' -sid ORCLX -redoLogFileSize 50 -systemPassword welcome1 -sysPassword welcome1 -enableArchive true -createAsContainerDatabase true -pdbName UTIL01 -numberOfPDBs 1 -useLocalUndoForPDBs true -pdbAdminPassword welcome1 -recoveryAreaDestination '+DATA' -recoveryAreaSize 8024 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet AL16UTF16 -databaseConfigType RAC -automaticMemoryManagement false -initParams SGA_TARGET='5000M' PGA_AGGREGATE_TARGET='200M'
[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.
[WARNING] [DBT-06208] The 'PDBADMIN' 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-06801] Specified Fast Recovery Area size (8,024 MB) is less than the recommended value.
CAUSE: Fast Recovery Area size should at least be three times the database size (3,328 MB).
ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
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/ORCLX.
Database Information:
Global Database Name:ORCLX
System Identifier(SID) Prefix:ORCLX
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCLX/ORCLX.log" for further details.
INSTANCE_NUMBER.............................................: 1
INSTANCE_NAME...............................................: ORCLX1
HOST_NAME...................................................: ora2
VERSION.....................................................: 19.0.0.0.0
STARTUP_TIME................................................: 31-08-2024 08:48:58
STATUS......................................................: OPEN
PARALLEL....................................................: YES
THREAD#.....................................................: 1
ARCHIVER....................................................: STARTED
LOG_SWITCH_WAIT.............................................:
LOGINS......................................................: ALLOWED
SHUTDOWN_PENDING............................................: NO
DATABASE_STATUS.............................................: ACTIVE
INSTANCE_ROLE...............................................: PRIMARY_INSTANCE
ACTIVE_STATE................................................: NORMAL
BLOCKED.....................................................: NO
INSTANCE_NUMBER.............................................: 2
INSTANCE_NAME...............................................: ORCLX2
HOST_NAME...................................................: ora3
VERSION.....................................................: 19.0.0.0.0
STARTUP_TIME................................................: 31-08-2024 08:48:59
STATUS......................................................: OPEN
PARALLEL....................................................: YES
THREAD#.....................................................: 2
ARCHIVER....................................................: STARTED
LOG_SWITCH_WAIT.............................................:
LOGINS......................................................: ALLOWED
SHUTDOWN_PENDING............................................: NO
DATABASE_STATUS.............................................: ACTIVE
INSTANCE_ROLE...............................................: PRIMARY_INSTANCE
ACTIVE_STATE................................................: NORMAL
BLOCKED.....................................................: NO
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 5008M
sga_min_size big integer 0
sga_target big integer 5008M
unified_audit_sga_queue_size integer 1048576
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 UTIL01 READ WRITE NO
====
another example !!
[oracle@oragrid product]$ /u01/app/oracle/product/19.0.0/dbhome1/bin/dbca -CreateDatabase -silent -gdbName v15mpc -sid v15mpc -sysPassword sys -systemPassword sys -createAsContainerDatabase true -numberofPDBs 1 -pdbname v15mpcpdb -pdbAdminUserName pdba -pdbAdminPassword password -emConfiguration LOCAL -dbsnmpPassword dbsnmp123 -storageType ASM -datafiledestination +DATA -recoveryAreaDestination +DATA -databaseType MULTIPURPOSE -responseFile NO_VALUE -totalmemory 6096 -characterset AL32UTF8 -nationalcharacterset AL16UTF16 -automaticmemorymanagement FALSE -templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[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.
[WARNING] [DBT-06208] The 'PDBADMIN' 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
7% complete
Registering database with Oracle Restart
11% complete
Copying database files
33% complete
Creating and starting Oracle instance
35% complete
38% complete
42% complete
45% complete
48% complete
Completing Database Creation
53% complete
55% complete
56% complete
Creating Pluggable Databases
60% complete
78% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/v15mpc.
Database Information:
Global Database Name:v15mpc
System Identifier(SID):v15mpc
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/v15mpc/v15mpc0.log" for further details.
[oracle@oragrid product]$ ps -ef|grep -i smon
grid 4750 1 0 10:10 ? 00:00:00 asm_smon_+ASM
oracle 13673 1 0 11:25 ? 00:00:00 ora_smon_v15mpc
oracle 14138 4814 0 11:30 pts/1 00:00:00 grep --color=auto -i smon
