CentOS7.6静默安装19C实例脚本 ORA-27125[FATAL] [DBT-10322]

概述脚本： dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname test -sid test -characte

脚本：

dbca -silent -createDatabase -templatename General_Purpose.dbc -gdbname test -sID test -characterSet AL32UTF8 -TOTALMEMORY 4096 -STORAGETYPE FS -DATAfileDESTINATION /oracle/oradata/tbomtest/ -sysPassword oracle -systemPassword oracle

 

--------------------------------------------------------------------------需要注意的是19c的实例名不能添加"_"下划线，要不然会报错

上边脚本实例名跟下边实 *** 的实例名不是一个！

Alphanumeric characters:字母数字字符来自有道翻译，下面的报错就是我实例名加上下划线，去掉下划线就可以正常运行了

[oracle@tldbompx03 ~]$ dbca -silent -createDatabase -templatename General_Purpose.dbc -gdbname tbom_px -sID tbom_px -characterSet AL32UTF8 -TOTALMEMORY 4096 -STORAGETYPE FS -DATAfileDESTINATION /oracle/oradata/tbom_px/ -sysPassword oracle -systemPassword oracle
[FATAL] [DBT-10322] The Instance name specifIEd contains non Alphanumeric characters.
ACTION: Specify a Instance name that starts with an Alphabet and contains only Alphanumeric characters.

[oracle@tldbompx03 ~]$ dbca -silent -createDatabase -templatename General_Purpose.dbc -gdbname tbom_px -sID tbom_px -characterSet AL32UTF8 -TOTALMEMORY 4096 -STORAGETYPE FS -DATAfileDESTINATION /oracle/oradata/tbompx/ -sysPassword oracle -systemPassword oracle
[FATAL] [DBT-10322] The Instance name specifIEd contains non Alphanumeric characters.
ACTION: Specify a Instance name that starts with an Alphabet and contains only Alphanumeric characters.

 

这里ORA-27125 - Unable to create shared memory segment error 共享内存段错误，一般调整/etc/sysctl.conf中的最大共享内存kernel.shmmax、kernel.shmmni就可以，sysctl -p使参数生效

 

 

没有分配kernel.shmmax、kernel.shmmni内存创建实例失败

[ 2020-06-11 17:35:45.945 CST ] [WARNING] [DBT-11207] SpecifIEd SGA size is greater than the shmmax on the system. The database creation might fail with "ORA-27125 - Unable to create shared memory segment error".[ 45.974 CST ] [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.[ SYstem47.290 CST ] Prepare for db operationDBCA_PROGRESS : 10%[ 47.370 CST ] copying database filesDBCA_PROGRESS : 12%48.890 CST ] [WARNING] ORA-27125: unable to create shared memory segment[ 48.892 CST ] [FATAL] ORA-01034: ORACLE not availableDBCA_PROGRESS : 40%DBCA_PROGRESS : 100%48.897 CST ] [FATAL] ORA-0%

 

重新分配内存

shmall 是全部允许使用的共享内存大小，shmmax 是单个段允许使用的大小。这两个可以设置为内存的 80%

kernel.shmmax=例如 24G 内存，24*1024*1024*1024*80% = 20615843021
kernel.shmall=kernel.shmmax(20615843021)/4k=5033165

 

 

[oracle@tldbompx03 ~]$ dbca -silent -createDatabase -templatename General_Purpose.dbc -gdbname tbompx -sID tbompx -characterSet AL32UTF8 -TOTALMEMORY 8096 -STORAGETYPE FS -DATAfileDESTINATION /oracle/oradata/tbompx/ -sysPassword oracle -systemPassword oracle[WARNING] [DBT-.   ACTION: Specify SGA size lesser than or equal to the shmmax on the system.[WARNING] [DBT- 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 kepxord that Oracle does not recommend to be used as password   ACTION: Specify a strong password. If required refer Oracle documentation  guIDelines.[WARNING] [DBT- guIDelines.Prepare  db operation completecopying database files completeCreating and starting Oracle instance42% complete46%50%54%60% completeCompleting Database Creation66%69%70% completeExecuting Post Configuration Actions completeDatabase creation complete. For details check the logfiles at: /oracle/cfgtoollogs/dbca/tbompx.Database information:Global Database name:tbompxSystem IDentifIEr(SID):tbompxLook at the log file /oracle/cfgtoollogs/dbca/tbompx/tbompx1.log" for further details.

 

 

调整之后

总结

以上是内存溢出为你收集整理的CentOS7.6静默安装19C实例脚本 ORA-27125 [FATAL] [DBT-10322]全部内容，希望文章能够帮你解决CentOS7.6静默安装19C实例脚本 ORA-27125 [FATAL] [DBT-10322]所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。