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
With this option, it was working up to version 23.7. Patch 23.8 introduces additional protection, and it no longer starts.
Hi Alex, this method works on version 23.07, but no longer works with 23.08. The Software installation and patch work ok. The dbca refuses to continue…. Creating and starting Oracle instance 7% complete [WARNING] ORA-27350: This version of the Oracle Database software cannot be run on this platform [FATAL] ORA-01034: The Oracle instance is not available for use. Start the instance. Have you tried 23.08 yet?