am196

17 积分	0 好友	10 主题

发消息

安装Oracle 11G Grid Infrastructure 数据库后CPU负载较高

1^#

发表于 2012-4-24 22:35:56 | 查看: 4762| 回复: 1

我安装的是oracle redhat AS 5.7版64的位操作系统,在装了Oracle 11G Grid Infrastructure R2 和 oracle 11G R2 之后,即使什么服务不开,CPU负载一直维持在1左右,top - 08:42:13 up 25 days, 22 min,  1 user,  load average: 1.08, 1.20, 1.24
Tasks: 172 total, 1 running, 171 sleeping, 0 stopped, 0 zombie
Cpu(s):  1.4%us,  0.2%sy,  0.0%ni, 93.5%id,  5.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem: 3970456k total,  3925560k used, 44896k free, 176436k buffers
Swap:  8385888k total, 295852k used,  8090036k free,  3166644k cached
  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
17570 oracle 15 0 12736 1052  720 R  2.0  0.0 0:00.01 top
用iostat,vmstat检查也没有检查出什么结果
看看单个CPU占用率也高
top - 08:43:43 up 25 days, 24 min,  1 user,  load average: 1.02, 1.14, 1.21
Tasks: 169 total, 1 running, 168 sleeping, 0 stopped, 0 zombie
Cpu0  :  7.9%us,  0.7%sy,  0.0%ni, 91.4%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu1  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu2  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu3  :  0.0%us,  0.3%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu4  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu5  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu6  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu7  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu8  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu9  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu10 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu11 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu12 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu13 :  0.0%us,  0.0%sy,  0.0%ni, 99.7%id,  0.3%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu14 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu15 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem: 3970456k total,  3917280k used, 53176k free, 176696k buffers
Swap:  8385888k total, 295852k used,  8090036k free,  3166756k cached
  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
17585 oracle 15 0 12740 1136  808 R  0.7  0.0 0:00.03 top
3347 grid    18 0  570m  27m  13m S  0.3  0.7  92:19.79 oraagent.bin
查了好久也没有查出结果,后来在做rman异机恢复的时候,老是报错,查看alert_sid.log
里面有ORA-00600 [kfioTranslateIO03] [17090]  这个错误,
去oracle support知识库里面查找

ORA-00600 [kfioTranslateIO03] [17090] [ID 1336846.1]

Cause
grouppermission of "oracle" executable from RDBMS home should have thesame group information for ASM devices according to note 1084186.1.

切换到gird用户下面
执行 ./setasmgidwrap  o=<11.2 RDBMS Home>/bin/oracle
11.2 RDBMS Home是oracle的ORACLE_HOME
执行的时候记得把数据库关闭,要不然会报数据库不是此用户开启的错误.
检查oracle的alert_sid.log里面没有错误,然后执行rman恢复,
RMAN成功恢复
结果再去top里发现,CPU负载居然降了下去.
top - 08:55:05 up 45 min,  2 users,  load average: 0.01, 0.03, 0.00
Tasks: 405 total, 1 running, 404 sleeping, 0 stopped, 0 zombie
Cpu(s):  0.0%us,  0.0%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem: 3970456k total, 3925560k used, 44896k free, 176436k buffers
Swap: 8385888k total, 295852k used, 8090036k free, 3166644k cached
  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
8157 root    15 0 13024 1360  824 R  0.7  0.0 0:00.06 top
7871 oracle 16 0 2043m 101m  97m S  0.3  0.4 0:00.10 oracle
虽然CPU负载下去了，但是不知道是什么原因造成的。

分享0