vicry21

6 积分	0 好友	1 主题

发消息

11g r2 rac crs启动不了

1^#

发表于 2012-4-6 14:07:19 | 查看: 9544| 回复: 8

环境：
11.2.0.3 rac+asm
linux 5.2

问题描述：
我现在看crsd.log的时候它一直在找ocr file.但是ocr是放到asm里面。。asm实例没有起来。
但是启动asm实例报下面的错误：
SQL> conn /as sysasm
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

[grid@ap07 bin]$ crsctl check has
CRS-4638: Oracle High Availability Services is online

[grid@ap07 bin]$ ps -ef |grep css
root    4485    1  0 Apr05 ?       00:01:25 /ora11g/app/11.2.0/grid/bin/cssdmonitor
grid    29976 29748  0 14:06 pts/1 00:00:00 grep css
[grid@ap07 bin]$ ps -ef |grep d.bin
root    3900    1  0 Apr05 ?       00:00:18 /ora11g/app/11.2.0/grid/bin/ohasd.bin reboot
grid    4268    1  0 Apr05 ?       00:00:28 /ora11g/app/11.2.0/grid/bin/oraagent.bin
grid    4280    1  0 Apr05 ?       00:00:02 /ora11g/app/11.2.0/grid/bin/mdnsd.bin
grid    4289    1  0 Apr05 ?       00:00:21 /ora11g/app/11.2.0/grid/bin/gpnpd.bin
root    4301    1  0 Apr05 ?       00:00:11 /ora11g/app/11.2.0/grid/bin/orarootagent.bin
grid    4304    1  0 Apr05 ?       00:01:43 /ora11g/app/11.2.0/grid/bin/gipcd.bin
root    4318    1  0 Apr05 ?       00:04:27 /ora11g/app/11.2.0/grid/bin/osysmond.bin
root    4392    1  0 Apr05 ?       00:02:56 /ora11g/app/11.2.0/grid/bin/ologgerd -M -d /ora11g/app/11.2.0/grid/crf/db/ap07
root    4485    1  0 Apr05 ?       00:01:25 /ora11g/app/11.2.0/grid/bin/cssdmonitor
grid    29978 29748  0 14:06 pts/1 00:00:00 grep d.bin

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-4-6 14:33:19

ODM TEST:

FOR GI/CRS 11.2.0.3

crsctl stop cluster -all  -f
crsctl stop has -f

[root@vrh1 ~]# crsctl stop has -f

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'vrh1'
CRS-2673: Attempting to stop 'ora.crf' on 'vrh1'
CRS-2677: Stop of 'ora.crf' on 'vrh1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'vrh1'
CRS-2677: Stop of 'ora.mdnsd' on 'vrh1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'vrh1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'vrh1'
CRS-2677: Stop of 'ora.gpnpd' on 'vrh1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vrh1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@vrh1 ~]# crsctl start crs -excl -nocrs

CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'vrh1'
CRS-2676: Start of 'ora.mdnsd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'vrh1'
CRS-2676: Start of 'ora.gpnpd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vrh1'
CRS-2672: Attempting to start 'ora.gipcd' on 'vrh1'
CRS-2676: Start of 'ora.cssdmonitor' on 'vrh1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'vrh1'
CRS-2672: Attempting to start 'ora.diskmon' on 'vrh1'
CRS-2676: Start of 'ora.diskmon' on 'vrh1' succeeded
CRS-2676: Start of 'ora.cssd' on 'vrh1' succeeded
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'vrh1'
CRS-2672: Attempting to start 'ora.ctssd' on 'vrh1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'vrh1'
CRS-2676: Start of 'ora.ctssd' on 'vrh1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'vrh1'
CRS-2676: Start of 'ora.asm' on 'vrh1' succeeded
[root@vrh1 ~]#

[root@vrh1 ~]# ps -ef|grep asm_
grid    23783    1  0 02:23 ?       00:00:00 asm_pmon_+ASM1
grid    23787    1  0 02:23 ?       00:00:00 asm_psp0_+ASM1
grid    23793    1  5 02:23 ?       00:00:05 asm_vktm_+ASM1
grid    23799    1  0 02:23 ?       00:00:00 asm_gen0_+ASM1
grid    23803    1  0 02:23 ?       00:00:00 asm_diag_+ASM1
grid    23807    1  0 02:23 ?       00:00:00 asm_ping_+ASM1
grid    23811    1  0 02:23 ?       00:00:00 asm_dia0_+ASM1
grid    23815    1  0 02:23 ?       00:00:00 asm_lmon_+ASM1
grid    23819    1  0 02:23 ?       00:00:00 asm_lmd0_+ASM1
grid    23823    1  0 02:23 ?       00:00:00 asm_lms0_+ASM1
grid    23829    1  0 02:23 ?       00:00:00 asm_lmhb_+ASM1
grid    23833    1  0 02:23 ?       00:00:00 asm_mman_+ASM1
grid    23837    1  0 02:23 ?       00:00:00 asm_dbw0_+ASM1
grid    23841    1  0 02:23 ?       00:00:00 asm_lgwr_+ASM1
grid    23845    1  0 02:23 ?       00:00:00 asm_ckpt_+ASM1
grid    23849    1  0 02:23 ?       00:00:00 asm_smon_+ASM1
grid    23853    1  0 02:23 ?       00:00:00 asm_rbal_+ASM1
grid    23857    1  0 02:23 ?       00:00:00 asm_gmon_+ASM1
grid    23861    1  0 02:23 ?       00:00:00 asm_mmon_+ASM1
grid    23865    1  0 02:23 ?       00:00:00 asm_mmnl_+ASM1
grid    23869    1  0 02:23 ?       00:00:00 asm_lck0_+ASM1
root    23983 22694  0 02:24 pts/0 00:00:00 grep asm_

