eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 《循序渐进Oracle》一书重印 | Blog首页 | 为什么Rac的心跳线不支持交叉线? »

CRS-0184错误与CRS初始化


当CRS出现问题的时候,如果后台进程中止,则使用crs_start是无法启动服务的。
此时报出的是CRS-0184错误:
bash-2.05$ id
uid=101(oracle) gid=101(dba)
bash-2.05$ crs_start -all
CRS-0184: Cannot communicate with the CRS daemon.

检查一下crs进程:
$ ps -ef|grep crs
    root 10469    1  0 16:52:16 ?        0:00 /bin/sh /etc/init.d/init.crsd run
  oracle 14164  9725  0 17:05:48 pts/1    0:00 grep crs
 
此时需要以root身份启动crs后台进程:
# /etc/init.d/init.crs start
Startup will be queued to init within 30 seconds. 

# id
uid=0(root) gid=1(other)
# ps -ef|grep crs
  oracle 10402    1  0 16:52:16 ?        0:01 /opt/oracle/product/10.2.0/crs10g/bin/evmd.bin
    root 10469    1  0 16:52:16 ?        0:00 /bin/sh /etc/init.d/init.crsd run
    root 15320 10469  0 17:09:26 ?        0:03 /opt/oracle/product/10.2.0/crs10g/bin/crsd.bin reboot
  oracle 16569    1  0 17:09:58 ?        0:00 /opt/oracle/product/10.2.0/crs10g/opmn/bin/ons -d
  oracle 16570 16569  0 17:09:58 ?        0:00 /opt/oracle/product/10.2.0/crs10g/opmn/bin/ons -d
    root 15397 15307  0 17:09:26 ?        0:00 /opt/oracle/product/10.2.0/crs10g/bin/oprocd run -t 1000 -m 500 -f
  oracle 15550 15313  0 17:09:29 ?        0:01 /opt/oracle/product/10.2.0/crs10g/bin/ocssd.bin
  oracle 15424 15311  0 17:09:27 ?        0:00 /bin/sh -c cd /opt/oracle/product/10.2.0/crs10g/log/db210-rac1/cssd/oclsomon; u
    root 17177  9604  0 17:10:18 pts/1    0:00 grep crs
  oracle 15906 10402  0 17:09:40 ?        0:00 /opt/oracle/product/10.2.0/crs10g/bin/evmlogger.bin -o /opt/oracle/product/10.2
  oracle 15429 15424  0 17:09:27 ?        0:00 /opt/oracle/product/10.2.0/crs10g/bin/oclsomon.bin

