Oracle 12.2 DBCA 使用 Silent 建库

« Oracle Database 19c 的发布时间确定和升级建议 | Blog首页 | Oracle 比率：Redo Nowait Ratio 的计算方式 »

许久没有用 Silent 方式建库了，非常顺畅，建立一个 12.2 非多租户的数据库：

[oracle12c@iz2zeezinabu7k6olgelwez ~]$ dbca -silent -createDatabase \

> -templateName General_Purpose.dbc \

> -gdbname eygle -sid eygle -responseFile NO_VALUE \

> -characterSet AL32UTF8 \

> -sysPassword OraPasswd1 \

> -systemPassword OraPasswd1 \

> -createAsContainerDatabase false \

> -databaseType MULTIPURPOSE \

> -automaticMemoryManagement false \

> -totalMemory 1536 \

> -storageType FS \

> -datafileDestination "/u01/oracle12c/db/oradata/" \

> -redoLogFileSize 50 \

> -emConfiguration NONE \

> -ignorePreReqs

[WARNING] [DBT-11207] Specified SGA size is greater than the shmmax on the system. This might make database creation to fail with ORA-27125 - Unable to create shared memory segment error.

ACTION: Specify SGA size lesser than or equal to the shmmax on the system.

Copying database files

1% complete

2% complete

18% complete

33% complete

Creating and starting Oracle instance

35% complete

40% complete

44% complete

49% complete

50% complete

53% complete

55% complete

Completing Database Creation

56% complete

57% complete

58% complete

62% complete

65% complete

66% complete

Executing Post Configuration Actions

100% complete

Look at the log file "/u01/oracle12c/db/cfgtoollogs/dbca/eygle/eygle.log" for further details.

如果是多租户，增加几个参数，类似如下：

dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname cdb01 -sid cdb01 -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword OraPasswd1 \
-systemPassword OraPasswd1 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName pdb3 \
-pdbAdminPassword OraPasswd1 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1536 \
-storageType FS \
-datafileDestination "/u01/app/oracle/oradata/" \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs