oracle rac 11gR1 电源割接，交换机掉电，3节点全故障

最新推荐文章于 2024-03-17 09:51:38 发布

老农民挖数据

最新推荐文章于 2024-03-17 09:51:38 发布

阅读量647

点赞数

分类专栏： oracle_trouble shooting

本文链接：https://blog.csdn.net/shushugood/article/details/81697738

版权

oracle_trouble shooting 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

话说这几年，一直玩的11gR2, 11gR1 确实没用过。没有grid用户，没有asm，心里不踏实。

现在已经启动完成，马上分享下，启动的进程有哪些。如果无法启动，只能手动启动各进程。

下图是在启动时，发现节点2 无法正常启动。

我们看节点1正常的。 crs进程有哪些，见下图

[root@racdb1 startup]# ps -ef|grep crs
root      7525     1  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run
root      9692  7523  0 03:40 ?        00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/crs/log/racdb1/evmd; exec /u01/app/crs/bin/evmd '
oracle    9693  9692  0 03:40 ?        00:00:02 /u01/app/crs/bin/evmd.bin
root      9719  7525  0 03:40 ?        00:00:57 /u01/app/crs/bin/crsd.bin reboot
root     10481  7199  0 08:42 pts/0    00:00:00 grep crs
oracle   10868  9774  0 03:40 ?        00:00:02 /u01/app/crs/bin/diskmon.bin -d -f
root     11017  9744  0 03:40 ?        00:00:00 /u01/app/crs/bin/oprocd run -t 1000 -m 500 -f
root     11027  9764  0 03:40 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   11030 11027  0 03:40 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   11067 11030  0 03:40 ?        00:00:00 /u01/app/crs/bin/oclsomon.bin
oracle   11115  9817  0 03:40 ?        00:01:05 /u01/app/crs/bin/ocssd.bin
root     11183     1  0 03:40 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   11238  9693  0 03:40 ?        00:00:00 /u01/app/crs/bin/evmlogger.bin -o /u01/app/crs/evm/log/evmlogger.info -l /u01/app/crs/evm/log/evmlogger.log
oracle   11834     1  0 03:41 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   12132     1  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
oracle   12133 12132  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
You have new mail in /var/spool/mail/root
[root@racdb1 startup]#

我们看节点2的crs进程，见下图

[root@racdb2 ~]# ps -ef|grep crs
root      8249     1  0 08:19 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run
root      9931  8249  0 08:19 ?        00:00:00 /u01/app/crs/bin/crsd.bin reboot
oracle   12062 10524  0 08:19 ?        00:00:00 /u01/app/crs/bin/diskmon.bin -d -f
root     12137 10494  0 08:19 ?        00:00:00 /u01/app/crs/bin/oprocd run -t 1000 -m 500 -f
oracle   12211 10721  0 08:19 ?        00:00:00 /u01/app/crs/bin/ocssd.bin
root     12268 10517  0 08:19 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb2/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   12269 12268  0 08:19 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb2/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   12314 12269  0 08:19 ?        00:00:00 /u01/app/crs/bin/oclsomon.bin
root     13259     1  0 08:19 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
root     17959 17821  0 08:20 pts/2    00:00:00 grep crs
[root@racdb2 ~]# crsctl check crs
Cluster Synchronization Services appears healthy
Cannot communicate with Cluster Ready Services
Cannot communicate with Event Manager
[root@racdb2 ~]# cd /ora/startup/

很明细对比 racdb1 和racdb2 ，racdb2少了 /u01/app/crs/bin/evmd.bin

那么我们直接手动拉起进程。

[root@racdb2 startup]# /bin/sh /etc/init.d/init.evmd run \&

再次查看节点2 的crs进程，耶和racdb1 一样的。