[root@vrh1 ~]# su - grid

[grid@vrh1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal  Sector  Block    AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N       512 4096  1048576    46080 42306             0          42306             0          N  BACKUPDG/
MOUNTED  EXTERN  N       512 4096  1048576    87040 40417             0          40417             0          N  DATA/
MOUNTED  HIGH N       512 4096  1048576    25600 24344          10240          4701             0          Y  SYSTEMDG/

ASMCMD> cd systemdg
ASMCMD> ls
vrh-cluster/
ASMCMD> cd vrh-cluster
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd OCRFILE
ASMCMD> ls
REGISTRY.255.766612109

[root@vrh1 ~]# ocrconfig  -export ocr.exp
[root@vrh1 ~]# ocrdump ocr.bak

回复只看该作者道具举报

vicry21

3^#

发表于 2012-4-6 15:04:33

tks.这样子asm是已经起来啦。
但是我发现我这个asm1上面：
SQL> select name,state from v$asm_diskgroup;

NAME                         STATE
------------------------------ -----------
CRS                         MOUNTED
DATA                         MOUNTED

但是我在asm2上面缺发现：
SQL> conn /as sysasm
Connected.
SQL> select name,state from v$asm_diskgroup;

NAME                         STATE
------------------------------ -----------
CRS                         DISMOUNTED
DATA                         DISMOUNTED

SQL> alter diskgroup crs mount;
alter diskgroup crs mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "CRS" cannot be mounted
ORA-15003: diskgroup "CRS" already mounted in another lock name space

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2012-4-6 15:06:19

crsctl start crs -excl -nocrs

是以exclusive 排他方式启动CRS，不允许其他node节点参与，这种模式仅用来应对特殊场景。

回复只看该作者道具举报

vicry21

5^#

发表于 2012-4-6 15:25:16

如果是这样子的话。crs还是启动不了.
通过你上面的方法asm两边都能起来。但是当我crsctl stop has -f以后
crsctl start crs应该是都能带起来的啊。但是log里面还是一直
[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log
2012-04-06 15:20:17.569
[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2012-4-6 15:26:20

[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log

确认你的 Votedisk 完好

[root@vrh1 ~]# crsctl query  css votedisk
##  STATE File Universal Id             File Name Disk group
--  ----- -----------------             --------- ---------
1. ONLINE a853d6204bbc4feabfd8c73d4c3b3001 (/dev/asm-diskh) [SYSTEMDG]
2. ONLINE a5b37704c3574f0fbf21d1d9f58c4a6b (/dev/asm-diskg) [SYSTEMDG]
3. ONLINE 36e5c51ff0294fc3bf2a042266650331 (/dev/asm-diski) [SYSTEMDG]
4. ONLINE af337d1512824fe4bf6ad45283517aaa (/dev/asm-diskj) [SYSTEMDG]
5. ONLINE 3c4a349e2e304ff6bf64b2b1c9d9cf5d (/dev/asm-diskk) [SYSTEMDG]
Located 5 voting disk(s).

回复只看该作者道具举报

vicry21

7^#

发表于 2012-4-6 15:33:28

[root@ap07 bin]# ./crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'ap07'
CRS-2676: Start of 'ora.mdnsd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'ap07'
CRS-2676: Start of 'ora.gpnpd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ap07'
CRS-2672: Attempting to start 'ora.gipcd' on 'ap07'
CRS-2676: Start of 'ora.cssdmonitor' on 'ap07' succeeded
CRS-2676: Start of 'ora.gipcd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ap07'
CRS-2672: Attempting to start 'ora.diskmon' on 'ap07'
CRS-2676: Start of 'ora.diskmon' on 'ap07' succeeded
CRS-2676: Start of 'ora.cssd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'ap07'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'ap07'
CRS-2672: Attempting to start 'ora.ctssd' on 'ap07'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'ap07'
CRS-2676: Start of 'ora.drivers.acfs' on 'ap07' succeeded
CRS-2676: Start of 'ora.ctssd' on 'ap07' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'ap07'
CRS-2676: Start of 'ora.asm' on 'ap07' succeeded

[root@ap07 bin]# ./crsctl query css votedisk
Located 0 voting disk(s).

[grid@ap07 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal  Sector  Block    AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N       512 4096  8388608    3064    2624             0          2624             0          N  CRS/
MOUNTED  EXTERN  N       512 4096  8388608 102392 45688             0          45688             0          N  DATA/
ASMCMD> exit
[grid@ap07 ~]$ crsctl query css votedisk
Located 0 voting disk(s).

怎么votedisk没有了那。asmdisk 都是mount的啊。

回复只看该作者道具举报

Maclean Liu(刘相兵

8^#

发表于 2012-4-6 15:45:05

votedisk 是存放在那个DG上的？如果确实没有了，需要restore voting disk

回复只看该作者道具举报

vicry21

9^#

发表于 2012-4-6 15:48:58

votedisk,ocr全部都是放到asmdisk上面的。没有备份。
貌似要deleteroot.sh然后重新执行root.sh然后再将resource添加到crs里面啦。

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册