Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

19

积分

0

好友

2

主题
1#
发表于 2012-5-21 14:31:14 | 查看: 7480| 回复: 8
环境: aix6.1  oracle 10.2.0.4
状况:
1.其中一个节点执行crs_stat -t 报错 CRS-0184: Cannot communicate with the CRS daemon.
2.上述节点ps -ef|grep ora_ 数据库相关进程都在
3.上述节点可以sqlplus 登陆
4.上树节点root执行
crsctl start crs 提示
Attempting to start CRS stack
The CRS stack will be started shortly
然后oracle执行crs_stat -t提示 CRS-0184: Cannot communicate with the CRS daemon

请帮帮看看这个问题,如果需要提供日志,请告诉我提供哪些日志
2#
发表于 2012-5-21 14:34:44
把问题节点上的

CRS logs are in $ORA_CRS_HOME/log/<hostname>/crsd/crsd.log
CSS logs are in $ORA_CRS_HOME/log/<hostname>/cssd/ocssd.log

crsctl check crs
crsctl check css

回复 只看该作者 道具 举报

3#
发表于 2012-5-22 09:15:35
# /oracle/crs/bin/crsctl check css
Failure 1 contacting CSS daemon
# /oracle/crs/bin/crsctl check crs
Failure 1 contacting CSS daemon
Cannot communicate with CRS
Cannot communicate with EVM
crsd.log.txt (5.23 MB, 下载次数: 962) ocssd.log.txt (276 KB, 下载次数: 970)

回复 只看该作者 道具 举报

4#
发表于 2012-5-22 17:46:47
你在root用户下面,开启一下crs,这个就是crs没有打开,或是遇到什么问题dang了。如果可以重启的话,我建议先正常关闭,在按照步骤来启动。

回复 只看该作者 道具 举报

5#
发表于 2012-5-23 09:57:03
楼上的哥们儿, 你的意思是把整个服务器重启了?

回复 只看该作者 道具 举报

6#
发表于 2012-5-23 10:24:18

  1. crsd.log shows error 'Failed to spawn a thread for UI connection. error=-11' [ID 1389408.1]       

  2. 修改时间:2011-12-30类型:PROBLEM状态:PUBLISHED优先级:3       


  3. In this Document
  4.   Symptoms
  5.   Cause
  6.   Solution
  7.   References

  8. Applies to:
  9. Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1
  10. Generic Linux
  11. Generic UNIX
  12. Symptoms
  13. <CRS_HOME>/log/<nodename>/crsd/crsd.log shows below error:

  14. 2011-12-27 11:41:13.404: [ CRSMAIN][10287] Failed to spawn a thread for UI connection. error=-11


  15. "ps -ef|grep crsd.bin" shows crsd.bin is up and running, but crs_stat shows the following error:

  16. crs_stat -t
  17. CRS-0184: Cannot communicate with the CRS daemon.


  18. Cause
  19. Refer to Solution Section.

  20. Solution
  21. 1. Incorrect stack setting for root user:

  22. #ulimit -a
  23. time(seconds) unlimited
  24. file(blocks) 2097151
  25. data(kbytes) 131072
  26. stack(kbytes) 32768<==========
  27. memory(kbytes) 32768
  28. coredump(blocks) 2097151
  29. nofiles(descriptors) 2000
  30. threads(per process) unlimited
  31. processes(per user) unlimited

  32. The issue happens more often on AIX, and the stack size should be unlimited.



  33. 2. Unpublished bug 6117687 - CRS slow memory leak from repeated "crsctl check crs"

  34. The bug is fixed in 10.2.0.4, 11.1.0.6 and above
复制代码
可以查查这里面提到的内容,试试看。

回复 只看该作者 道具 举报

