VMware+Linux+freeNas+Oracle+Rac安装详解(配图)

更新时间:2023-11-11 20:39:01 阅读量: 教育文库 文档下载

说明:文章内容仅供预览,部分内容可能不全。下载后的文档,内容与下面显示的完全一致。下载之前请确认下面内容是否您想要的,是否完整无缺。

主机名称 rac1 rac2 Linux 1 (RAC1)

Public IP 192.168.225.130 192.168.225.131 NAT(eth0) 192.168.225.30 192.168.225.130 VMnet5(eth1)-(192.168.5.130) FreeNas Virtual IP(不用配置到网卡上) 192.168.225.30 192.168.225.31 NAT(eth0) 192.168.225.31 192.168.225.131 Heart Plus IP 192.168.5.130 192.168.5.131 Linux 2 (RAC2) VMnet5(eth1)-(192.168.5.131) VMnet5 192.168.5.128 192.168.5.129 配置iScsi连接(两个节点执行)

创建iSCSI interfaces

iscsiadm -m iface -I iface0 -o new 查看iSCSI interface

iscsiadm -m iface -I iface0 绑定iSCSI interfaces iscsiadm -m iface -o update -I iface0 -n iface.net_ifacename -v eth1

连接iSCSI阵列,启用iSCSI服务 service iscsid start 登录到目标

iscsiadm -m discovery -t st -p 192.168.5.128 -l iscsiadm -m discovery -t st -p 192.168.5.129 -l

启动multipath服务:

service multipathd restart

设置multipathd服务开机自启动

# chkconfig multipathd on

修改/etc/multipath.conf

wwid:330000000dc46ab54 wwid:330000000010301ec

查看multipath配置

[root@localhost ~]# multipath -ll

svr-vol1 (330000000010301ec) dm-0 FreeBSD,iSCSI Disk [size=20G][features=0][hwhandler=0][rw] \\_ round-robin 0 [prio=1][active] \\_ 1:0:0:0 sdb 8:16 [active][ready] \\_ round-robin 0 [prio=1][enabled] \\_ 3:0:0:0 sdd 8:48 [active][ready]

svr_vol0 (330000000dc46ab54) dm-1 FreeBSD,iSCSI Disk

[size=20G][features=1 queue_if_no_path][hwhandler=0][rw] \\_ round-robin 0 [prio=2][active] \\_ 2:0:0:0 sdc 8:32 [active][ready] \\_ 4:0:0:0 sde 8:64 [active][ready]

创建用户和组 (两个节点执行)

在节点一上以root身份运行: # groupadd oinstall # groupadd dba # groupadd oper

# useradd -g oinstall -G dba,oper oracle # id oracle

uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) # passwd oracle (oracle) # id nobody

在节点二上以root身份运行: # groupadd -g 500 oinstall # groupadd -g 501 dba

# useradd -u 500 -m -g oinstall -G dba oracle # id oracle

uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) # passwd oracle

(注:确保2个节点gid,uid必须相同) # id nobody

uid=99(nobody) gid=99(nobody) groups=99(nobody) (注:如果nobody用户不存在,则必须创建)

创建挂载点(两个节点执行)

以 root 用户身份执行以下命令: mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle

修改Redhat版本

vi /etc/redhat-release

查找Red Hat Enterprise Linux release 5.7 (Tikanga) 改成Red Hat Enterprise Linux release 4.7 (Tikanga)

修改主机名及/etc/hosts(两个节点执行)

#hostname rac1

#vim /etc/sysconfig/network

---------------------------------------------------------------------------------- NETWORKING=yes NETWORKING_IPV6=no HOSTNAME=rac1

#vim /etc/hosts

----------------------------------------------------------------------------------- # public network

192.168.225.130 rac1 192.168.225.131 rac2 # virtual network

192.168.225.30 rac1-vip 192.168.225.31 rac2-vip # private network 192.168.5.130 rac1-prvip 192.168.5.131 rac2-prvip

检查系统rpm包安装情况(两个节点执行)

rpm -q binutils compat-db control-center gcc gcc-c++ glibc libstdc++ libstdc++-devel make

配置内核参数(两个节点执行)

# cat >> /etc/sysctl.conf << EOF kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144

net.core.wmem_max = 262144 EOF

# sysctl -p ## 使用该命令使上述设置生效

# cat >> /etc/security/limits.conf <

* soft nproc 2047

* hard nproc 16384 * soft nofile 1024 * hard nofile 65536

oracle soft memlock 3145728 oracle hard memlock 3145728 EOF

# cat >> /etc/pam.d/login << EOF

session required /lib/security/pam_limits.so EOF

配置oracle 用户环境变量(两个节点执行)

#su – oracle [以oracle用户登录执行] $vi ./.bash_profile

[$vim /home/oracle/./.bash_profile]

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/CRS export ORACLE_SID=rac1

export

LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORA_CRS_HOME/lib32:$ORACLE_HOME/lib:$ORA_CRS_HOME/lib export

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/jre:/sbin/usr/ccs/bin:/usr/bin/X11:/usr/local/bin:/oracle/CRS/bin:$PATH

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JRE

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:${PATH}:$HOME/bin export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=${PATH}:$ORA_CRS_HOME/bin:/sbin export ORACLE_TERM=xterm umask 022

注:节点2把”export ORACLE_SID= rac1”改成” export ORACLE_S ID= rac2” source .bash_profile [使环境变量生效] echo $ORACLE_HOME [检查环境变量是否正确]

配置安全shell通道(两个节点执行)

在节点一执行 #su - oracle $mkdir .ssh $chmod 700 .ssh $cd .ssh

$ssh-keygen -t rsa --创建密钥,一直回车 $ssh-keygen -t dsa --创建密钥,一直回车 $cat id_rsa.pub >> authorized_keys $cat id_dsa.pub >> authorized_keys

在节点二执行 #su - oracle $mkdir .ssh

$chmod 700 .ssh $cd .ssh

$ssh-keygen -t rsa --创建密钥,一直回车 $ssh-keygen -t dsa --创建密钥,一直回车 $cat id_rsa.pub >> authorized_keys $cat id_dsa.pub >> authorized_keys

$scp authorized_keys oracle@ rac1:/tmp/

在节点一执行

$cat /tmp/authorized_keys >>authorized_keys

$scp authorized_keys oracle@ rac2:/home/oracle/.ssh/authorized_keys

以下步骤两个节点执行 chmod 600 authorized_keys

在rac1验证是否成功,不需要输入密码 #su – oracle $ssh rac1 date $ssh rac1-prvip date $ssh rac2 date $ssh rac2-prvip date

在rac2验证是否成功,不需要输入密码 #su – oracle $ssh rac1 date

$ssh rac1-prvip date $ssh rac2 date

如出现上面错误是10.2.0.1的一个bug,可以忽略

[root@rac1 rootpre]# ./rootpre.sh No OraCM running

安装CRS软件(安装节点执行)

以oracle用户执行

$cd /oracle/install/clusterware $./ runInstaller

手工指定 ORA_CRS_HOME,点击Next

进入Prerequisite Checks页面,确保验证通过,点击Next

进入Specify Cluster Configuration页面,添加第二个节点的相关信息,点击Next

进入Specify Network Interface Usage页面,确保Interface Name,Subnet以及Interface Type相匹配,点击Next

选择External Redundancy,在Specify OCR Location中输入/PNAMWDB_D00/CRS/OcrFile,点击Next

选择External Redundancy,在Voting Disk Location中输入/PNAMWDB_D00/CRS/VotDisk,点击Next

进入Summary页面,确认无误后点击Install

安装中…

安装过程完成之后,需要两个节点各自以root身份运行两个小脚本

以root用户分别在两个节点上去执行以上脚本。

在rac1节点执行orainstRoot.sh:

# /oracle/orainventory/orainstRoot.sh

Changing permissions of /oracle/oraInventory to 770. Changing groupname of /oracle/oraInventory to oinstall. The execution of the script is complete

在rac2节点执行orainstRoot.sh: # /oracle/orainventory/orainstRoot.sh

Changing permissions of /oracle/oraInventory to 770. Changing groupname of /oracle/oraInventory to oinstall. The execution of the script is complete

在rac节点执行/oracle/CRS/root.sh:

#chown –R root:oinstall /PNAMWDB_D00/CRS

在rac2节点执行/oracle/CRS/root.sh:

此处错误是一个oracle bug,需手工在第二节点上图形界面运行vipca。 #cd /oracle/CRS/bin #./vipca

错误1: ./vipca

/oracle/product/10.2.0/crs_1/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory 解决:

在节点2上执行vipca如遇到上述问题,需要编辑两个文件,这两个文件都位于

/oracle/CRS/bin下,文件名分别为vipca和srvctl,需要添加unset LD_ASSUME_KERNEL 一行,具体位置可参考下图:

错误2: ./vipca

Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])]

解决:

需要手工通过ifcfg 进行网络配置

[root@pnamwdb2 bin]# ./oifcfg iflist eth0 192.168.225.0

eth1 192.168.5.0

[root@rac2 bin]# ./oifcfg setif -global eth0/192.168.225.0:public

[root@rac2 bin]# ./oifcfg setif -global eth1/192.168.5.0:cluster_interconnect

[root@rac2 bin]# ./oifcfg getif

eth0 192.168.225.0 global public

eth1 192.168.5.0 global cluster_interconnect 重新运行vipca(以root执行) #cd /oracle/CRS/bin #./vipca

在VIP Configuration Assistant中,按照下图正确设置两个节点的Node name, IP Alias Name,IP address,Subnet Mask,设置完成点击Next

配置中…

本文来源:https://www.bwwdw.com/article/uxkv.html

Top