oracle RAC 静默创建rdbms instance之-Exception in thread "main"

来源：互联网发布：mac自带的五笔输入法编辑：程序博客网时间：2024/06/06 05:47

在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的大小设置问题，修改后问题解决