7#
发表于 2012-5-23 14:55:27
ODM DATA:

  1. [    CSSD]2011-11-16 10:34:00.153 [2829] >TRACE:   clssgmHandleDBDone(): src/dest (1/65535) size(72) incarn 6
  2. [    CSSD]CLSS-3000: reconfiguration successful, incarnation 6 with 2 nodes

  3. [    CSSD]CLSS-3001: local node number 2, master node number 1

  4. [    CSSD]2011-11-16 10:34:00.154 [3857] >TRACE:   clssgmReconfigThread:  completed for reconfig(6), with status(1)
  5. [    CSSD]2011-11-16 10:34:00.582 [2829] >TRACE:   clssgmCommonAddMember: clsomon joined (2/0x1000000/#CSS_CLSSOMON)
  6. [    CSSD]2012-02-21 22:34:28.368 [2572] >TRACE:   Authorization failed (111a818f0), timed out, start 22:32:28.368, duration 120000

  7. [    CSSD]2012-02-21 22:34:28.368 [2572] >TRACE:   Authorization prepare time: 1 ms

  8. [    CSSD]2012-02-21 22:34:29.608 [2572] >TRACE:   Authorization failed (111aa6550), timed out, start 22:32:29.608, duration 120000

  9. [    CSSD]2012-02-21 22:34:29.608 [2572] >TRACE:   Authorization prepare time: 1 ms

  10. [    CSSD]2012-02-21 22:35:30.176 [2572] >TRACE:   Authorization failed (111ab6950), timed out, start 22:33:30.174, duration 120001

  11. [    CSSD]2012-02-21 22:35:30.176 [2572] >TRACE:   Authorization prepare time: 0 ms

  12. [    CSSD]2012-02-21 22:36:30.665 [2572] >TRACE:   Authorization failed (111a818f0), timed out, start 22:34:30.664, duration 120000

  13. [    CSSD]2012-02-21 22:36:30.665 [2572] >TRACE:   Authorization prepare time: 0 ms

  14. [    CSSD]2012-02-21 22:37:31.153 [2572] >TRACE:   Authorization failed (111aa6550), timed out, start 22:35:31.153, duration 120000

  15. [    CSSD]2012-02-21 22:37:31.153 [2572] >TRACE:   Authorization prepare time: 1 ms

  16. [    CSSD]2012-02-21 22:37:49.164 [2572] >TRACE:   Authentication OSD error, op: scls_auth_response_prepare
  17. loc: mkdir
  18. info: failed to make dir /oracle/crs/css/auth/A3861086, No space left on device
  19. dep: 28
  20. [    CSSD]2012-02-21 22:37:49.359 [2572] >TRACE:   Authentication OSD error, op: scls_auth_response_prepare
  21. loc: mkdir
  22. info: failed to make dir /ora
复制代码

回复 只看该作者 道具 举报

8#
发表于 2012-5-23 15:03:03
就日志 论日志 而言, 你上传的node2的日志 说明:

这套CRS 应当是在2011-05-22 安装的,并升级到 10.2.0.4

最近一次的成功reconfiguration  是在 2011-11-16 10:34:00.582

之后在2012-02-21 css被再次启动过 可能源于 重启


但是出现了 一下错误

[    CSSD]2012-02-21 22:37:49.164 [2572] >TRACE:   Authentication OSD error, op: scls_auth_response_prepare
loc: mkdir
info: failed to make dir /oracle/crs/css/auth/A3861086, No space left on device



这应当是由于  /oracle/crs/css/auth/A3861086 所在mount点 没有剩余磁盘空间所致

crsd.log 日志 也是现实相似的信息

2012-01-17 23:24:03.955: [  CRSRES][12351]32Start of `ora.portaldb02.LISTENER_PORTALDB02.lsnr` on member `portaldb02` succeeded.
2012-01-17 23:24:08.544: [  OCRUTL][5410]u_freem: mem passed is null
2012-01-24 01:45:07.030: [ COMMCRS][3611]Authorization failed, network error

回复 只看该作者 道具 举报

9#
发表于 2012-5-23 15:39:55
原来是磁盘空间满了啊!这个问题怎么没有人检查吗?哎~~不该啊

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 17:30 , Processed in 0.055074 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569