dbca -silent注意把握每个参数的含义
我这里建立的是non-pdb模式的12c rac数据库,使用已存在的asm实例
dbca -silent -createDatabase -templateName General_Purpose.dbc -createAsContainerDatabase false -initparams db_create_file_dest='+datadg' -initparams db_create_online_log_dest_1='+datadg' -initparams audit_trail=NONE -initparams processes=2000 -nodelist dbnode01,dbnode02,dbnode03,dbnode04 -databaseConfType rac -sysPassword xxx -systemPassword xxx -gdbname xsiop -sid xsiop -responseFile NO_VALUE -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -totalMemory 30720 -emConfiguration LOCAL -storageType ASM -diskGroupName DATADG -recoveryGroupName FRADG
Cleaning up failed steps
4% complete
Copying database files
5% complete
6% complete
7% complete
13% complete
19% complete
24% complete
30% complete
33% complete
Creating and starting Oracle instance
35% complete
39% complete
43% complete
46% complete
47% complete
48% complete
50% complete
52% complete
Creating cluster database views
54% complete
71% complete
Completing Database Creation
74% complete
77% complete
85% complete
94% complete
100% complete
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/xsiop/xsiop1.log" for further details.
如果报错注意观察日志
比如:
1.
-sysmanPassword is an invalid command line argument.
12c不支持此参数了(RAC: Frequently Asked Questions (RAC FAQ) (文档 ID 220970.1)有这个参数)
2.
Copying database files
DBCA_PROGRESS : 1%
ORA-00845: MEMORY_TARGET not supported on this system
DBCA_PROGRESS : 3%
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
MEMORY_TARGET不支持,去掉-automaticMemoryManagement true后可用继续安装
3.
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/oracle/app/oracle/oradata/xsiop/control01.ctl'
ORA-27040: file create error, unable to create file
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/oracle/app/oracle/oradata/xsiop/control01.ctl'
ORA-27040: file create error, unable to create file
DBCA_PROGRESS : DBCA Operation failed.
日志显示控制文件创建失败,居然创建在了文件系统上。
在dbca中写明-diskGroupName DATADG ,控制文件就会默认创建在DATADG中。
dbca命令可用通过-help查看
dbca -createDatabase -help
参考文档:
RAC: Frequently Asked Questions (RAC FAQ) (文档 ID 220970.1)