脚本：
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". [ 2020-06-11 17:35:45.974 CST ] [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. [ 2020-06-11 17:35:45.974 CST ] [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. [ 2020-06-11 17:35:47.290 CST ] Prepare for db operation DBCA_PROGRESS : 10% [ 2020-06-11 17:35:47.370 CST ] Copying database files DBCA_PROGRESS : 12% [ 2020-06-11 17:35:48.890 CST ] [WARNING] ORA-27125: unable to create shared memory segment [ 2020-06-11 17:35:48.892 CST ] [FATAL] ORA-01034: ORACLE not available DBCA_PROGRESS : 40% DBCA_PROGRESS : 100% [ 2020-06-11 17:35:48.897 CST ] [FATAL] ORA-01034: ORACLE not available DBCA_PROGRESS : 10% DBCA_PROGRESS : 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-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". ACTION: Specify SGA size lesser than or equal to the shmmax on the system. [WARNING] [DBT-06208] The 'SYS' 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 for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' 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 for guidelines. Prepare for db operation 10% complete Copying database files 40% complete Creating and starting Oracle instance 42% complete 46% complete 50% complete 54% complete 60% complete Completing Database Creation 66% complete 69% complete 70% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /oracle/cfgtoollogs/dbca/tbompx. Database Information: Global Database Name:tbompx System Identifier(SID):tbompx Look at the log file "/oracle/cfgtoollogs/dbca/tbompx/tbompx1.log" for further details.
调整之后