后台进程启动之后,可以在Oracle用户下启动服务:
# su - oracle
Sun Microsystems Inc.  SunOS 5.9      Generic May 2002
$ crs_start -all
Attempting to start `ora.eygle.eygle_1.eygle1.srv` on member `db210-rac1`
Attempting to start `ora.eygle.eygle_available.eygle2.srv` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_available.cs` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_1.cs` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_2.cs` on member `db210-rac2`
Start of `ora.eygle.eygle_1.eygle1.srv` on member `db210-rac1` succeeded.
Attempting to start `ora.eygle.eygle_2.eygle2.srv` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_1.eygle2.srv` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_none.cs` on member `db210-rac2`
Start of `ora.eygle.eygle_1.cs` on member `db210-rac2` succeeded.
Attempting to start `ora.eygle.eygle_none.eygle1.srv` on member `db210-rac1`
Start of `ora.eygle.eygle_1.eygle2.srv` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_available.cs` on member `db210-rac2` succeeded.
Attempting to start `ora.eygle.eygle_none.eygle2.srv` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_notused.cs` on member `db210-rac2`
Start of `ora.eygle.eygle_2.cs` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_none.cs` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_none.eygle1.srv` on member `db210-rac1` succeeded.
Attempting to start `ora.eygle.eygle_notused.eygle2.srv` on member `db210-rac2`
Attempting to start `ora.eygle.eygle_rac.eygle1.srv` on member `db210-rac1`
Attempting to start `ora.eygle.eygle_rac.cs` on member `db210-rac2`
Start of `ora.eygle.eygle_available.eygle2.srv` on member `db210-rac2` succeeded.
Attempting to start `ora.eygle.eygle_rac.eygle2.srv` on member `db210-rac2`
Start of `ora.eygle.eygle_2.eygle2.srv` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_rac.eygle1.srv` on member `db210-rac1` succeeded.
Start of `ora.eygle.eygle_none.eygle2.srv` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_notused.eygle2.srv` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_notused.cs` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_rac.cs` on member `db210-rac2` succeeded.
Start of `ora.eygle.eygle_rac.eygle2.srv` on member `db210-rac2` succeeded.
使用crs_stat检查资源的启动情况:
$ crs_stat -t
Name          Type          Target    State    Host       
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    db210-rac1 
ora....C1.lsnr application    ONLINE    ONLINE    db210-rac1 
ora....ac1.gsd application    ONLINE    ONLINE    db210-rac1 
ora....ac1.ons application    ONLINE    ONLINE    db210-rac1 
ora....ac1.vip application    ONLINE    ONLINE    db210-rac1 
ora....SM2.asm application    ONLINE    ONLINE    db210-rac2 
ora....C2.lsnr application    ONLINE    ONLINE    db210-rac2 
ora....ac2.gsd application    ONLINE    ONLINE    db210-rac2 
ora....ac2.ons application    ONLINE    ONLINE    db210-rac2 
ora....ac2.vip application    ONLINE    ONLINE    db210-rac2 
ora.eygle.db  application    ONLINE    ONLINE    db210-rac2 
ora....e1.inst application    ONLINE    ONLINE    db210-rac1 
ora....e2.inst application    ONLINE    ONLINE    db210-rac2 
ora....le_1.cs application    ONLINE    ONLINE    db210-rac2 
ora....le1.srv application    ONLINE    ONLINE    db210-rac1 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 
ora....le_2.cs application    ONLINE    ONLINE    db210-rac2 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 
ora....able.cs application    ONLINE    ONLINE    db210-rac2 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 
ora....none.cs application    ONLINE    ONLINE    db210-rac2 
ora....le1.srv application    ONLINE    ONLINE    db210-rac1 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 
ora....used.cs application    ONLINE    ONLINE    db210-rac2 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 
ora...._rac.cs application    ONLINE    ONLINE    db210-rac2 
ora....le1.srv application    ONLINE    ONLINE    db210-rac1 
ora....le2.srv application    ONLINE    ONLINE    db210-rac2 

确认数据库实例及ASM都已经正常启动:
$ ps -ef|grep ora_
  oracle 16797    1  0 17:10:05 ?        0:02 ora_lmd0_eygle1
  oracle 16828    1  0 17:10:06 ?        0:00 ora_lgwr_eygle1
  oracle 17405    1  0 17:10:25 ?        0:03 ora_j000_eygle1
  oracle 16935    1  0 17:10:09 ?        0:00 ora_rbal_eygle1
  oracle 16824    1  0 17:10:06 ?        0:01 ora_mman_eygle1
  oracle 16826    1  0 17:10:06 ?        0:00 ora_dbw0_eygle1
  oracle  4800    1  0 17:20:12 ?        0:00 ora_pz99_eygle1
  oracle 17176    1  0 17:10:17 ?        0:00 ora_arc1_eygle1
  oracle 16785    1  0 17:10:05 ?        0:00 ora_diag_eygle1
  oracle 16860    1  0 17:10:07 ?        0:00 ora_s000_eygle1
  oracle 17573    1  0 17:10:32 ?        0:00 ora_q000_eygle1
  oracle  9820    1  0 17:23:03 ?        0:00 ora_q001_eygle1
  oracle 16923    1  0 17:10:09 ?        0:00 ora_asmb_eygle1
  oracle 16854    1  0 17:10:07 ?        0:05 ora_mmon_eygle1
  oracle 16852    1  0 17:10:07 ?        0:01 ora_cjq0_eygle1
  oracle 16856    1  0 17:10:07 ?        0:00 ora_mmnl_eygle1
  oracle 16799    1  0 17:10:05 ?        0:01 ora_lms0_eygle1
  oracle 16858    1  0 17:10:07 ?        0:00 ora_d000_eygle1
  oracle 16783    1  0 17:10:05 ?        0:00 ora_pmon_eygle1
  oracle 17003    1  0 17:10:12 ?        0:00 ora_o000_eygle1
  oracle 16788    1  0 17:10:05 ?        0:00 ora_psp0_eygle1
  oracle 16850    1  0 17:10:06 ?        0:00 ora_reco_eygle1
  oracle 16840    1  0 17:10:06 ?        0:00 ora_ckpt_eygle1
  oracle 17174    1  0 17:10:17 ?        0:00 ora_arc0_eygle1
  oracle 16895    1  0 17:10:08 ?        0:02 ora_lck0_eygle1
  oracle 12997 19171  0 17:24:52 pts/1    0:00 grep ora_
  oracle 16819    1  0 17:10:06 ?        0:01 ora_lms1_eygle1
  oracle 17279    1  0 17:10:21 ?        0:00 ora_qmnc_eygle1
  oracle 16848    1  0 17:10:06 ?        0:01 ora_smon_eygle1
  oracle 16790    1  0 17:10:05 ?        0:01 ora_lmon_eygle1
$ ps -ef|grep ASM
  oracle 16134    1  0 17:09:46 ?        0:00 asm_dbw0_+ASM1
  oracle 16120    1  0 17:09:45 ?        0:00 asm_diag_+ASM1
  oracle 16933    1  0 17:10:09 ?        0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oracle 16169    1  0 17:09:46 ?        0:00 asm_smon_+ASM1
  oracle 16136    1  0 17:09:46 ?        0:00 asm_lgwr_+ASM1
  oracle 16126    1  0 17:09:45 ?        0:00 asm_lmd0_+ASM1
  oracle 16540    1  0 17:09:57 ?        0:00 /opt/oracle/product/10.2.0/db/bin/racgimon daemon ora.db210-rac1.ASM1.asm
  oracle 16177    1  0 17:09:46 ?        0:00 asm_gmon_+ASM1
  oracle 16150    1  0 17:09:46 ?        0:00 asm_ckpt_+ASM1
  oracle 16221    1  0 17:09:47 ?        0:00 asm_lck0_+ASM1
  oracle 16118    1  0 17:09:45 ?        0:00 asm_pmon_+ASM1
  oracle 16122    1  0 17:09:45 ?        0:00 asm_psp0_+ASM1
  oracle 16124    1  0 17:09:45 ?        0:01 asm_lmon_+ASM1
  oracle 16132    1  0 17:09:46 ?        0:00 asm_mman_+ASM1
  oracle 16175    1  0 17:09:46 ?        0:00 asm_rbal_+ASM1
  oracle 16128    1  0 17:09:45 ?        0:00 asm_lms0_+ASM1
  oracle 16704    1  0 17:10:03 ?        0:00 asm_o000_+ASM1

历史上的今天...
    >> 2012-12-11文章:
    >> 2011-12-11文章:
    >> 2009-12-11文章:
    >> 2005-12-11文章:
           The Waiting Life
           How Oracle Store Number internal?

无觅

By eygle on 2007-12-11 10:19 | Comments (3) | Advanced | 1703 |

3 Comments

crs stack can also be started with:
$ORA_CRS_HOME/bin/crsctl start crs

请教大师一个问题,一个数据库中的SQL 从v$sqlstat中发现有很高的loads,这意味着什么,会消耗哪方面的资源,如何避免呢,在网上搜索了很久,都没有找到相关的资料。

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com