当前位置:首页 » 《随便一记》 » 正文

虚拟机安装Oracle RAC_IIOOHHHSSSS的博客

2 人参与  2022年04月19日 13:59  分类 : 《随便一记》  评论

点击全文阅读


服务器信息:
节点一:192.168.10.2 dbm1
节点二:192.168.10.3 dbm2
操作系统均为红帽6.9
ip信息

public ip

192.168.10.2 dbm1
192.168.10.3 dbm2

private ip

10.10.0.4 dbm1-priv
10.10.0.5 dbm2-priv

vip

192.168.10.4 dbm1-vip
192.168.10.5 dbm2-vip

scan

192.168.10.6 scan

需要的安装包
cvuqdisk-1.0.9-1.rpm,pdksh-5.2.14-37.el5_8.1.x86_64.rpm,rlwrap-0.41-1.el6.x86_64.rpm,p13390677_112040_Linux-x86-64_1of7.zip,p13390677_112040_Linux-x86-64_2of7.zip,p13390677_112040_Linux-x86-64_3of7.zip,rhel-server-6.9-x86_64-dvd.iso,shell RAC.zip

双节点配置如下
[root@localhost apps]# vi /etc/sysconfig/network
[root@localhost apps]# cat /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=dbm1
[root@localhost apps]#
修改主机名,节点二修改为dbm2

[root@dbm1 ~]# chkconfig --level 2345 iptables off
[root@dbm1 ~]# chkconfig --level 2345 ip6tables off
[root@dbm1 ~]# service iptables stop
[root@dbm1 ~]# service ip6tables stop
[root@dbm1 ~]# vi /etc/sysconfig/selinux 修改为SELINUX=disabled
关闭服务

[root@dbm1 ~]# mkdir /mnt/cdrom
[root@dbm1 ~]# mount /apps/rhel-server-6.9-x86_64-dvd.iso /mnt/cdrom/ -o loop
[root@dbm1 ~]# vi /etc/yum.repos.d/rhel-source.repo
[root@dbm1 ~]# cat /etc/yum.repos.d/rhel-source.repo
[rhel-source-beta]
name=Red Hat Enterprise Linux $releasever Beta - $basearch - Source
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0
[root@dbm1 ~]#
安装配置源

[root@dbm1 ~]# yum -y install binutils* compat* elfutils* gcc-c* gcc* glibc* libaio* libgcc* libstdc* numactl* sysstat* unixODBC* make* compat* lib* ksh*
[root@dbm1 ~]# rpm -qa | grep ksh
ksh-20120801-33.el6.x86_64
[root@dbm1 ~]# rpm -e ksh-20120801-33.el6.x86_64
[root@dbm1 ~]# rpm -ivh /apps/pdksh-5.2.14-37.el5_8.1.x86_64.rpm
[root@dbm1 ~]# yum install readline-*
[root@dbm1 ~]# rpm -ivh /apps/rlwrap-0.41-1.el6.x86_64.rpm
[root@dbm1 ~]# rlwrap -v
rlwrap 0.41
[root@dbm1 ~]#
安装依赖包

[root@dbm1 ~]# yum groupinstall ‘X Window System’ Base Setup Desktop
[root@dbm1 ~]# yum install tigervnc tigervnc-server
[root@dbm1 ~]# vi /etc/sysconfig/vncservers
[root@dbm1 ~]# cat /etc/sysconfig/vncservers

安装桌面环境以及VNC此操作至需要在节点一进行(vncpasswd 给root,oracle,grid三个用户设置密码,在启动即可)

