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

Oracle 12.2 DBCA 使用 Silent 建库

6ee5639a40442445944d63b514b2dd02.png

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

操作很简单.

By eygle on 2019-01-16 21:16 |

Comments (0) |

Oracle12c/11g | 3329 |

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值