[root@racdb2 startup]# ps -ef|grep crs
root      8249     1  0 08:19 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run
root      9931  8249  0 08:19 ?        00:00:03 /u01/app/crs/bin/crsd.bin reboot
oracle   12062 10524  0 08:19 ?        00:00:00 /u01/app/crs/bin/diskmon.bin -d -f
root     12137 10494  0 08:19 ?        00:00:00 /u01/app/crs/bin/oprocd run -t 1000 -m 500 -f
oracle   12211 10721  0 08:19 ?        00:00:01 /u01/app/crs/bin/ocssd.bin
root     12268 10517  0 08:19 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb2/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   12269 12268  0 08:19 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb2/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   12314 12269  0 08:19 ?        00:00:00 /u01/app/crs/bin/oclsomon.bin
root     13259     1  0 08:19 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
root     17917 16348  0 08:40 pts/3    00:00:00 grep crs
root     20178 19686  0 08:24 ?        00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/crs/log/racdb2/evmd; exec /u01/app/crs/bin/evmd '
oracle   20179 20178  0 08:24 ?        00:00:00 /u01/app/crs/bin/evmd.bin
oracle   20253 20179  0 08:24 ?        00:00:00 /u01/app/crs/bin/evmlogger.bin -o /u01/app/crs/evm/log/evmlogger.info -l /u01/app/crs/evm/log/evmlogger.log
oracle   20609     1  0 08:24 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   27043     1  0 08:24 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
oracle   27044 27043  0 08:24 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
[root@racdb2 startup]#

那么我们查看crs状态

看整体集群状态

到这里节点故障就处理完成了。

下面我们分享下，11gR1 有哪些进程：

crs

\[root@racdb1 ~]# ps -ef|grep crs
root      7525     1  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.crsd run
root      9692  7523  0 03:40 ?        00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/crs/log/racdb1/evmd; exec /u01/app/crs/bin/evmd '
oracle    9693  9692  0 03:40 ?        00:00:02 /u01/app/crs/bin/evmd.bin
root      9719  7525  0 03:40 ?        00:00:59 /u01/app/crs/bin/crsd.bin reboot
oracle   10868  9774  0 03:40 ?        00:00:02 /u01/app/crs/bin/diskmon.bin -d -f
root     11017  9744  0 03:40 ?        00:00:00 /u01/app/crs/bin/oprocd run -t 1000 -m 500 -f
root     11027  9764  0 03:40 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   11030 11027  0 03:40 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   11067 11030  0 03:40 ?        00:00:00 /u01/app/crs/bin/oclsomon.bin
oracle   11115  9817  0 03:40 ?        00:01:07 /u01/app/crs/bin/ocssd.bin
root     11183     1  0 03:40 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   11238  9693  0 03:40 ?        00:00:00 /u01/app/crs/bin/evmlogger.bin -o /u01/app/crs/evm/log/evmlogger.info -l /u01/app/crs/evm/log/evmlogger.log
oracle   11834     1  0 03:41 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   12132     1  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
oracle   12133 12132  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
root     17234 17170  0 08:52 pts/0    00:00:00 grep crs
[root@racdb1 ~]#

css

[root@racdb1 ~]# ps -ef|grep css
root      7524     1  0 03:40 ?        00:00:35 /bin/sh /etc/init.d/init.cssd fatal
root      9744  7524  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.cssd oprocd
root      9764  7524  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.cssd oclsomon
root      9774  7524  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.cssd diskmon
root      9817  7524  0 03:40 ?        00:00:00 /bin/sh /etc/init.d/init.cssd daemon
root     11027  9764  0 03:40 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   11030 11027  0 03:40 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   11115  9817  0 03:40 ?        00:01:07 /u01/app/crs/bin/ocssd.bin
root     17566 17170  0 08:53 pts/0    00:00:00 grep css
[root@racdb1 ~]#

asm+ora

