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.

Last modified: 11 September 2024

Author

Comments

With this option, it was working up to version 23.7. Patch 23.8 introduces additional protection, and it no longer starts.

Andrew Lacy 

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?

Write a Reply or Comment

Your email address will not be published.