在rac环境中执行dbca单独静默删除、创建RDBMS instance,
1)删除
dbca -silent -nodelist pt1bakdb1,pt1bakdb2 -deleteDatabase -sourceDB zxin -sid zxin -sysDBAUserName sys -sysDBAPassword change_on_install
Connecting to database
4% complete
14% complete
19% complete
23% complete
28% complete
33% complete
38% complete
42% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instances and datafiles
66% complete
80% complete
95% complete
100% complete
Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/zxin1.log" for further details.
成功
创建的时候报错:
$dbca -silent -nodelist pt1bakdb1,pt1bakdb2 -characterSet ZHS16GBK -createdatabase -responseFile createdb.rsp
Exception in thread "main"
查看日志:
#tail -n 200 /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/trace.log
......
[main] [17:0:44:843] [MemoryCalculator.calculateMemory:122] Setting SGA to MAX_SGA 1610612736
java.lang.NumberFormatException: For input string: "2147483648"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
....
查看dbca template:zxin.bat,原来是redo log的大小设置问题,修改后问题解决