oracle12的dbca,Oracle 12.2 DBCA 使用 Silent 建库

许久没有用 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

操作很简单.