On this activity we are going to create a DB in silent mode.
We don’t have GI on this environment and since software has been only released for Engineered Systems, we need to create with “_exadata_feature_on=true”
[oracle@ol8_23ai ~]$ cd /u01/app/oracle/product/23ai/db_home1/bin
[oracle@ol8_23ai bin]$ ./dbca \
-ignorePreReqs \
-ignorePrereqFailure \
-silent \
-createDatabase \
-templateName General_Purpose.dbc \
-sid dbtest23 \
-gdbName dbtest23 \
-SysPassword syspassword \
-SystemPassword systempassword \
-storageType FS \
-datafileDestination /u02/database \
-archiveLogDest /u02/database/DBTEST23/archivelog \
-enableArchive true \
-numberOfPDBs 1 \
-pdbAdminPassword pdbadmin \
-pdbName dbtest23pdb1 \
-initParams db_unique_name=dbtest23,sga_max_size=1500M,sga_target=1500M,pga_aggregate_target=200M,_exadata_feature_on=true
[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
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
39% complete
42% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/dbtest23.
Database Information:
Global Database Name:dbtest23
System Identifier(SID):dbtest23
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/dbtest23/dbtest235.log" for further details.
[oracle@ol8_23ai bin]$
DB created:
INST HOST INST_NAME STATUS DB_ROLE OPEN_MODE STARTUP_TIME
---- ------------------ ---------- ---------- ----------------- --------------------- --------------------
*1 ol8_23ai dbtest23 OPEN PRIMARY READ WRITE 11-SEP-2024 18:29:16
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DBTEST23PDB1 READ WRITE NO
SQL>
Note that on 23ai, you are forced to have PDB’s. There might be some trick to be a non-cdb, but did not find it yet. Will provide how to do it if I find it.
Comments