[root@dbm1 apps]# unzip shell\ RAC.zip
Archive: shell RAC.zip
inflating: 5preprofile.sh
inflating: 6presysctl.sh
inflating: 1preusers.sh
inflating: 2predir.sh
inflating: 3prelimits.sh
inflating: 4prelogin.sh
[root@dbm1 apps]# sh 1preusers.sh
Now create 6 groups named ‘oinstall’,‘dba’,‘asmadmin’,‘asmdba’,‘asmoper’,‘oper’
Plus 2 users named ‘oracle’,‘grid’,Also setting the Environment
更改用户 grid 的密码 。
passwd: 所有的身份验证令牌已经成功更新。
更改用户 oracle 的密码 。
passwd: 所有的身份验证令牌已经成功更新。
The Groups and users has been created
The Environment for grid,oracle also has been set successfully
[root@dbm1 apps]# sh 2predir.sh
Now create the necessary directory for oracle,grid users and change the authention to oracle,grid users…
The necessary directory for oracle,grid users and change the authention to oracle,grid users has been finished
[root@dbm1 apps]# sh 3prelimits.sh
Now modify the /etc/security/limits.conf,but backup it named /etc/security/limits.conf.bak before
Modifing the /etc/security/limits.conf has been succeed.
[root@dbm1 apps]# sh 4prelogin.sh
Now modify the /etc/pam.d/login,but with abackup named /etc/pam.d/login.bak
Modifing the /etc/pam.d/login has been succeed.
[root@dbm1 apps]# sh 5preprofile.sh
Now modify the /etc/profile,but with a backup named /etc/profile.bak
Modifing the /etc/profile has been succeed.
[root@dbm1 apps]# sh 6presysctl.sh
Now modify the /etc/sysctl.conf,but with a backup named /etc/sysctl.bak
Modifing the /etc/sysctl.conf has been succeed.
Now make the changes take effect…
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
net.core.rmem_default = 33554432
net.core.rmem_max = 33554432
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304
[root@dbm1 apps]#
创建用户,修改内核配置文件等

[root@dbm1 apps]# rpm -ivh cvuqdisk-1.0.9-1.rpm
[root@dbm1 apps]# vi /home/oracle/.bash_profile
[root@dbm1 apps]# cat /home/grid/.bash_profile

[root@dbm1 apps]# cat /home/oracle/.bash_profile

[root@dbm2 apps]# cat /home/grid/.bash_profile

[root@dbm2 apps]# cat /home/oracle/.bash_profile

[root@dbm2 apps]#
安装cvu包,查看环境变量

[root@dbm1 apps]# scsi_id -g -u /dev/sda
3639f0e78b0450c08b1a07da9878f97e9
[root@dbm1 apps]# scsi_id -g -u /dev/sdc
369bc040e2042a20b3200865aded14057
[root@dbm1 apps]# scsi_id -g -u /dev/sdb
36a910c2e704979084c206aec0abba9c1
[root@dbm1 apps]# parted /dev/sda
(parted) P
Model: SANGFOR VIRTUAL-DISK (scsi)
Disk /dev/sda: 2199GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number Start End Size File system Name 标志
1 1049kB 2000MB 1999MB ocr
2 2000MB 10.0GB 8001MB test
3 10.0GB 1000GB 990GB DATA
4 1000GB 2199GB 1199GB DATA1
Partition Table: gpt

Number Start End Size File system Name 标志
1 1049kB 1000GB 1000GB DATA2
2 1000GB 2199GB 1199GB DATA3
Partition Table: gpt

Number Start End Size File system Name 标志
1 1049kB 1000GB 1000GB FRA
2 1000GB 2199GB 1199GB FRA1

[root@dbm1 ~]#
[root@dbm1 ~]# cat /etc/udev/rules.d/90-dm.rules
KERNEL==“sdb1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk1”, MODE=“0660”
KERNEL==“sdb2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk2”, MODE=“0660”
KERNEL==“sdb3”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk3”, MODE=“0660”
KERNEL==“sdb4”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk4”, MODE=“0660”
KERNEL==“sdc1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk5”, MODE=“0660”
KERNEL==“sdc2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk6”, MODE=“0660”
KERNEL==“sda1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk7”, MODE=“0660”
KERNEL==“sda2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk8”, MODE=“0660”
[root@dbm1 ~]# ll /dev/asmdisk*
brw-rw---- 1 grid asmadmin 8, 17 11月 25 11:31 /dev/asmdisk1
brw-rw---- 1 grid asmadmin 8, 18 11月 25 11:31 /dev/asmdisk2
brw-rw---- 1 grid asmadmin 8, 19 11月 25 11:31 /dev/asmdisk3
brw-rw---- 1 grid asmadmin 8, 20 11月 25 11:31 /dev/asmdisk4
brw-rw---- 1 grid asmadmin 8, 33 11月 25 11:31 /dev/asmdisk5
brw-rw---- 1 grid asmadmin 8, 34 11月 25 11:31 /dev/asmdisk6
brw-rw---- 1 grid asmadmin 8, 1 11月 25 11:31 /dev/asmdisk7
brw-rw---- 1 grid asmadmin 8, 2 11月 25 11:31 /dev/asmdisk8
[root@dbm1 ~]#

