正德厚生,臻于至善

Oracle 23ai: How to create DB in silent mode

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.
赞(0) 打赏
未经允许不得转载:徐万新之路 » Oracle 23ai: How to create DB in silent mode

支持快讯、专题、百度收录推送、人机验证、多级分类筛选器,适用于垂直站点、科技博客、个人站,扁平化设计、简洁白色、超多功能配置、会员中心、直达链接、文章图片弹窗、自动缩略图等...

联系我们

觉得文章有用就打赏一下文章作者

非常感谢你的打赏,我们将继续提供更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫

微信扫一扫

登录

找回密码

注册