oracle rac增加节点报错三例

来源:互联网 发布:公司屏蔽了淘宝怎么办 编辑:程序博客网 时间:2024/05/29 19:12

问题一:增加节点进行检查时报错:

./runcluvfy.sh stage -pre nodeadd -n xxx -verbose
Checking CRS home location...
PRVG-1013 : The path "/testapptest/oragrid/11.2.0" does not exist or cannot be created on the nodes to be added
Result: Shared resources check for node addition failed
解决方法:
因为其它条件都符合,且这个path是存在正确的,设置以下环境变量后,直接进入加节点操作
export IGNORE_PREADDNODE_CHECKS=Y 

问题二:
在自动增加第三节点实例时,报下面错:
dbca -silent -addInstance -nodeList xxxx -gdbName ver -instanceName ver3 -sysDBAUserName sys -sysDBAPassword '密码'
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
解决方法:
检查修改数据文件的maxsize大小由unlimited改为具体值,或取消自动增长

问题三:
启动实例报错:srvctl start instance -d ver -i ver3
PRCR-1013 : Failed to start resource ora.ver.db
PRCR-1064 : Failed to start resource ora.ver.db on node miuu246
CRS-2640: Required resource 'ora.REDODG1.dg' is missing.
分析:原因为前面有手工drop了三个没有在用的asm磁盘组,而crs信息没有更新引起报错
解析:
查看crs依赖的磁盘组:
crsctl status res ora.ver.db -f
START_DEPENDENCIES=hard(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.testDG1.dg,shutdown:ora.testDG2.dg,shutdown:ora.REDODG1.dg,shutdown:ora.testDG3.dg,shutdown:ora.REDO01.dg,shutdown:ora.REDO02.dg,shutdown:ora.REDODG01.dg)
修改正确的磁盘组:
srvctl modify database -d ver -a "testDG1,testDG2,testDG3,REDODG01" 
原创粉丝点击