加入收藏 | 设为首页 | 会员中心 | 我要投稿 东莞站长网 (https://www.0769zz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长百科 > 正文

Oracle 11gR2 RAC搭建(虚拟机搭建)

发布时间:2021-03-18 07:43:18 所属栏目:站长百科 来源:网络整理
导读:安装环境说明与虚拟机规化: 安装环境 主机操作系统:windows 10 虚拟机VMware15:两台CentOS-7.6 Oracle Database software: Oracle11gR2 (11.2.0.1.0) Cluster software: Oracle grid infrastructure 11gR2(11.2.0.1.0) 共享存储:ASM oracle传送门 ht

需要注意的是ORACLE_UNQNAME是数据库名(这里用orcl),创建数据库时指定多个节点是会创建多个实例,ORACLE_SID指的是数据库实例名
#su - oracle
$vi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=orcl1 # RAC1使用这个配置
export ORACLE_SID=orcl2 # RAC2使用这个配置
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
$ source .bash_profile使配置文件生效(修改环境变量都是在最末行追加,保存后都要source使配置生效)

7.配置oracle、grid用户ssh互信

#su – oracle
$mkdir ~/.ssh
$chmod 755 .ssh 
$/usr/bin/ssh-keygen -t rsa
$/usr/bin/ssh-keygen -t dsa
下面步骤只在节点1执行,将所有的key文件汇总到一个总的认证文件中
$ssh rac1 cat ~/.ssh/id_rsa.pub >> authorized_keys
$ssh rac2 cat ~/.ssh/id_rsa.pub >> authorized_keys
$ssh rac1 cat ~/.ssh/id_dsa.pub >> authorized_keys
$ssh rac2 cat ~/.ssh/id_dsa.pub >> authorized_keys
$ cd ~/.ssh/
$ scp authorized_keys rac2:~/.ssh/  拷贝完整的key到节点2
[[email?protected] .ssh]chmod 600 authorized_keys  此处注意是登陆到节点2修改权限
下面步骤2个节点都要执行,否则后续安装会报错,相当重要,得到的结果应该是一个时间
$ssh rac1 date
$ssh rac2 date
$ssh rac1-priv date
$ssh rac2-priv date

grid的互信参照oracle用户处理即可

8.配置裸盘
(1)fdisk -l 通过该命令查看磁盘,可看到我们后面添加上去的磁盘信息,磁盘从sdb到sdf
(2)分区、格式化磁盘。由于是共享磁盘,所以只需要在一个节点上执行即可
在节点1上格式化,以/dev/sdb为例:
#fdisk /dev/sdb
The number of cylinders for this disk is set to 3824.
There is nothing wrong with that,but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g.,old versions of LILO)
2) booting and partitioning software from other OSs
(e.g.,DOS FDISK,OS/2 FDISK)
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-3824,default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-3824,default 3824):
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
格式化完毕后得到如下分区
#ls /dev/sd*
/dev/sda /dev/sda2 /dev/sdb1 /dev/sdc1 /dev/sdd1 /dev/sde1 /dev/sdf1 /dev/sda1 /dev/sdb /dev/sdc /dev/sdd /dev/sde /dev/sdf
(3)在节点上添加裸设备,注意2个节点都要执行

#vi /etc/udev/rules.d/99-oracle-asmdevices.rules
ACTION=="add",KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="sdd1",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="sde1",RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add",KERNEL=="sdf1",RUN+="/bin/raw /dev/raw/raw5 %N"
KERNEL=="raw[1]",MODE="0660",OWNER="grid",GROUP="asmadmin"
KERNEL=="raw[2]",GROUP="asmadmin"
KERNEL=="raw[3]",GROUP="asmadmin"
KERNEL=="raw[4]",GROUP="asmadmin"
KERNEL=="raw[5]",GROUP="asmadmin"

(4)启动裸设备,2个节点都执行
#start_udev
(5)查看裸设备,2个节点都要查看
#raw -qa
/dev/raw/raw1: bound to major 8,minor 17
/dev/raw/raw2: bound to major 8,minor 33
/dev/raw/raw3: bound to major 8,minor 49
/dev/raw/raw4: bound to major 8,minor 65
/dev/raw/raw5: bound to major 8,minor 81
9.挂载安装软件文件夹
这里是主机windows系统开启文件夹共享,将压缩包解压后供虚拟机挂载即可 ,这里的用户名密码目录仅供参考
mkdir -p /home/grid/db
mount -t cifs -o username=share,password=123456 //192.168.248.1/DB /home/grid/db
mkdir -p /home/oracle/db
mount -t cifs -o username=share,password=123456 //192.168.248.1/DB /home/oracle/db

10.安装用于环境检查的cvuqdisk(双机)

#cd /home/grid/db/rpm
#rpm -ivh cvuqdisk-1.0.7-1.rpm

11.手动运行cvu使用验证程序验证Oracle集群要求

#su - grid
$cd /home/grid/db/
$./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose

注:这里检查见过出现很多32位(i386或i686)的软件包校验不通过,我直接忽略不处理也没有影响系统使用,因此可以忽略,另外NTP、pdksh的报错也可以忽略,校验时2机报 glibc不存在,因此只能重新打包,从网上下载包
glibc-2.17-260.el7_6.4.i686.rpm ,直接安装存在依赖
error: Failed dependencies:
libfreebl3.so is needed by glibc-2.17-260.el7_6.4.i686
libfreebl3.so(N×××AWHASH_3.12.3) is needed by glibc-2.17-260.el7_6.4.i686
百度查询需要打包 nss-softokn-freebl-3.36.0-5.el7_5.i686.rpm ,直接打包报错:
error: Failed dependencies:
libc.so.6 is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.0) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.1) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.1.3) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.3) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.3.4) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libc.so.6(GLIBC_2.4) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libdl.so.2 is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libdl.so.2(GLIBC_2.0) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
libdl.so.2(GLIBC_2.1) is needed by nss-softokn-freebl-3.36.0-5.el7_5.i686
通过2个包一起安装解决:
#rpm -ivh glibc-2.17-260.el7_6.4.i686.rpm nss-softokn-freebl-3.36.0-5.el7_5.i686.rpm
Preparing... ################################# [100%]
Updating / installing...
1:nss-softokn-freebl-3.36.0-5.el7_5################################# [ 50%]
2:glibc-2.17-260.el7_6.4 ################################# [100%]


(编辑:东莞站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!