- 最后登录
- 2013-11-9
- 在线时间
- 9 小时
- 威望
- 16
- 金钱
- 176
- 注册时间
- 2012-6-17
- 阅读权限
- 10
- 帖子
- 36
- 精华
- 0
- 积分
- 16
- UID
- 514
|
1#
发表于 2012-6-23 15:05:05
|
查看: 5063 |
回复: 3
//各位专家一起帮忙会诊一下这个数据库宕机问题
1、时间(在 2012-06-23 10:15:29.818,其中一个节点RAC宕机)
alert日志
见附件
trace日志
见附件
2、简单日志分析,日志非常简单,几乎没有什么错误日志
Sat Jun 23 10:21:43 2012
Process W003 died, see its trace file
Sat Jun 23 10:21:45 2012
Process PW61 died, see its trace file
Sat Jun 23 10:22:03 2012
Process m000 died, see its trace file
Sat Jun 23 10:24:41 2012
Process W002 died, see its trace file
Sat Jun 23 10:31:45 2012
Process PW62 died, see its trace file
Sat Jun 23 10:31:47 2012
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/aaadb/aaadb4/trace/aaadb4_cjq0_32727.trc:
3、查询系统的相关信息
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 2
gcs_server_processes integer 2
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 1500
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 51712M
sga_target big integer 0 |
|