Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Oracle Internal
Home
+ new post
Pages
Files
About this group
Join this group
数据库服务器reboot
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
leeeecho  
View profile  
 More options Jul 27, 3:43 am
From: "leeeecho" <leeee...@gmail.com>
Date: Mon, 27 Jul 2009 15:43:58 +0800
Local: Mon, Jul 27 2009 3:43 am
Subject: 数据库服务器reboot
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

周日，两台数据库rac，同时重启，环境是linux 4 u4 +oracle 10.2.0.1

css的log如下：
[    CSSD]2009-07-26 11:26:40.191 [121547680] >WARNING: clssnmDiskPMT: long disk latency (56620 ms) to voting disk (2//dev/raw/raw5)
[    CSSD]2009-07-26 11:26:40.191 [121547680] >ERROR:   clssnmDiskPMT: 2 of 3 voting disks unavailable (1/0/2)
[    CSSD]2009-07-26 11:26:40.208 [121547680] >TRACE:   clssscctx:  dump of 0x0x810d290, len 3528

数据库日志：
Sun Jul 26 11:27:02 2009
Error: KGXGN aborts the instance (6)
Sun Jul 26 11:27:02 2009
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lmon_14176.trc:
ORA-29702: error occurred in Cluster Group Service operation
LMON: terminating instance due to error 29702
Sun Jul 26 11:27:03 2009
System state dump is made for local instance
System State dumped to trace file /opt/oracle/admin/orcl/bdump/orcl1_diag_14172.trc
Sun Jul 26 11:27:03 2009
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms0_14190.trc:
ORA-29702: error occurred in Cluster Group Service operation
Sun Jul 26 11:32:02 2009

看似好像是磁盘io延迟导致，不过那个时候数据库并不繁忙啊。大家一起分析下！


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Chan Qian  
View profile   Translate to Translated (View Original)
 More options Jul 27, 3:57 am
From: Chan Qian <sin...@gmail.com>
Date: Mon, 27 Jul 2009 15:57:18 +0800
Local: Mon, Jul 27 2009 3:57 am
Subject: Re: 数据库服务器reboot
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

和cluseter 有关系，系统检测到ora 有故障，所以切换导致，我认为有可能
Sincerely,
Chan Qian.

Ogden Nash <http://www.brainyquote.com/quotes/authors/o/ogden_nash.html>  -
"The trouble with a kitten is that when it grows up, it's always a cat."

2009/7/27 leeeecho <leeee...@gmail.com>


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Li jinghao  
View profile   Translate to Translated (View Original)
 More options Jul 27, 5:15 am
From: Li jinghao <lijing...@gmail.com>
Date: Mon, 27 Jul 2009 17:15:12 +0800
Local: Mon, Jul 27 2009 5:15 am
Subject: Re: 数据库服务器reboot
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

应该是voting disk io问题。譬如无法访问。

因为css 的node monitor发现voting访问失败，所以会重启。也因为css的Gourp Manage无法和DB
LMON通信，DB也就down了。

2009/7/27 leeeecho <leeee...@gmail.com>


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "答复: 数据库服务器reboot" by frank...@sz.cntrans.cn
frank...@sz.cntrans.cn  
View profile   Translate to Translated (View Original)
 More options Jul 27, 5:19 am
From: <frank...@sz.cntrans.cn>
Date: Mon, 27 Jul 2009 17:19:07 +0800
Local: Mon, Jul 27 2009 5:19 am
Subject: 答复: 数据库服务器reboot
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

看起来好像是和共享磁盘有关的，不知是不是访问共享存储有什么故障所导致。期待高
人出来解答！

MSN:xiangdongzou2...@hotmail.com

FETION:627173570

SKYPE:xiangdong.zou

MAIL:frank...@sz.cntrans.cn;xiangdong....@139.com

  _____  

发件人: Oracle-Internal@googlegroups.com
[mailto:Oracle-Internal@googlegroups.com] 代表 Chan Qian
发送时间: 2009年7月27日 15:57
收件人: Oracle-Internal@googlegroups.com
主题: Re: 数据库服务器reboot

和cluseter 有关系，系统检测到ora 有故障，所以切换导致，我认为有可能

Sincerely,
Chan Qian.

Ogden Nash <http://www.brainyquote.com/quotes/authors/o/ogden_nash.html>   -
"The trouble with a kitten is that when it grows up, it's always a cat."

2009/7/27 leeeecho <leeee...@gmail.com>

周日，两台数据库rac，同时重启，环境是linux 4 u4 +oracle 10.2.0.1

css的log如下：


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
frank...@sz.cntrans.cn  
View profile   Translate to Translated (View Original)
 More options Jul 27, 5:27 am
From: <frank...@sz.cntrans.cn>
Date: Mon, 27 Jul 2009 17:27:07 +0800
Local: Mon, Jul 27 2009 5:27 am
Subject: 答复: 数据库服务器reboot
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

通过crstl set css votedisk 高一点，不知会不会有用

MSN:xiangdongzou2...@hotmail.com

FETION:627173570

SKYPE:xiangdong.zou

MAIL:frank...@sz.cntrans.cn;xiangdong....@139.com

  _____  

发件人: Oracle-Internal@googlegroups.com
[mailto:Oracle-Internal@googlegroups.com] 代表 Li jinghao
发送时间: 2009年7月27日 17:15
收件人: Oracle-Internal@googlegroups.com
主题: Re: 数据库服务器reboot

应该是voting disk io问题。譬如无法访问。

因为css 的node monitor发现voting访问失败，所以会重启。也因为css的Gourp
Manage无法和DB LMON通信，DB也就down了。

2009/7/27 leeeecho <leeee...@gmail.com>

周日，两台数据库rac，同时重启，环境是linux 4 u4 +oracle 10.2.0.1

css的log如下：

[    CSSD]2009-07-26 11:26:40.191 [121547680] >WARNING: clssnmDiskPMT: long
disk latency (56620 ms) to voting disk (2//dev/raw/raw5)

[    CSSD]2009-07-26 11:26:40.191 [121547680] >ERROR:   clssnmDiskPMT: 2 of
3 voting disks unavailable (1/0/2)

[    CSSD]2009-07-26 11:26:40.208 [121547680] >TRACE:   clssscctx:  dump of
0x0x810d290, len 3528

数据库日志：

Sun Jul 26 11:27:02 2009

Error: KGXGN aborts the instance (6)

Sun Jul 26 11:27:02 2009

Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lmon_14176.trc:

ORA-29702: error occurred in Cluster Group Service operation

LMON: terminating instance due to error 29702

Sun Jul 26 11:27:03 2009

System state dump is made for local instance

System State dumped to trace file
/opt/oracle/admin/orcl/bdump/orcl1_diag_14172.trc

Sun Jul 26 11:27:03 2009

Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms0_14190.trc:

ORA-29702: error occurred in Cluster Group Service operation

Sun Jul 26 11:32:02 2009

看似好像是磁盘io延迟导致，不过那个时候数据库并不繁忙啊。大家一起分析下！


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google