[root@dbm2 ~]# cat /etc/udev/rules.d/90-dm.rules
KERNEL==“sdb1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk1”, MODE=“0660”
KERNEL==“sdb2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk2”, MODE=“0660”
KERNEL==“sdb3”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk3”, MODE=“0660”
KERNEL==“sdb4”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk4”, MODE=“0660”
KERNEL==“sdc1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk5”, MODE=“0660”
KERNEL==“sdc2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk6”, MODE=“0660”
KERNEL==“sda1”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk7”, MODE=“0660”
KERNEL==“sda2”, SUBSYSTEM==“block”, OWNER=“grid”, GROUP=“asmadmin”,NAME=“asmdisk8”, MODE=“0660”
[root@dbm2 ~]# ll /dev/asmdisk*
brw-rw---- 1 grid asmadmin 8, 17 11月 25 11:36 /dev/asmdisk1
brw-rw---- 1 grid asmadmin 8, 18 11月 25 11:36 /dev/asmdisk2
brw-rw---- 1 grid asmadmin 8, 19 11月 25 11:36 /dev/asmdisk3
brw-rw---- 1 grid asmadmin 8, 20 11月 25 11:36 /dev/asmdisk4
brw-rw---- 1 grid asmadmin 8, 33 11月 25 11:36 /dev/asmdisk5
brw-rw---- 1 grid asmadmin 8, 34 11月 25 11:36 /dev/asmdisk6
brw-rw---- 1 grid asmadmin 8, 1 11月 25 11:36 /dev/asmdisk7
brw-rw---- 1 grid asmadmin 8, 2 11月 25 11:36 /dev/asmdisk8
[root@dbm2 ~]#

因为是虚拟机,可以不做多路径,直接配置磁盘权限即可(俩个节点)

配置心跳解压安装包开始安装GR

验证等效性


执行root.sh俩个节点


GR安装完成

开始安装数据库软件

验证等效性
双节点实行root.sh


数据库软件安装完成

创建ASM磁盘组

asm 创建完成
DBCA建库




等到100%就ok了,后续在对数据库进行参数调优
至此RAC安装完成


点击全文阅读


本文链接:http://m.zhangshiyu.com/post/38445.html

节点  安装  配置  
<< 上一篇 下一篇 >>

  • 评论(0)
  • 赞助本站

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

最新文章

  • 小说江诗云路明哲小说已更新+番外篇章(年少的爱终将散去)纯净阅读
  • 真千金伪装大学生在自家公司实习让狗爬后一口气看完_宋氏小林小姑娘高分神作_小说后续在线阅读_无删减免费完结_
  • 萧逸尘,楚璃,叶紫嫣爱恨决绝,此生不见番外(爱恨决绝,此生不见)TXT+后续+结局在线阅读
  • 假千金要交换人生?我抱着空间做首富爽文_苏木青赵景城虐心反转_小说后续在线阅读_无删减免费完结_
  • 温时雨谢远之续集(清风难渡无缘人)全本完整免费版_起点章节+后续(温时雨谢远之)
  • 订婚两个月后,未婚夫要摆脱包办婚姻精心打造_肖明宝宝宾客故事会_小说后续在线阅读_无删减免费完结_
  • 霍景琛,苏晚,林深昔年请深如海,终不敌薄凉附加(霍景琛,苏晚,林深)(昔年请深如海,终不敌薄凉)全本浏览阅读连载中
  • 新章速递汤安甯,白子奕,汤贝贝是什么小说(结婚十年,回归家庭的老婆在外有二胎了)完本阅读无广告(结婚十年,回归家庭的老婆在外有二胎了)
  • 娇牛马导师偷我论文99篇成功升博导,我让他牢底坐穿精校文本_周老师师姐师兄爽文_小说后续在线阅读_无删减免费完结_
  • 独家顾宇,罗薇:结局+番外精编之作(资助生装阔气,我可不参加)电子书畅享阅读
  • 宗门全员重生,小师妹摆烂不干了(君拂君芙蓉)_宗门全员重生,小师妹摆烂不干了
  • 成了高考状元后,我倒欠两百万完结txt_阿姨叶青江安TOP10_小说后续在线阅读_无删减免费完结_

    关于我们 | 我要投稿 | 免责申明

    Copyright © 2020-2022 ZhangShiYu.com Rights Reserved.豫ICP备2022013469号-1