[root@racdb1 ora]# ps -ef|grep asm
oracle   11798     1  0 03:41 ?        00:00:00 asm_pmon_+ASM1
oracle   11800     1  0 03:41 ?        00:00:00 asm_vktm_+ASM1
oracle   11804     1  0 03:41 ?        00:00:00 asm_diag_+ASM1
oracle   11806     1  0 03:41 ?        00:00:00 asm_ping_+ASM1
oracle   11808     1  0 03:41 ?        00:00:00 asm_psp0_+ASM1
oracle   11810     1  0 03:41 ?        00:00:02 asm_dia0_+ASM1
oracle   11812     1  0 03:41 ?        00:00:02 asm_lmon_+ASM1
oracle   11814     1  0 03:41 ?        00:00:04 asm_lmd0_+ASM1
oracle   11816     1  0 03:41 ?        00:00:01 asm_lms0_+ASM1
oracle   11820     1  0 03:41 ?        00:00:00 asm_mman_+ASM1
oracle   11822     1  0 03:41 ?        00:00:00 asm_dbw0_+ASM1
oracle   11824     1  0 03:41 ?        00:00:00 asm_lgwr_+ASM1
oracle   11826     1  0 03:41 ?        00:00:00 asm_ckpt_+ASM1
oracle   11828     1  0 03:41 ?        00:00:00 asm_smon_+ASM1
oracle   11830     1  0 03:41 ?        00:00:01 asm_rbal_+ASM1
oracle   11832     1  0 03:41 ?        00:00:00 asm_gmon_+ASM1
oracle   11852     1  0 03:41 ?        00:00:00 asm_lck0_+ASM1
oracle   12108     1  0 03:41 ?        00:00:00 /u01/app/oracle/product/11.1/db/bin/racgimon daemon ora.racdb1.ASM1.asm
oracle   12397     1  0 03:41 ?        00:00:01 ora_asmb_telecom1
oracle   12403     1  0 03:41 ?        00:00:01 oracle+ASM1_asmb_telecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root     18769 17170  0 08:55 pts/0    00:00:00 grep asm
[root@racdb1 ora]# ps -ef|grep ora
root      6478  6450  0 03:39 ?        00:00:17 hald-addon-storage: polling /dev/scd0
oracle    8926     1  0 08:40 ?        00:00:00 oracletelecom1 (LOCAL=NO)
root      9692  7523  0 03:40 ?        00:00:00 /bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/crs/log/racdb1/evmd; exec /u01/app/crs/bin/evmd '
oracle    9693  9692  0 03:40 ?        00:00:02 /u01/app/crs/bin/evmd.bin
oracle   10650     1  0 08:42 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   10868  9774  0 03:40 ?        00:00:02 /u01/app/crs/bin/diskmon.bin -d -f
oracle   10924     1  0 08:43 ?        00:00:00 ora_q003_telecom1
root     11027  9764  0 03:40 ?        00:00:00 /sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?'
oracle   11030 11027  0 03:40 ?        00:00:00 /bin/sh -c cd /u01/app/crs/log/racdb1/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?
oracle   11058     1  0 07:52 ?        00:00:15 ora_w000_telecom1
oracle   11067 11030  0 03:40 ?        00:00:00 /u01/app/crs/bin/oclsomon.bin
oracle   11115  9817  0 03:40 ?        00:01:07 /u01/app/crs/bin/ocssd.bin
oracle   11238  9693  0 03:40 ?        00:00:00 /u01/app/crs/bin/evmlogger.bin -o /u01/app/crs/evm/log/evmlogger.info -l /u01/app/crs/evm/log/evmlogger.log
oracle   11798     1  0 03:41 ?        00:00:00 asm_pmon_+ASM1
oracle   11800     1  0 03:41 ?        00:00:00 asm_vktm_+ASM1
oracle   11804     1  0 03:41 ?        00:00:00 asm_diag_+ASM1
oracle   11806     1  0 03:41 ?        00:00:00 asm_ping_+ASM1
oracle   11808     1  0 03:41 ?        00:00:00 asm_psp0_+ASM1
oracle   11810     1  0 03:41 ?        00:00:02 asm_dia0_+ASM1
oracle   11812     1  0 03:41 ?        00:00:02 asm_lmon_+ASM1
oracle   11814     1  0 03:41 ?        00:00:04 asm_lmd0_+ASM1
oracle   11816     1  0 03:41 ?        00:00:01 asm_lms0_+ASM1
oracle   11820     1  0 03:41 ?        00:00:00 asm_mman_+ASM1
oracle   11822     1  0 03:41 ?        00:00:00 asm_dbw0_+ASM1
oracle   11824     1  0 03:41 ?        00:00:00 asm_lgwr_+ASM1
oracle   11826     1  0 03:41 ?        00:00:00 asm_ckpt_+ASM1
oracle   11828     1  0 03:41 ?        00:00:00 asm_smon_+ASM1
oracle   11830     1  0 03:41 ?        00:00:01 asm_rbal_+ASM1
oracle   11832     1  0 03:41 ?        00:00:00 asm_gmon_+ASM1
oracle   11834     1  0 03:41 ?        00:00:00 /u01/app/crs/bin/oclskd.bin
oracle   11843     1  0 03:41 ?        00:00:09 /u01/app/oracle/product/11.1/db/bin/tnslsnr LISTENER_RACDB1 -inherit
oracle   11852     1  0 03:41 ?        00:00:00 asm_lck0_+ASM1
oracle   12108     1  0 03:41 ?        00:00:00 /u01/app/oracle/product/11.1/db/bin/racgimon daemon ora.racdb1.ASM1.asm
oracle   12132     1  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
oracle   12133 12132  0 03:41 ?        00:00:00 /u01/app/crs/opmn/bin/ons -d
oracle   12205     1  0 03:41 ?        00:00:08 /u01/app/oracle/product/11.1/db/bin/racgimon startd telecom
oracle   12349     1  0 03:41 ?        00:00:07 ora_pmon_telecom1
oracle   12351     1  0 03:41 ?        00:00:00 ora_vktm_telecom1
oracle   12355     1  0 03:41 ?        00:00:00 ora_diag_telecom1
oracle   12357     1  0 03:41 ?        00:00:00 ora_dbrm_telecom1
oracle   12359     1  0 03:41 ?        00:00:00 ora_ping_telecom1
oracle   12361     1  0 03:41 ?        00:00:01 ora_psp0_telecom1
oracle   12363     1  0 03:41 ?        00:00:00 ora_acms_telecom1
oracle   12365     1  0 03:41 ?        00:00:49 ora_dia0_telecom1
oracle   12367     1  0 03:41 ?        00:00:18 ora_lmon_telecom1
oracle   12369     1  0 03:41 ?        00:00:57 ora_lmd0_telecom1
oracle   12371     1  1 03:41 ?        00:04:48 ora_lms0_telecom1
oracle   12375     1  1 03:41 ?        00:04:42 ora_lms1_telecom1
oracle   12379     1  0 03:41 ?        00:00:00 ora_rms0_telecom1
oracle   12381     1  0 03:41 ?        00:00:15 ora_mman_telecom1
oracle   12383     1  1 03:41 ?        00:03:36 ora_dbw0_telecom1
oracle   12385     1  1 03:41 ?        00:03:22 ora_dbw1_telecom1
oracle   12387     1  0 03:41 ?        00:01:57 ora_lgwr_telecom1
oracle   12389     1  0 03:41 ?        00:00:10 ora_ckpt_telecom1
oracle   12391     1  0 03:41 ?        00:00:19 ora_smon_telecom1
oracle   12393     1  0 03:41 ?        00:00:00 ora_reco_telecom1
oracle   12395     1  0 03:41 ?        00:00:00 ora_rbal_telecom1
oracle   12397     1  0 03:41 ?        00:00:01 ora_asmb_telecom1
oracle   12399     1  0 03:41 ?        00:00:05 ora_mmon_telecom1
oracle   12401     1  0 03:41 ?        00:00:03 ora_mmnl_telecom1
oracle   12403     1  0 03:41 ?        00:00:01 oracle+ASM1_asmb_telecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   12405     1  0 03:41 ?        00:00:00 ora_d000_telecom1
oracle   12407     1  0 03:41 ?        00:00:00 ora_s000_telecom1
oracle   12424     1  0 03:41 ?        00:01:00 ora_lck0_telecom1
oracle   12426     1  0 03:41 ?        00:00:00 ora_rsmn_telecom1
oracle   12438     1  0 03:41 ?        00:00:00 ora_mark_telecom1
oracle   12614     1  0 03:41 ?        00:00:45 ora_p000_telecom1
oracle   12617     1  0 03:41 ?        00:00:35 ora_p001_telecom1
oracle   12619     1  0 03:41 ?        00:00:33 ora_p002_telecom1
oracle   12622     1  0 03:41 ?        00:00:28 ora_p003_telecom1
oracle   12624     1  0 03:41 ?        00:00:23 ora_p004_telecom1
oracle   12626     1  0 03:41 ?        00:00:19 ora_p005_telecom1
oracle   12628     1  0 03:41 ?        00:00:14 ora_p006_telecom1
oracle   12630     1  0 03:41 ?        00:00:13 ora_p007_telecom1
oracle   12632     1  0 03:41 ?        00:00:12 ora_p008_telecom1
oracle   12634     1  0 03:41 ?        00:00:12 ora_p009_telecom1
oracle   12642     1  0 03:41 ?        00:00:11 ora_p010_telecom1
oracle   12644     1  0 03:41 ?        00:00:10 ora_p011_telecom1
oracle   12646     1  0 03:41 ?        00:00:02 ora_p012_telecom1
oracle   12648     1  0 03:41 ?        00:00:02 ora_p013_telecom1
oracle   12650     1  0 03:41 ?        00:00:02 ora_p014_telecom1
oracle   12652     1  0 03:41 ?        00:00:01 ora_p015_telecom1
oracle   13368     1  0 03:42 ?        00:00:00 ora_fbda_telecom1
oracle   13374     1  0 03:42 ?        00:00:00 ora_gtx0_telecom1
oracle   13400     1  0 03:42 ?        00:00:00 ora_qmnc_telecom1
oracle   13416     1  0 03:42 ?        00:00:02 ora_q001_telecom1
oracle   13507     1  0 03:42 ?        00:00:00 ora_smco_telecom1
oracle   13607     1  0 03:42 ?        00:00:00 oracletelecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   13692     1  0 03:42 ?        00:00:00 oracletelecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   13703     1  0 03:42 ?        00:00:00 ora_rcbg_telecom1
oracle   13853     1  0 03:42 ?        00:00:02 oracletelecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   14055     1  0 03:43 ?        00:00:06 oracletelecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   14106     1  0 08:48 ?        00:00:00 ora_o000_telecom1
oracle   14108     1  0 08:48 ?        00:00:00 oracle+ASM1_o000_telecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   14509     1  0 08:48 ?        00:00:00 ora_p016_telecom1
oracle   14511     1  0 08:48 ?        00:00:00 ora_p017_telecom1
oracle   14513     1  0 08:48 ?        00:00:00 ora_p018_telecom1
oracle   14515     1  0 08:48 ?        00:00:00 ora_p019_telecom1
oracle   14517     1  0 08:48 ?        00:00:00 ora_p020_telecom1
oracle   14519     1  0 08:48 ?        00:00:00 ora_p021_telecom1
oracle   14527     1  0 08:48 ?        00:00:00 ora_p022_telecom1
oracle   14529     1  0 08:48 ?        00:00:00 ora_p023_telecom1
oracle   14531     1  0 08:48 ?        00:00:00 ora_p024_telecom1
oracle   14533     1  0 08:48 ?        00:00:00 ora_p025_telecom1
oracle   14535     1  0 08:48 ?        00:00:00 ora_p026_telecom1
oracle   14537     1  0 08:48 ?        00:00:00 ora_p027_telecom1
oracle   14539     1  0 08:48 ?        00:00:00 ora_p028_telecom1
oracle   14541     1  0 08:48 ?        00:00:00 ora_p029_telecom1
oracle   14549     1  0 08:48 ?        00:00:00 ora_p030_telecom1
oracle   14551     1  0 08:48 ?        00:00:00 ora_p031_telecom1
oracle   14581     1  0 08:48 ?        00:00:00 ora_p032_telecom1
oracle   14583     1  0 08:48 ?        00:00:00 ora_p033_telecom1
oracle   14585     1  0 08:48 ?        00:00:00 ora_p034_telecom1
oracle   14587     1  0 08:48 ?        00:00:00 ora_p035_telecom1
oracle   14589     1  0 08:48 ?        00:00:00 ora_p036_telecom1
oracle   14591     1  0 08:48 ?        00:00:00 ora_p037_telecom1
oracle   14593     1  0 08:48 ?        00:00:00 ora_p038_telecom1
oracle   14597     1  0 08:48 ?        00:00:00 ora_p039_telecom1
oracle   14605     1  0 08:48 ?        00:00:00 ora_p040_telecom1
oracle   14607     1  0 08:48 ?        00:00:00 ora_p041_telecom1
oracle   14609     1  0 08:48 ?        00:00:00 ora_p042_telecom1
oracle   14611     1  0 08:48 ?        00:00:00 ora_p043_telecom1
oracle   14613     1  0 08:48 ?        00:00:00 ora_p044_telecom1
oracle   14615     1  0 08:48 ?        00:00:00 ora_p045_telecom1
oracle   14617     1  0 08:48 ?        00:00:00 ora_p046_telecom1
oracle   14619     1  0 08:48 ?        00:00:00 ora_p047_telecom1
oracle   14623     1  0 08:48 ?        00:00:00 ora_p048_telecom1
oracle   14631     1  0 08:48 ?        00:00:00 ora_p049_telecom1
oracle   14633     1  0 08:48 ?        00:00:00 ora_p050_telecom1
oracle   14635     1  0 08:48 ?        00:00:00 ora_p051_telecom1
oracle   14637     1  0 08:48 ?        00:00:00 ora_p052_telecom1
oracle   14639     1  0 08:48 ?        00:00:00 ora_p053_telecom1
oracle   14641     1  0 08:48 ?        00:00:00 ora_p054_telecom1
oracle   14643     1  0 08:48 ?        00:00:00 ora_p055_telecom1
oracle   14645     1  0 08:48 ?        00:00:00 ora_p056_telecom1
oracle   14653     1  0 08:48 ?        00:00:00 ora_p057_telecom1
oracle   14655     1  0 08:48 ?        00:00:00 ora_p058_telecom1
oracle   14657     1  0 08:48 ?        00:00:00 ora_p059_telecom1
oracle   14659     1  0 08:48 ?        00:00:00 ora_p060_telecom1
oracle   14661     1  0 08:48 ?        00:00:00 ora_p061_telecom1
oracle   14663     1  0 08:48 ?        00:00:00 ora_p062_telecom1
oracle   14665     1  0 08:48 ?        00:00:00 ora_p063_telecom1
oracle   16589     1  0 08:51 ?        00:00:00 ora_q002_telecom1
oracle   17266     1  0 03:46 ?        00:00:05 ora_cjq0_telecom1
oracle   17363     1 61 03:46 ?        03:09:06 ora_j011_telecom1
oracle   18624     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18638     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18646     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18648     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18650     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18652     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18660     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18721     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18729     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18731     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18733     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18749     1  0 08:54 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18777     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18779     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18793     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18801     1  0 08:55 ?        00:00:00 ora_j000_telecom1
oracle   18867     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18881     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18889     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18897     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
oracle   18912     1  0 08:55 ?        00:00:00 oracletelecom1 (LOCAL=NO)
root     18932 17170  0 08:55 pts/0    00:00:00 grep ora
oracle   20839     1  0 04:31 ?        00:00:15 ora_pz99_telecom1
oracle   28536     1  0 04:01 ?        00:00:00 oracletelecom1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[root@racdb1 ora]#

