当前位置:Gxlcms > mysql > OracleRAC10.2.0.5InstallForredhat5.8(userawdevice)

OracleRAC10.2.0.5InstallForredhat5.8(userawdevice)

时间:2021-07-01 10:21:17 帮助过:36人阅读

因为客户数据库需要打补丁,所以安装相似测试环境。需要先安装Oracle RAC 10.2.0.1 然后再升级到10.2.0.5。因为我有很多篇关于安

因为客户数据库需要打补丁,所以安装相似测试环境。需要先安装Oracle RAC 10.2.0.1 然后再升级到10.2.0.5。因为我有很多篇关于安装的文章,所以这篇只说关键步骤,以及遇见的bug安装错误。

注意:我已经在RedHat 6.3测试过,不能完成安装,主要是在跑root.sh脚本的时候无法通过。换成redhat 5.8不会出现这种问题。

Steps:
1、防火墙and selinux
2、kernel parameter
3、source limit
4、create user and group
5、建立信任关系
6、安装依赖包
7、配置用户环境变量和密码
8、创建裸设备
9、配置映射文件
10、安装grid
11、升级grid
12、配置vipca
13、安装database
14、升级database
15、创建rac数据库

因为10g没有11g自带工具可以很方便的打通道,所以比较麻烦,,不过这里我还是直接是把11g软件拿来解压用其工具自动建立信任关系。
安装依赖包:
yum install -y libXau* libxcb* libX11* libXext* libICE* libuuid* libSM* libXt* libXi* libXtst* libXp* glibc-devel* libaio-devel* libaio* compat-libstdc++* libXpm* libXp-devel* libXpm-devel* compat-libstdc++* compat-libstdc++* compat-libstdc++* gcc-4.4.6* gcc-c++*

创建裸设备:
我这里是用的Virtual Box建立的几块盘,这里提醒一下,需要把属性盘设置为共享,不然会报错。这里我前面文章也有说到
udev规则:
vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="sdb", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdc", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdd", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sde", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="sdf", RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add", KERNEL=="sdg", RUN+="/bin/raw /dev/raw/raw6 %N"
ACTION=="add", KERNEL=="sdh", RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add", KERNEL=="sdi", RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add", KERNEL=="sdj", RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add", KERNEL=="sdk", RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add", KERNEL=="sdl", RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add", KERNEL=="sdm", RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add", KERNEL=="sdn", RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add", KERNEL=="sdo", RUN+="/bin/raw /dev/raw/raw14 %N"
ACTION=="add", KERNEL=="sdp", RUN+="/bin/raw /dev/raw/raw16 %N"
ACTION=="add", KERNEL=="sdq", RUN+="/bin/raw /dev/raw/raw17 %N"
ACTION=="add", KERNEL=="sdr", RUN+="/bin/raw /dev/raw/raw18 %N"
ACTION=="add", KERNEL=="sds", RUN+="/bin/raw /dev/raw/raw19 %N"
ACTION=="add", KERNEL=="sdt", RUN+="/bin/raw /dev/raw/raw20 %N"
ACTION=="add", KERNEL=="sdu", RUN+="/bin/raw /dev/raw/raw21 %N"
ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="oinstall", MODE=="0660"


[root@rac2 ~]# ls -l /dev/raw
total 0
crw-rw—- 1 oracle oinstall 162, 1 Sep 29 04:17 raw1
crw-rw—- 1 oracle oinstall 162, 10 Sep 29 04:17 raw10
crw-rw—- 1 oracle oinstall 162, 11 Sep 29 04:17 raw11
crw-rw—- 1 oracle oinstall 162, 12 Sep 29 04:17 raw12
crw-rw—- 1 oracle oinstall 162, 13 Sep 29 04:17 raw13
crw-rw—- 1 oracle oinstall 162, 14 Sep 29 04:17 raw14
crw-rw—- 1 oracle oinstall 162, 16 Sep 29 04:17 raw16
crw-rw—- 1 oracle oinstall 162, 17 Sep 29 04:17 raw17
crw-rw—- 1 oracle oinstall 162, 18 Sep 29 04:17 raw18
crw-rw—- 1 oracle oinstall 162, 19 Sep 29 04:17 raw19
crw-rw—- 1 oracle oinstall 162, 2 Sep 29 04:17 raw2
crw-rw—- 1 oracle oinstall 162, 20 Sep 29 04:17 raw20
crw-rw—- 1 oracle oinstall 162, 21 Sep 29 04:17 raw21
crw-rw—- 1 oracle oinstall 162, 3 Sep 29 04:17 raw3
crw-rw—- 1 oracle oinstall 162, 4 Sep 29 04:17 raw4
crw-rw—- 1 oracle oinstall 162, 5 Sep 29 04:17 raw5
crw-rw—- 1 oracle oinstall 162, 6 Sep 29 04:17 raw6
crw-rw—- 1 oracle oinstall 162, 7 Sep 29 04:17 raw7
crw-rw—- 1 oracle oinstall 162, 8 Sep 29 04:17 raw8
crw-rw—- 1 oracle oinstall 162, 9 Sep 29 04:17 raw9

配置映射文件:
[oracle@rac1 ~]$ cat zbdba.txt
system=/dev/raw/raw6
sysaux=/dev/raw/raw7
example=/dev/raw/raw8
temp=/dev/raw/raw/raw11
users=/dev/raw/raw12
undotbs1=/dev/raw/raw13
undotbs2=/dev/raw/raw14
redo1_1=/dev/raw/raw5
redo1_2=/dev/raw/raw16
redo2_1=/dev/raw/raw17
redo2_2=/dev/raw/raw18
control1=/dev/raw/raw19
control2=/dev/raw/raw20
pwdfile=/dev/raw/raw9
spfile=/dev/raw/raw10

安装grid软件没什么问题,主要是跑root.sh脚本的时候。
会出现 Failed to upgrade Oracle Cluster Registry configuration错误,该错误的原因是一个bug,在文档466673.1有明确说明。所以下载
补丁4679769
解压该补丁,然后:
cp ./4679769/clsfmt.bin /u01/app/crs/bin/clsfmt.bin
将其覆盖

然后测试:
/u01/app/crs/bin/clsfmt.bin ocr /dev/raw/raw1
clsfmt: successfully initialized file /dev/raw/raw1

人气教程排行