create 19c database
for file system
-storageType FS
-datafileDestination /u01/db_files
select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
export Oracle home and sid
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ${ORACLE_SID} -sid ${ORACLE_SID} -characterSet AL32UTF8 -sysPassword xxxxx -systemPassword xxxxx -createAsContainerDatabase false -totalMemory 6000 -storageType ASM -datafileDestination '+DATA' -emConfiguration NONE -ignorePreReqs -sampleSchema true
for RAC
./dbca -silent -nodelist ora1,ora2 -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -sid ORCL -SysPassword test123 -SystemPassword test123 -emConfiguration none -redoLogFileSize 1024 -recoveryAreaDestination '+DATA1' -storageType ASM -asmsnmpPassword welcome1 -diskGroupName '+DATA1' -recoveryGroupName '+DATA1' -listeners LISTENER -registerWithDirService false -characterSet WE8ISO8859P9 -nationalCharacterSet AL16UTF16 -databaseType MULTIPURPOSE -automaticMemoryManagement true -totalMemory 60480 -sampleSchema true &
====
another db creation
https://anuj-singh.blogspot.com/search?q=General_Purpose.dbc
which dbca
/u01/app/oracle/product/19.0.0/dbhome1/bin/dbca
[oracle@oragrid ~]$ ls -ltr /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
-rw-r----- 1 oracle oinstall 4768 Apr 17 2019 /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[oracle@oragrid ~]$
/u01/app/oracle/product/19.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
-gdbName v14mpc \
-sid v14mpc \
-sysPassword sys \
-systemPassword sys \
-createAsContainerDatabase true \
-numberofPDBs 1 \
-pdbname v14mpcpdb \
-pdbAdminUserName pdba \
-pdbAdminPassword password \
-emConfiguration LOCAL \
-dbsnmpPassword dbsnmp123 \
-storageType ASM \
-datafiledestination +DATA \
-recoveryAreaDestination +DATA \
-databaseType MULTIPURPOSE \
-responseFile NO_VALUE \
-totalmemory 4096 \
-characterset AL32UTF8 \
-nationalcharacterset AL16UTF16 \
-automaticmemorymanagement FALSE \
-templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[oracle@oragrid ~]$ /u01/app/oracle/product/19.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v14mpc \
> -sid v14mpc \
> -sysPassword sys \
> -systemPassword sys \
> -createAsContainerDatabase true \
> -numberofPDBs 1 \
> -pdbname v14mpcpdb \
> -pdbAdminUserName pdba \
> -pdbAdminPassword password \
> -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 \
> -storageType ASM \
> -datafiledestination +DATA \
> -recoveryAreaDestination +DATA \
> -databaseType MULTIPURPOSE \
> -responseFile NO_VALUE \
> -totalmemory 4096 \
> -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/v14mpc.
Database Information:
Global Database Name:v14mpc
System Identifier(SID):v14mpc
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/v14mpc/v14mpc0.log" for further details.
