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

Write a Reply or Comment

Your email address will not be published.