暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle 12.2 DBCA 使用 Silent 建库

原创 eygle 2019-01-16
1420

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


操作很简单.

最后修改时间:2020-06-11 14:05:25
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论