oracle 裸设备 ocr,裸设备建立RAC的OCR设备不一致的问题
如果使用裸設(shè)備建立RAC環(huán)境,各個(gè)節(jié)點(diǎn)的OCR設(shè)置對(duì)應(yīng)的物理設(shè)備名稱(chēng)可能是不一致的。
對(duì)于ASM磁盤(pán)組而言,三個(gè)節(jié)點(diǎn)上裸設(shè)備的物理名稱(chēng)不一致沒(méi)有問(wèn)題。比如在這個(gè)RAC環(huán)境中:
bash-2.03$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on星期四11月26 17:22:16 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set pages 100 lines 120
SQL> select inst_id, instance_name, host_name
2 from gv$instance;
INST_ID INSTANCE_NAME HOST_NAME
---------- ---------------- ----------------------------------------------------------------
1 testrac1 racnode1
3 testrac3 racnode3
2 testrac2 racnode2
SQL> exit從Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options斷開(kāi)
其中ASM1實(shí)例對(duì)應(yīng)的磁盤(pán)信息為:
bash-2.03$ hostname
racnode1
bash-2.03$ export ORACLE_SID=+ASM1
bash-2.03$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on星期四11月26 17:24:03 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set pages 100 lines 120
SQL> col name format a10
SQL> col path format a40
SQL> select group_number, name, state, total_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB
------------ ------------------------------ ---------------------- ----------
1 DISK MOUNTED 385186
SQL> select disk_number, name, path, total_mb
2 from v$asm_disk
3 where group_number = 1
4 order by 1;
DISK_NUMBER NAME PATH TOTAL_MB
----------- ---------- ---------------------------------------- ----------
0 DISK_0000 /dev/rdsk/c2t1d0s1 128
1 DISK_0001 /dev/rdsk/c2t1d0s6 24318
2 DISK_0002 /dev/rdsk/c2t1d1s1 4096
3 DISK_0003 /dev/rdsk/c2t1d1s3 4096
4 DISK_0004 /dev/rdsk/c2t1d1s4 4096
5 DISK_0005 /dev/rdsk/c2t1d1s5 4096
6 DISK_0006 /dev/rdsk/c2t1d1s6 4092
7 DISK_0007 /dev/rdsk/c2t1d2s4 1024
8 DISK_0008 /dev/rdsk/c2t1d2s5 1024
9 DISK_0009 /dev/rdsk/c2t1d2s6 1023
10 DISK_0010 /dev/rdsk/c2t1d3s1 1024
11 DISK_0011 /dev/rdsk/c2t1d3s3 1024
12 DISK_0012 /dev/rdsk/c2t1d3s4 1024
13 DISK_0013 /dev/rdsk/c2t1d3s5 1024
14 DISK_0014 /dev/rdsk/c2t1d3s6 989
15 DISK_0015 /dev/rdsk/c2t1d4s1 1024
16 DISK_0016 /dev/rdsk/c2t1d4s3 1024
17 DISK_0017 /dev/rdsk/c2t1d4s4 1024
18 DISK_0018 /dev/rdsk/c2t1d4s5 1024
19 DISK_0019 /dev/rdsk/c2t1d4s6 1023
20 DISK_0020 /dev/rdsk/c2t1d5s1 100
21 DISK_0021 /dev/rdsk/c2t1d5s3 100
22 DISK_0022 /dev/rdsk/c2t1d5s4 100
23 DISK_0023 /dev/rdsk/c2t1d5s5 100
24 DISK_0024 /dev/rdsk/c2t1d5s6 100
25 DISK_0025 /dev/rdsk/c2t1d5s7 99
26 DISK_0026 /dev/rdsk/c2t1d6s1 100
27 DISK_0027 /dev/rdsk/c2t1d6s3 100
28 DISK_0028 /dev/rdsk/c2t1d6s4 100
29 DISK_0029 /dev/rdsk/c2t1d6s5 100
30 DISK_0030 /dev/rdsk/c2t1d6s6 100
31 DISK_0031 /dev/rdsk/c2t1d6s7 99
32 DISK_0032 /dev/rdsk/c2t1d7s1 100
33 DISK_0033 /dev/rdsk/c2t1d7s3 100
34 DISK_0034 /dev/rdsk/c2t1d7s4 100
35 DISK_0035 /dev/rdsk/c2t1d7s5 100
36 DISK_0036 /dev/rdsk/c2t1d7s6 100
37 DISK_0037 /dev/rdsk/c2t1d7s7 99
38 DISK_0038 /dev/rdsk/c2t1d8s6 50940
39 DISK_0039 /dev/rdsk/c2t1d13s6 274252
已選擇40行。
而ASM2實(shí)例對(duì)應(yīng)的磁盤(pán)信息為:
bash-2.03$ hostname
racnode2
bash-2.03$ export ORACLE_SID=+ASM2
bash-2.03$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on星期四11月26 17:18:59 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set pages 100 lines 120
SQL> col name format a10
SQL> col path format a40
SQL> select group_number, name, state, total_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB
------------ ---------- ---------------------- ----------
1 DISK MOUNTED 385186
SQL> select disk_number, name, path, total_mb
2 from v$asm_disk
3 where group_number = 1
4 order by 1;
DISK_NUMBER NAME PATH TOTAL_MB
----------- ---------- ---------------------------------------- ----------
0 DISK_0000 /dev/rdsk/c2t500601603022E66Ad0s1 128
1 DISK_0001 /dev/rdsk/c2t500601603022E66Ad0s6 24318
2 DISK_0002 /dev/rdsk/c2t500601603022E66Ad1s1 4096
3 DISK_0003 /dev/rdsk/c2t500601603022E66Ad1s3 4096
4 DISK_0004 /dev/rdsk/c2t500601603022E66Ad1s4 4096
5 DISK_0005 /dev/rdsk/c2t500601603022E66Ad1s5 4096
6 DISK_0006 /dev/rdsk/c2t500601603022E66Ad1s6 4092
7 DISK_0007 /dev/rdsk/c2t500601603022E66Ad2s4 1024
8 DISK_0008 /dev/rdsk/c2t500601603022E66Ad2s5 1024
9 DISK_0009 /dev/rdsk/c2t500601603022E66Ad2s6 1023
10 DISK_0010 /dev/rdsk/c2t500601603022E66Ad3s1 1024
11 DISK_0011 /dev/rdsk/c2t500601603022E66Ad3s3 1024
12 DISK_0012 /dev/rdsk/c2t500601603022E66Ad3s4 1024
13 DISK_0013 /dev/rdsk/c2t500601603022E66Ad3s5 1024
14 DISK_0014 /dev/rdsk/c2t500601603022E66Ad3s6 989
15 DISK_0015 /dev/rdsk/c2t500601603022E66Ad4s1 1024
16 DISK_0016 /dev/rdsk/c2t500601603022E66Ad4s3 1024
17 DISK_0017 /dev/rdsk/c2t500601603022E66Ad4s4 1024
18 DISK_0018 /dev/rdsk/c2t500601603022E66Ad4s5 1024
19 DISK_0019 /dev/rdsk/c2t500601603022E66Ad4s6 1023
20 DISK_0020 /dev/rdsk/c2t500601603022E66Ad5s1 100
21 DISK_0021 /dev/rdsk/c2t500601603022E66Ad5s3 100
22 DISK_0022 /dev/rdsk/c2t500601603022E66Ad5s4 100
23 DISK_0023 /dev/rdsk/c2t500601603022E66Ad5s5 100
24 DISK_0024 /dev/rdsk/c2t500601603022E66Ad5s6 100
25 DISK_0025 /dev/rdsk/c2t500601603022E66Ad5s7 99
26 DISK_0026 /dev/rdsk/c2t500601603022E66Ad6s1 100
27 DISK_0027 /dev/rdsk/c2t500601603022E66Ad6s3 100
28 DISK_0028 /dev/rdsk/c2t500601603022E66Ad6s4 100
29 DISK_0029 /dev/rdsk/c2t500601603022E66Ad6s5 100
30 DISK_0030 /dev/rdsk/c2t500601603022E66Ad6s6 100
31 DISK_0031 /dev/rdsk/c2t500601603022E66Ad6s7 99
32 DISK_0032 /dev/rdsk/c2t500601603022E66Ad7s1 100
33 DISK_0033 /dev/rdsk/c2t500601603022E66Ad7s3 100
34 DISK_0034 /dev/rdsk/c2t500601603022E66Ad7s4 100
35 DISK_0035 /dev/rdsk/c2t500601603022E66Ad7s5 100
36 DISK_0036 /dev/rdsk/c2t500601603022E66Ad7s6 100
37 DISK_0037 /dev/rdsk/c2t500601603022E66Ad7s7 99
38 DISK_0038 /dev/rdsk/c2t500601603022E66Ad8s6 50940
39 DISK_0039 /dev/rdsk/c2t500601603022E66Ad13s6 274252
已選擇40行。
ASM3磁盤(pán)組對(duì)應(yīng)的裸設(shè)備也是不同的:
bash-3.00$ hostname
racnode3
bash-3.00$ export ORACLE_SID=+ASM3
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on星期四11月26 18:03:01 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set pages 100 lines 120
SQL> col name format a10
SQL> col path format a40
SQL> select group_number, name, state, total_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB
------------ ---------- ---------------------- ----------
1 DISK MOUNTED 385186
SQL> select disk_number, name, path, total_mb
2 from v$asm_disk
3 where group_number = 1
4 order by 1;
DISK_NUMBER NAME PATH TOTAL_MB
----------- ---------- ---------------------------------------- ----------
0 DISK_0000 /dev/rdsk/c1t500601603022E66Ad0s1 128
1 DISK_0001 /dev/rdsk/c1t500601603022E66Ad0s6 24318
2 DISK_0002 /dev/rdsk/c1t500601603022E66Ad1s1 4096
3 DISK_0003 /dev/rdsk/c1t500601603022E66Ad1s3 4096
4 DISK_0004 /dev/rdsk/c1t500601603022E66Ad1s4 4096
5 DISK_0005 /dev/rdsk/c1t500601603022E66Ad1s5 4096
6 DISK_0006 /dev/rdsk/c1t500601603022E66Ad1s6 4092
7 DISK_0007 /dev/rdsk/c1t500601603022E66Ad2s4 1024
8 DISK_0008 /dev/rdsk/c1t500601603022E66Ad2s5 1024
9 DISK_0009 /dev/rdsk/c1t500601603022E66Ad2s6 1023
10 DISK_0010 /dev/rdsk/c1t500601603022E66Ad3s1 1024
11 DISK_0011 /dev/rdsk/c1t500601603022E66Ad3s3 1024
12 DISK_0012 /dev/rdsk/c1t500601603022E66Ad3s4 1024
13 DISK_0013 /dev/rdsk/c1t500601603022E66Ad3s5 1024
14 DISK_0014 /dev/rdsk/c1t500601603022E66Ad3s6 989
15 DISK_0015 /dev/rdsk/c1t500601603022E66Ad4s1 1024
16 DISK_0016 /dev/rdsk/c1t500601603022E66Ad4s3 1024
17 DISK_0017 /dev/rdsk/c1t500601603022E66Ad4s4 1024
18 DISK_0018 /dev/rdsk/c1t500601603022E66Ad4s5 1024
19 DISK_0019 /dev/rdsk/c1t500601603022E66Ad4s6 1023
20 DISK_0020 /dev/rdsk/c1t500601603022E66Ad5s1 100
21 DISK_0021 /dev/rdsk/c1t500601603022E66Ad5s3 100
22 DISK_0022 /dev/rdsk/c1t500601603022E66Ad5s4 100
23 DISK_0023 /dev/rdsk/c1t500601603022E66Ad5s5 100
24 DISK_0024 /dev/rdsk/c1t500601603022E66Ad5s6 100
25 DISK_0025 /dev/rdsk/c1t500601603022E66Ad5s7 99
26 DISK_0026 /dev/rdsk/c1t500601603022E66Ad6s1 100
27 DISK_0027 /dev/rdsk/c1t500601603022E66Ad6s3 100
28 DISK_0028 /dev/rdsk/c1t500601603022E66Ad6s4 100
29 DISK_0029 /dev/rdsk/c1t500601603022E66Ad6s5 100
30 DISK_0030 /dev/rdsk/c1t500601603022E66Ad6s6 100
31 DISK_0031 /dev/rdsk/c1t500601603022E66Ad6s7 99
32 DISK_0032 /dev/rdsk/c1t500601603022E66Ad7s1 100
33 DISK_0033 /dev/rdsk/c1t500601603022E66Ad7s3 100
34 DISK_0034 /dev/rdsk/c1t500601603022E66Ad7s4 100
35 DISK_0035 /dev/rdsk/c1t500601603022E66Ad7s5 100
36 DISK_0036 /dev/rdsk/c1t500601603022E66Ad7s6 100
37 DISK_0037 /dev/rdsk/c1t500601603022E66Ad7s7 99
38 DISK_0038 /dev/rdsk/c1t500601603022E66Ad8s6 50940
39 DISK_0039 /dev/rdsk/c1t500601603022E66Ad13s6 274252
已選擇40行。
顯然實(shí)例ASM1中DISK磁盤(pán)組中的磁盤(pán)/dev/rdsk/c2t1d0s1,對(duì)應(yīng)的就是實(shí)例ASM2中DISK磁盤(pán)組中的磁盤(pán)/dev/rdsk/c2t500601603022E66Ad0s1,也就是實(shí)例ASM3中DISK磁盤(pán)組中的/dev/rdsk/c1t500601603022E66Ad0s1磁盤(pán)。雖然在三個(gè)服務(wù)器上三者的名稱(chēng)都不相同,但是它們對(duì)應(yīng)的是同一個(gè)裸設(shè)備。
雖然ASM有能力識(shí)別同一個(gè)磁盤(pán)在不同服務(wù)器上的不同的名稱(chēng),但是對(duì)于OCR和VOT盤(pán)來(lái)說(shuō),兩個(gè)節(jié)點(diǎn)上的名稱(chēng)不同是會(huì)報(bào)錯(cuò)的。在安裝時(shí)指定的安裝節(jié)點(diǎn)上的名稱(chēng),Oracle并不會(huì)檢查兩個(gè)節(jié)點(diǎn)上的名稱(chēng)是否不一致,也不會(huì)報(bào)錯(cuò)。但是安裝結(jié)束后,在非安裝節(jié)點(diǎn)上執(zhí)行$ORA_CLS_HOME/root.sh腳本時(shí),Oracle會(huì)根據(jù)安裝節(jié)點(diǎn)上的磁盤(pán)名稱(chēng)尋找裸設(shè)備,如果找不到對(duì)應(yīng)的設(shè)備,或者發(fā)現(xiàn)兩個(gè)節(jié)點(diǎn)對(duì)應(yīng)的裸設(shè)備不一致就會(huì)報(bào)錯(cuò)。
最簡(jiǎn)單的辦法是通過(guò)操作系統(tǒng)上的鏈接來(lái)解決這個(gè)問(wèn)題。
比如當(dāng)前的三個(gè)節(jié)點(diǎn)的RAC環(huán)境,由于不同服務(wù)器使用的網(wǎng)卡不同,導(dǎo)致掛載的裸設(shè)備的名稱(chēng)也是不相同的,為了解決這個(gè)問(wèn)題,通過(guò)在各個(gè)節(jié)點(diǎn)上建立相同的鏈接名稱(chēng)/dev/rac/ocr和/dev/rac/vot,在不同的節(jié)點(diǎn)上指向相同的裸設(shè)備,而在CLUSTER的安裝過(guò)程中,統(tǒng)一指向這個(gè)相同的鏈接的名稱(chēng)。
在節(jié)點(diǎn)1上:
bash-2.03$ hostname
racnode1
bash-2.03$ ls -l /dev/rac
total 4
lrwxrwxrwx 1 root other 18 Nov 26 16:52 ocr -> /dev/rdsk/c2t1d2s1
lrwxrwxrwx 1 root other 18 Nov 26 16:52 vot -> /dev/rdsk/c2t1d2s3
在節(jié)點(diǎn)2上:
bash-2.03$ hostname
racnode2
bash-2.03$ ls -l /dev/rac
total 4
lrwxrwxrwx 1 root other 33 Mar 14 2007 ocr -> /dev/rdsk/c2t500601603022E66Ad2s1
lrwxrwxrwx 1 root other 33 Mar 14 2007 vot -> /dev/rdsk/c2t500601603022E66Ad2s3
在節(jié)點(diǎn)3上:
bash-3.00$ hostname
racnode3
bash-3.00$ ls -l /dev/rac
total 4
lrwxrwxrwx 1 root root 33 Jul 1 16:44 ocr -> /dev/rdsk/c1t500601603022E66Ad2s1
lrwxrwxrwx 1 root root 33 Jul 1 16:44 vot -> /dev/rdsk/c1t500601603022E66Ad2s3
通過(guò)這種設(shè)置后,CLUSTER就可以順利的安裝了。
總結(jié)
以上是生活随笔為你收集整理的oracle 裸设备 ocr,裸设备建立RAC的OCR设备不一致的问题的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: 启动u盘制作好后系统怎么安装系统软件 &
- 下一篇: surface笔记本怎么进入u盘启动不了