|
|---|
|
|
|
|
|
|
s*******9
发帖数: 5 | 1 在虚拟机里装了个RAC，发现个问题：
环境是这样的：
oracle virtual box 4.3.14
redhat linux enterprise edition 5.10
oracle rac and oracle clusterware 10.2.0.5.0
crs_stat -t
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
ora.orcl.db application ONLINE ONLINE node2
ora....l1.inst application ONLINE ONLINE node1
ora....l2.inst application ONLINE ONLINE node2
一切正常。
但是分别在两节点主机上运行sqlplus，查询表v$system_event，得到不同结果。
node1：
SQL> select event from v$system_event where event='direct path write';
EVENT
----------------------------------------------------------------
direct path write
node2：
SQL> select event from v$system_event where event='direct path write';
no rows selected
应该在RAC刚启动时会这样，在node1挂了后再启动加入cluster，这种情况node1也没有
direct path write 行。
这是个bug吗？ | b*****r
发帖数: 239 | 2 This is absolutely normal. on RAC environment, like other v$ view v$system_
event is node dependent. You can query gv$ view to get information on each
node.
【在 s*******9 的大作中提到】
: 在虚拟机里装了个RAC，发现个问题：
: 环境是这样的：
: oracle virtual box 4.3.14
: redhat linux enterprise edition 5.10
: oracle rac and oracle clusterware 10.2.0.5.0
: crs_stat -t
: ora....SM1.asm application ONLINE ONLINE node1
: ora....E1.lsnr application ONLINE ONLINE node1
: ora.node1.gsd application ONLINE ONLINE node1
: ora.node1.ons application ONLINE ONLINE node1
| c*****d
发帖数: 6045 | 3 bridger说的对，看RAC都要用gv$ view，否则只有本机的信息 |
|
|
|
|
|
|
