« 《循序渐进Oracle》一书重印 | Blog首页 | 为什么Rac的心跳线不支持交叉线? »
CRS-0184错误与CRS初始化
作者：eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接：https://www.eygle.com/archives/2007/12/crs_0184_crs_start.html
链接：https://www.eygle.com/archives/2007/12/crs_0184_crs_start.html
当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使用crs_stat检查资源的启动情况：
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 -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
历史上的今天...
>> 2020-12-11文章:
>> 2016-12-11文章:
>> 2012-12-11文章:
>> 2011-12-11文章:
>> 2009-12-11文章:
>> 2005-12-11文章:
By eygle on 2007-12-11 10:19 | Comments (3) | Advanced | 1703 |
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!