可以自动添加脚本处理

more startup.sh 
/bin/sh /etc/init.d/init.crsd run &
/bin/sh /etc/init.d/init.cssd daemon &
/bin/sh /etc/init.d/init.cssd diskmon &
/bin/sh /etc/init.d/init.cssd oclsomon &
/bin/sh /etc/init.d/init.cssd oprocd &
/u01/app/crs/bin/oclskd.bin &
/bin/su -l oracle -c sh -c 'ulimit -c unlimited; cd /u01/app/crs/log/racdb3/evmd; exec /u01/app/crs/bin/evmd ' &
/sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb3/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?' &
/sbin/runuser -l oracle -c /bin/sh -c 'cd /u01/app/crs/log/racdb3/cssd/oclsomon; ulimit -c unlimited; /u01/app/crs/bin/oclsomon  || exit $?' &

[root@racdb1 startup]# more startup.sh 
source /etc/profile
crsctl start crs
/etc/init.d/init.evmd run >/dev/null 2>&1 </dev/null &
/etc/init.d/init.cssd fatal >/dev/null 2>&1 </dev/null &
/etc/init.d/init.crsd run >/dev/null 2>&1 </dev/null &

[root@racdb1 startup]#

[root@racdb2 startup]# more startup.sh 
source /etc/profile
crsctl start crs

