摘要:本文主要向大家介绍了Oracle数据库之Oracle RAC部署过程,通过具体的内容向大家展现,希望对大家学习Oracle数据库有所帮助。
本文主要向大家介绍了Oracle数据库之Oracle RAC部署过程,通过具体的内容向大家展现,希望对大家学习Oracle数据库有所帮助。
oracle RAC部署lsb_release -avmware-vdiskmanager.exe -c -s 20000Mb -a lsilogic -t 2 D:\Oracle_RAC\ocr.vmdkvmware-vdiskmanager.exe -c -s 20000Mb -a lsilogic -t 2 D:\Oracle_RAC\ocr2.vmdkvmware-vdiskmanager.exe -c -s 20000Mb -a lsilogic -t 2 D:\Oracle_RAC\votingdisk.vmdkvmware-vdiskmanager.exe -c -s 30000Mb -a lsilogic -t 2 D:\Oracle_RAC\data.vmdkvmware-vdiskmanager.exe -c -s 20000Mb -a lsilogic -t 2 D:\Oracle_RAC\backup.vmdkRAC1
配置虚拟机RAC1 RAC2目录下的vmx虚拟机配置文件,在行最后添加如下:scsi1.present = "TRUE"scsi1.virtualDev = "lsilogic"scsi1.sharedBus = "virtual"scsi1:1.present = "TRUE"scsi1:1.mode = "independent-persistent"scsi1:1.filename = "D:\Oracle_RAC\ocr.vmdk"scsi1:1.deviceType = "plainDisk"scsi1:2.present = "TRUE"scsi1:2.mode = "independent-persistent"scsi1:2.filename = "D:\Oracle_RAC\votingdisk.vmdk"scsi1:2.deviceType = "plainDisk"scsi1:3.present = "TRUE"scsi1:3.mode = "independent-persistent"scsi1:3.filename = "D:\Oracle_RAC\data.vmdk"scsi1:3.deviceType = "plainDisk"scsi1:4.present = "TRUE"scsi1:4.mode = "independent-persistent"scsi1:4.filename = "D:\Oracle_RAC\backup.vmdk"scsi1:4.deviceType = "plainDisk"scsi1:5.present = "TRUE"scsi1:5.mode = "independent-persistent"scsi1:5.filename = "D:\Oracle_RAC\ocr2.vmdk"scsi1:5.deviceType = "plainDisk"disk.locking = "false"diskLib.dataCacheMaxSize = "0"diskLib.dataCacheMaxReadAheadSize = "0"diskLib.DataCacheMinReadAheadSize = "0"diskLib.dataCachePageSize = "4096"diskLib.maxUnsyncedWrites = "0"
关闭selinuxsetenforce 0 [root@rac1 ~]# vi /etc/selinux/configSELINUX=disabled关闭防火墙service iptables stopchkconfig iptables off卸载NTP服务[root@rac2 ~]# rpm -qa |grep ntp[root@rac2 ~]# rpm -e --nodeps ntp-4.2.6p5-1.el6.centos.x86_64[root@rac2 ~]# rpm -e --nodeps ntpdate-4.2.6p5-1.el6.centos.x86_64[root@rac2 ~]#mv /etc/ntp.conf /etc/ntp.conf.bak
hostname rac1hostname rac2RAC1eth0 192.168.100.103eht1 10.10.10.100RAC2eth0 192.168.100.104eth1 10.10.10.101vi /etc/sysconfig/network
vi /etc/hosts192.168.100.103 rac1192.168.100.104 rac2192.168.100.105 rac1-vip192.168.100.108 rac2-vip10.10.10.100 rac1-priv10.10.10.101 rac2-priv192.168.100.88 scan-ip
创建相关用户:groupadd -g 1300 dbagroupadd -g 1301 opergroupadd -g 1000 oinstallgroupadd -g 1200 asmadmingroupadd -g 1201 asmdbagroupadd -g 1202 asmoperuseradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -s /bin/bash grid useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -s /bin/bash oracle设置相关账户密码:passwd oracle passwd gridRAC1 RAC2相互配置ssh免秘钥登陆在用户root oracle grid执行以下2行命令:RAC1、RAC2:ssh-keygen -t rsassh-keygen -t dsa切换用户配置以下ssh命令:su - oraclesu - gridRAC1[oracle@RAC1 ~]$ssh rac1 cat ~/.ssh/id_rsa.pub >> authorized_keysssh rac2 cat ~/.ssh/id_rsa.pub >> authorized_keysssh rac1 cat ~/.ssh/id_dsa.pub >> authorized_keysssh rac2 cat ~/.ssh/id_dsa.pub >> authorized_keys[oracle@RAC1 .ssh]$ scp authorized_keys rac2:~/.ssh/[oracle@RAC1 .ssh]$ chmod 600 authorized_keysRAC2:[oracle@RAC2 ~]$ssh rac2 cat ~/.ssh/id_rsa.pub >> authorized_keysssh rac1 cat ~/.ssh/id_rsa.pub >> authorized_keysssh rac2 cat ~/.ssh/id_dsa.pub >> authorized_keysssh rac1 cat ~/.ssh/id_dsa.pub >> authorized_keys[oracle@RAC2 .ssh]$ scp authorized_keys rac1:~/.ssh/[oracle@RAC2 .ssh]$ chmod 600 authorized_keysssh rac1 datessh rac2 datessh rac1-priv datessh rac2-priv date
配置目录mkdir -p /u01/app/11.2.0/gridmkdir -p /u01/app/gridmkdir -p /u01/app/oraclechown -R grid:oinstall /u01chown grid:oinstall /u01/app/11.2.0/gridchown grid:oinstall /u01/app/gridchown oracle:oinstall /u01/app/oraclechmod -R 775 /u01/
设置内核文件:vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4398046511104kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586net.ipv4.tcp_wmem = 262144 262144 262144net.ipv4.tcp_rmem = 4194304 4194304 4194304参考值:kernel.shmmax =1054472192 (参考值)sysctl -p 立即生效
配置系统文件vi /etc/security/limits.confgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536
配置grid和oracle用户环境变量su - oracleORACLE环境变量vi .bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_SID=orcl1 # RAC1export ORACLE_SID=orcl2 # RAC2export ORACLE_UNQNAME=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export TNS_ADMIN=$ORACLE_HOME/network/adminexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibumask 022使配置文件生效 source .bash_profileGRID环境变量su - gridvi .bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_SID=+ASM1 # RAC1
export ORACLE_SID=+ASM2 # RAC2 配置一个即可
export ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/11.2.0/gridexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibumask 022使配置文件生效 source .bash_profile配置login[root@rac1 ~]# vi /etc/pam.d/loginsession required pam_limits.so
配置裸盘:查看未格式化的磁盘fdisk -lls /dev/sdfdisk格式化命令:fdisk /dev/sdbCommand (m for help): nCommand actione extendedp primary partition (1-4)pPartition number (1-4): 1最后 w 命令保存更改Command (m for help): w依次执行:fdisk /dev/sdbfdisk /dev/sddfdisk /dev/sdcfdisk /dev/sdffdisk /dev/sdevi /etc/udev/rules.d/60-raw.rulesACTION=="add",KERNEL=="/dev/sdb1",RUN+=‘/bin/raw /dev/raw/raw1 %N"ACTION=="add",ENV{MAJOR}=="8",ENV{MINOR}=="17",RUN+="/bin/raw /dev/raw/raw1 %M %m"ACTION=="add",KERNEL=="/dev/sdc1",RUN+=‘/bin/raw /dev/raw/raw2 %N"ACTION=="add",ENV{MAJOR}=="8",ENV{MINOR}=="33",RUN+="/bin/raw /dev/raw/raw2 %M %m"ACTION=="add",KERNEL=="/dev/sdd1",RUN+=‘/bin/raw /dev/raw/raw3 %N"ACTION=="add",ENV{MAJOR}=="8",ENV{MINOR}=="49",RUN+="/bin/raw /dev/raw/raw3 %M %m"ACTION=="add",KERNEL=="/dev/sde1",RUN+=‘/bin/raw /dev/raw/raw4 %N"ACTION=="add",ENV{MAJOR}=="8",ENV{MINOR}=="65",RUN+="/bin/raw /dev/raw/raw4 %M %m"ACTION=="add",KERNEL=="/dev/sdf1",RUN+=‘/bin/raw /dev/raw/raw5 %N"ACTION=="add",ENV{MAJOR}=="8",ENV{MINOR}=="81",RUN+="/bin/raw /dev/raw/raw5 %M %m"ACTION=="add",KERNEL=="raw[1-5]",OWNER="grid",GROUP="asmadmin",MODE="660"在RAC1和RAC2执行下同步命令:partprobe执行这个命令查看下:ll /dev/raw/raw查看裸盘信息:[root@rac2 ~]# lsblkNAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTsda 8:0 0 40G 0 disk├─sda1 8:1 0 1000M 0 part /boot├─sda2 8:2 0 3.9G 0 part [SWAP]└─sda3 8:3 0 35.1G 0 part /sdb 8:16 0 19.5G 0 disk└─sdb1 8:17 0 19.5G 0 partsdc 8:32 0 19.5G 0 disk└─sdc1 8:33 0 19.5G 0 partsdd 8:48 0 29.3G 0 disk└─sdd1 8:49 0 29.3G 0 partsde 8:64 0 19.5G 0 disk└─sde1 8:65 0 19.5G 0 partsdf 8:80 0 19.5G 0 disk└─sdf1 8:81 0 19.5G 0 partsr0 11:0 1 4.2G 0 rom 挂载光驱mount /dev/sr0 /media/CentOS_6.5_Final (参考命令:mount /dev/cdrom /mnt/cdrom/ )vi /etc/yum.repos.d/dvd.repo[dvd]name=dvdbaseurl=file:///media/CentOS_6.5_Finalgpgcheck=0enabled=1:wq!安装依赖包:[root@rac1 ~]# yum clean all[root@rac1 ~]# yum makecache[root@rac1 ~]# yum install gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel make sysstatyum install binutils-2 compat-libcap1-1 compat-libstdc gcc-4 gcc-c++-4 glibc-2 glibc-devel-2 libgcc-4 libstdc++-4 libstdc++-devel-4 libaio-0 libaio-devel-0 make-3 sysstat-9 -ymv /etc/yum.repos.d/CentOS-Base.repo /rootmv /etc/yum.repos.d/CentOS-Debuginfo.repo /rootmv /etc/yum.repos.d/CentOS-Media.repo /rootmv /etc/yum.repos.d/CentOS-Vault.repo /rootcp /root/CentOS-Base.repo /etc/yum.repos.dcp /root/CentOS-Debuginfo.rep /etc/yum.repos.dcp /root/CentOS-Media.repo /etc/yum.repos.dcp /root/CentOS-Vault.repo /etc/yum.repos.dyum install -y glibc-devel-2.12-1.209.el6_9.2.i686yum install -y libstdc++-4.4.7-18.el6.i686yum install -y glibc.i686 glibc.x86_64yum install -y elfutils-libelf-devel.i686yum install -y elfutils-libelf进grid下面安装cvuqdisk包xhost + #使所有用户都能访问图形桌面,这步需要在图形界面操作date -s 18:00:00/u01/app/oraInventory/orainstRoot.sh/u01/app/11.2.0/grid/root.sh
/u01/app/11.2.0/grid/crs/install/crsconfig_params[root@rac1 grid]# /u01/app/11.2.0/grid/root.shRunning Oracle 11g root.sh script...The following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /u01/app/11.2.0/gridEnter the full pathname of the local bin directory: [/usr/local/bin]:The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
y Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.2017-08-03 18:31:49: Parsing the host name2017-08-03 18:31:49: Checking for super user privileges2017-08-03 18:31:49: User has super user privilegesUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsCRS is already configured on this node for crshome=0Cannot configure two CRS instances on the same cluster.Please deconfigure before proceeding with the configuration of new home.[root@rac1 grid]#卸载命令$GRID_HOME/crs/install/roothas.pl -delete -force -verbose/u01/app/11.2.0/grid/crs/install/rootcrs.pl -delete -force -verboseExisting OCR configuration found, aborting the configuration. Rerun configuration setup after deinstall at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 10302.确定RAC是否OKsu - gridcrsctl status resource -t修改网卡规则vi /etc/udev/rules.d/70-persistent-net.rules三驾马车不是DG GG RAC切换scan-ip命令:srvctl relocate scan_listener -i 1 -n rac2
本文由职坐标整理并发布,希望对同学们学习Oracle有所帮助,更多内容请关注职坐标数据库Oracle数据库频道!
您输入的评论内容中包含违禁敏感词
我知道了
请输入正确的手机号码
请输入正确的验证码
您今天的短信下发次数太多了,明天再试试吧!
我们会在第一时间安排职业规划师联系您!
您也可以联系我们的职业规划师咨询:
版权所有 职坐标-一站式IT培训就业服务领导者 沪ICP备13042190号-4
上海海同信息科技有限公司 Copyright ©2015 www.zhizuobiao.com,All Rights Reserved.
沪公网安备 31011502005948号