addnode 在做dbca 建实例启动时报错

wengtf

env：
11.2.0.1 rac on liunx 64bit
1.dbca 最后的结果如图：


2.手动启动数据库出现上次 我电话给你之时的错误：

--对于2，检查 $ORACLE_HOME/bin/oracle 和 $GRID_HOME/bin/oracle 权限均为：


没思路了，居然还看到过这个，虚了 BUG9729692

Maclean Liu(刘相兵

ASM 的alert.log ， 图2没必要截图 多此一举 ， 我不喜欢乱截图

wengtf

asmlog 马上传，前面我没说明白，抱歉，之前在asm下面 3个dg（图2可以理解了） :
crs (MOUNT)
FRA (NO MOUNT)
RACDATA (NOMOUNT)
现在不知道原因为嘛+asm3 实例起来（手动启动）了后面2个dg 没mount上。

wengtf

alert_+ASM3.LOG

wengtf

- -,sorry，传错了

Maclean Liu(刘相兵

SUCCESS: ALTER DISKGROUP FRA MOUNT  /* asm agent */
NOTE: Assigning number (3,0) to disk (/dev/oracleasm/disks/RACDATA1)
NOTE: Assigning number (3,2) to disk (/dev/oracleasm/disks/RACDATA3)
NOTE: Assigning number (3,1) to disk (/dev/oracleasm/disks/RACDATA2)
kfdp_query(RACDATA): 16
kfdp_queryBg(): 16
NOTE: cache opening disk 0 of grp 3: RACDATA_0000 path:/dev/oracleasm/disks/RACDATA1
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 3: RACDATA_0001 path:/dev/oracleasm/disks/RACDATA2
NOTE: cache opening disk 2 of grp 3: RACDATA_0002 path:/dev/oracleasm/disks/RACDATA3
NOTE: cache mounting (not first) external redundancy group 3/0x27E874B4 (RACDATA)
kjbdomatt send to inst 1
kjbdomatt send to inst 2
NOTE: attached to recovery domain 3
NOTE: LGWR attempting to mount thread 3 for diskgroup 3 (RACDATA)
NOTE: LGWR found thread 3 closed at ABA 2.1
NOTE: LGWR mounted thread 3 for diskgroup 3 (RACDATA)
NOTE: LGWR opening thread 3 at fcn 0.35317 ABA 3.2
NOTE: cache mounting group 3/0x27E874B4 (RACDATA) succeeded
NOTE: cache ending mount (success) of group RACDATA number=3 incarn=0x27e874b4
kfdp_query(RACDATA): 17
kfdp_queryBg(): 17
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup RACDATA was mounted
SUCCESS: ALTER DISKGROUP RACDATA MOUNT  /* asm agent */
NOTE: diskgroup resource ora.RACDATA.dg is online
Sun Jun 16 17:27:10 2013
SQL> ALTER DISKGROUP RACDATA DISMOUNT  /* asm agent */
Sun Jun 16 17:27:10 2013
NOTE: ASM client orcl3:orcl disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Process state recorded in trace file /opt/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_ora_19148.trc
NOTE: cache dismounting (clean) group 3/0x27E874B4 (RACDATA)
Sun Jun 16 17:27:10 2013
NOTE: LGWR doing clean dismount of group 3 (RACDATA)
NOTE: LGWR closing thread 3 of diskgroup 3 (RACDATA) at ABA 3.4
NOTE: LGWR released thread recovery enqueue
Sun Jun 16 17:27:10 2013
kjbdomdet send to inst 1
detach from dom 3, sending detach message to inst 1
kjbdomdet send to inst 2
detach from dom 3, sending detach message to inst 2
Sun Jun 16 17:27:10 2013
NOTE: detached from domain 3
NOTE: cache dismounted group 3/0x27E874B4 (RACDATA)
kfdp_dismount(): 18
Sun Jun 16 17:27:10 2013
kfdp_dismountBg(): 18
NOTE: De-assigning number (3,0) from disk (/dev/oracleasm/disks/RACDATA1)
NOTE: De-assigning number (3,1) from disk (/dev/oracleasm/disks/RACDATA2)
NOTE: De-assigning number (3,2) from disk (/dev/oracleasm/disks/RACDATA3)
SUCCESS: diskgroup RACDATA was dismounted

Maclean Liu(刘相兵

上传 /opt/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_ora_19148.trc

和 orcl3 的alert.log

wengtf

现在racdata 好fra 已经mount上了，启实例还是 ora-01105 和ora-01606

wengtf

node 3  orcl3 instance alert log

Maclean Liu(刘相兵

没有看到 /opt/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_ora_19148.trc

Maclean Liu(刘相兵

startup nomount pfile='/opt/app/oracle/product/11.2.0/dbs/initorcl3.ora';

并给出对应的新生成的alert.log内容

请你调整下心态再提问，这样的提问 没有什么效率

wengtf

如果有一天能有ml这样的心态，我也终将成为大拿了，嘿嘿！

附件最新的日志，请查收，有劳。

Maclean Liu(刘相兵

id oracle
id grid

ls -l $GRID_HOME/bin/oracle
ls -l $GRID_HOME/bin/oradism

ls -l $ORACLE_HOME/bin/oracle
ls -l $ORACLE_HOME/bin/oradism

wengtf

这几个权限问题老早跟你第一次确认的时候就已经排除了。

553722769

学习了解

wengtf

抱歉，周末才能尝试重启集群，停止集群后，先启动节点3（new node）正常，1和2无法启动，反过来1和2 能启动，3就无法启动，报错依然为 ora-01606

wengtf

该问题已解决、确系文章 bug 所为，OS调整cpu core线程数后排除。