#wait 5 minute
sleep 300
echo "Now!! You must run follow command with user root:"
echo /bin/sh /etc/init.d/init.evmd run \&
[root@racdb2 startup]#

裸设备赋权

[root@racdb3 startup]# more reraw.sh
#!/bin/sh

source /etc/profile

function info() {
   echo "`date +'%F %R:%S'`: $*"
}

index=1
udevFile="/etc/udev/rules.d/60-raw.rules"
function bindRaw() {
   dev="$1"
   devOwner="$2"
   devGroup="$3"
   devPrim="$4"
   rawdev="${rawpath}${index}"
   info "Bind raw , Dev: $dev; owner: $devOwner; group: $devGroup; prim: $devPrim."
   echo "ACTION==\"add\", KERNEL==\"${dev}\", RUN+=\"/bin/raw /dev/raw/raw${index} %N\"" >> $udevFile
   echo "KERNEL==\"raw${index}\", OWNER=\"${devOwner}\", GROUP=\"${devGroup}\", MODE=\"${devPrim}\"" >> $udevFile
   index=$((index+1))
}

#区分所有盘

info "All disk: `fdisk -l |grep MB`"
rm -rf ./tmp/*.dd
mkdir -p ./tmp
ocr=""
vote=""
spfile=""
for dsk in $(fdisk -l |grep MB |cut -d ':' -f1|cut -d' ' -f 2)
do
   dskName=$(echo "${dsk}"|cut -d '/' -f3)
   dd if=${dsk}1 of=./tmp/${dskName} bs=8192 count=1 > /dev/null 2>&1
   
   check=$(strings ./tmp/${dskName} |grep '}|{z' |grep -v grep|wc -l)
   ocrCount=$(strings ./tmp/${dskName} |grep ssLck |grep -v grep|wc -l)
   spfileCount=$(strings ./tmp/${dskName} |grep oracle |grep ASM|grep -v grep|wc -l)
   
   if [ $ocrCount -gt 0 -a $check -gt 0 ]; then
        ocr=$(echo "$ocr ${dskName}1")
	 elif [ $spfileCount -gt 0 -a $check -eq 0 ]; then
	  	spfile=$(echo "$spfile ${dskName}1")
	 elif [ $check -gt 0 ]; then
	    vote=$(echo "$vote ${dskName}1")  
	 fi
done

info "ocr: $ocr"
info "vote: $vote"
info "spfile: $spfile"

#判断获取的盘是否为空

if [ "$ocr" = "" ]; then
   info "ERROR: ocr is null"
   exit 0
fi
if [ "$vote" = "" ]; then
   info "ERROR: vote is null"
   exit 0
fi
if [ "$spfile" = "" ]; then
   info "ERROR: spfile is null"
   exit 0
fi

#重新生成绑定设备文件

mv $udevFile ./tmp/60-raw.rules.`date +'%Y%m%d%H%M%S'`

#bind ocr device
for dev in $ocr
do
  bindRaw "$dev" "oracle" "dba" "640"
done

#bind vote device
for dev in $vote
do
  bindRaw "$dev" "root" "dba" "640"
done

#bind spfile device
for dev in $spfile
do
  bindRaw "$dev" "oracle" "dba" "640"
done

#绑定设备

info "start_udev"
start_udev

service

[root@racdb2 startup]# more service.sh 
su - oracle -c "srvctl stop service -d telecom -s dataclient -f && srvctl status service -d telecom -s dataclient && srvctl start service -d telecom -s dataclient && srvctl status service -d 
telecom -s dataclient"
su - oracle -c "srvctl stop service -d telecom -s dataldr -f && srvctl status service -d telecom -s dataldr && srvctl start service -d telecom -s dataldr && srvctl status service -d telecom -
s dataldr"

[root@racdb2 startup]#

老农民挖数据

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle rac 11gR1 电源割接，交换机掉电，3节点全故障

话说这几年，一直玩的11gR2, 11gR1 确实没用过。没有grid用户，没有asm，心里不踏实。现在已经启动完成，马上分享下，启动的进程有哪些。如果无法启动，只能手动启动各进程。下图是在启动时，发现节点2 无法正常启动。我们看节点1正常的。 crs进程有哪些，见下图[root@racdb1 startup]# ps -ef|grep crsroot ...
复制链接

扫一扫