以CentOS 6.8系统为例部署Oracle 11g RAC和DNS配置

共计 21103 个字符，预计需要花费 53 分钟才能阅读完成。

本文章以两个节点为例进行安装

在 virtual box 创建虚拟机时，网卡 1 为桥接网卡，网卡二为仅主机模式

创建两块磁盘，模式设置为可共享，都添加到两个虚拟机中

在虚拟介质管理中进行设置

虚拟机的创建明细如下

在两个系统安装完成后，进入 network connection 配置

把动态地址改为静态地址，手动输入地址、子网掩码及网关

将两个节点的公共网卡地址写入 DNS server

 进入 /etc/hosts 写入两个节点的网卡信息

[root@rac01 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.56.101 rac01

192.168.56.102 rac02

192.168.56.111 rac01-vip

192.168.56.112 rac02-vip

192.168.1.142 rac01-priv

192.168.1.109 rac02-priv

192.168.56.156 cluster-scan

配置本地 Yum 源

[root@rac01 Packages]# cd /etc/yum.repos.d/
[root@rac01 yum.repos.d]# ls
CentOS-Base.repo CentOS-Debuginfo.repo CentOS-fasttrack.repo CentOS-Media.repo CentOS-Vault.repo
[root@rac01 yum.repos.d]# rm -rf *

[root@rac01 yum.repos.d]# vi local.repo
[kingsql]
name=This is kingsql repo
baseurl=file:///rpm/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
[root@rac01 yum.repos.d]# mkdir -p /rpm
[root@rac01 yum.repos.d]# cd /rpm

[root@rac01 rpm]cp /root/Packages/* /rpm/

rpm -ivh vsftpd-2.2.2-12.el6_5.1.x86_64.rpm
rpm -ivh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh Python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh libxml2-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh libxml2-python-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh createrepo-0.9.9-22.el6.noarch.rpm

[root@rac01 rpm]# createrepo ./
[root@rac01 rpm]# yum clean all
[root@rac01 rpm]# yum makecache

[root@rac01 rpm]#yum install -y libXp* xterm* unixODBC* sysstat* make* libstdc++* libgomp* libgcc* libaio* kernel-headers* glibc* gcc* elfutils* binutils* bind bind-devel bind-chroot caching-nameserver compat-libcap1* compat-libstdc++-33* openssh* xdpyinfo vi unzip

进行 DNS 配置

vi /etc/named.conf

options {
listen-on port 53 {any;};
directory “/var/named”;
dump-file “/var/named/data/cache_dump.db”;
statistics-file “/var/named/data/named_stats.txt”;
memstatistics-file “/var/named/data/named_mem_stats.txt”;
allow-query {any;};
recursion yes;

dnssec-enable yes;
dnssec-validation yes;

/* Path to ISC DLV key */
bindkeys-file “/etc/named.iscdlv.key”;

managed-keys-directory “/var/named/dynamic”;
};

logging {
channel default_debug {
file “data/named.run”;
severity dynamic;
};
};

zone “.” IN {
type hint;
file “/dev/null”;
};

zone “kingsql.org” IN {
type master;
file “kingsql.org.zone”;
};

zone “56.168.192.in-addr.arpa” {
type master;
file “192.168.56.rev”;
};

[root@rac01 named]# cd /var/named
[root@rac01 named]# pwd
/var/named
[root@rac01 named]# vi kingsql.org.zone
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101

ns2 IN A 192.168.56.102
cluster-scan IN A 192.168.56.156
cluster-scan IN A 192.168.56.157
cluster-scan IN A 192.168.56.158
——————————————————————————————–
[root@rac01 named]# vi 192.168.56.rev
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101

ns2 IN A 192.168.56.102
156 IN PTR cluster-scan.kingsql.org.
157 IN PTR cluster-scan.kingsql.org.
158 IN PTR cluster-scan.kingsql.org.
——————————————————————————————–
service network restart

查看 name server

cat /etc/resolv.conf
# Generated by NetworkManager
nameserver 192.168.56.101

chkconfig named on ## 设置开机自启动

DNS 解析服务启动

service named start
Starting named: [OK]

nslookup cluster-scan.kingsql.org
nslookup 192.168.56.156
nslookup 192.168.56.157
nslookup 192.168.56.158

 补一个 rpm 包 rpm -ivh pdksh-5.2.14-30.x86_64.rpm

禁用防火墙，关闭防火墙服务

chkconfig iptables off
service iptables stop

 修改 selinux/config 内的文件

vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing – SELinux security policy is enforced.
# permissive – SELinux prints warnings instead of enforcing.
# disabled – No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted – Targeted processes are protected,
# mls – Multi Level Security protection.
SELINUXTYPE=targeted

 创建用户和组

groupadd -g 2000 oinstall
groupadd -g 2200 asmadmin
groupadd -g 2201 asmdba
groupadd -g 2202 asmoper
groupadd -g 2300 dba
groupadd -g 2301 oper
useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash -c “Grid Infrastructure Owner” grid
useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/Oracle -s /bin/bash -c “Oracle Software Owner” oracle
passwd grid
passwd oracle

 修改用户和组的权限

mkdir -p /opt/ora11g/grid
mkdir -p /opt/ora11g/11.2.4/grid
chown -R grid:oinstall /opt
mkdir -p /opt/ora11g/oracle
chown oracle:oinstall /opt/ora11g/oracle
chmod -R 775 /opt

切换到 oracle 用户

修改环境变量

注意在配置环境变量时，两个节点的 oracle_sid 是不同的，要记得修改

[oracle@rac1 ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [-f ~/.bashrc]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/opt/ora11g/oracle
export ORACLE_HOME=/opt/ora11g/oracle/product/11.2.4/dbhome_1
export ORACLE_SID=kingsql1 #2 节点是 kingsql2
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=/opt/ora11g/ogg:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/opt/ora11g/ogg:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_DATE_FORMAT=”yyyy-mm-dd HH24:MI:SS”
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
export ORACLE_UNQNAME=kingsql

if [$USER = “oracle”] || [$USER = “grid”]; then
if [$SHELL = “/bin/ksh”]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

切换到 grid 用户

修改环境变量

[grid@rac1 ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [-f ~/.bashrc]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/opt/ora11g/grid
export ORACLE_HOME=/opt/ora11g/11.2.4/grid
export ORACLE_SID=+ASM1 #2 节点是 +ASM2
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

if [$USER = “oracle”] || [$USER = “grid”]; then
if [$SHELL = “/bin/ksh”]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
export LANG=C

切换到 root 用户

修改 sysctl.conf 文件

vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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

将修改从硬盘刷新到内存

/sbin/sysctl -p

修改 /security/limits.conf 文件

vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

修改 pam,d/login 文件
vi /etc/pam.d/login

session required pam_limits.so

关闭 ntpd 时间同步服务

[root@rac1 ~]# service ntpd stop
关闭 ntpd：[失败]
[root@rac1 ~]# chkconfig ntpd off
[root@rac1 ~]# mv /etc/ntp.conf /etc/ntp.conf.original
[root@rac1 ~]# rm -rf /var/run/ntpd.pid

fdisk - l 查看之前添加的两块硬盘的名称

查看这两块硬盘的磁盘号

[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdb
1ATA_VBOX_HARDDISK_VB1274608b-98003b66
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdc
1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0

编写 /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB1274608b-98003b66″, NAME=”asm-disk1″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0″, NAME=”asm-disk2″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″

复制到节点 2

[root@rac1 ~]# scp /etc/udev/rules.d/99-oracle-asmdevices.rules rac02:/etc/udev/rules.d/99-oracle-asmdevices.rules

[root@rac01 ~]# start_udev
Starting udev: [OK]

查看添加好的磁盘

[root@rac1 ~]# ls -l /dev/asm*
brw-rw—- 1 grid asmadmin 8, 16 9 月 18 11:49 /dev/asm-disk1
brw-rw—- 1 grid asmadmin 8, 32 9 月 18 11:49 /dev/asm-disk2

 将 oracle 集群件压缩包传进来，进行解压，安装解压后的集群件 rpm 包

[root@rac01 ~]# mv p13390677_112040_Linux-x86-64_3of7.zip /home/grid/
[grid@rac01 ~]$ cd grid/
[grid@rac01 grid]$ ls
install response runInstaller sshsetup welcome.html
readme.html rpm runcluvfy.sh stage
[grid@rac01 grid]$ cd rpm/
[grid@rac01 rpm]$ ls
cvuqdisk-1.0.9-1.rpm

[grid@rac01 rpm]$ su root
Password:

[root@rac1 ~]# rpm -ivh /home/grid/grid/rpm/cvuqdisk-1.0.9-1.rpm
Preparing… ########################################### [100%]
Using default group oinstall to install package
1:cvuqdisk ########################################### [100%]

 [grid@rac01 grid]$ ./runInstaller  启动集群件安装图形化

选择跳过软件更新

选择安装和配置 oracle grid infrastructure

 选择高级安装

 选择语言

 输入 scan name 和端口号

 添加节点 2

配置 ssh 互信

 选择 oracle ASM 安装

 选择 external 不冗余，选择其中一块硬盘

 设定密码

 选择不使用 IPM

 在安装过程中需要在命令行输入脚本

输入脚本的顺序为：

节点 1：脚本 1

节点 2：脚本 1

节点 1：脚本 2

节点 2：脚本 2

之后完成集群件的安装

启动 asmca

选择 create

 选择不冗余

 选择 mount all

查看 crs 状态（实例与监听，后面启动）

[grid@rac01 ~]$ crsctl status res -t

 注销切换到 Oracle 用户

 启动 Oracle 客户端程序安装

不勾选接受支持（因为不是花钱买的正版呀）

 选择跳过软件更新

 选择仅安装数据库软件

 配置 SSH

 选择语言

 选择企业版

 这个警告是要求 Ping cluster-scan。可略过

 执行安装

分别在节点 1 节点 2 上

执行脚本

/opt/ora11g/oracle/product/11.2.4/dbhome_1/root.sh 

启动 dbca 图形化

create database

 选择 Select all 输入数据库名和 SID

 不勾选

 设定数据库口令

 设定字符集

 勾选第二项执行脚本

 安装完成后，分别在节点一二查看实例名，验证是否安装成功

节点 2Oracle 用户

节点 2grid 用户

节点 1Oracle 用户

节点 1grid 用户

[root@rac01 Packages]# cd /etc/yum.repos.d/
[root@rac01 yum.repos.d]# ls
CentOS-Base.repo CentOS-Debuginfo.repo CentOS-fasttrack.repo CentOS-Media.repo CentOS-Vault.repo
[root@rac01 yum.repos.d]# rm -rf *

[root@rac01 yum.repos.d]# vi local.repo
[kingsql]
name=This is kingsql repo
baseurl=file:///rpm/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
[root@rac01 yum.repos.d]# mkdir -p /rpm
[root@rac01 yum.repos.d]# cd /rpm

[root@rac01 rpm]cp /root/Packages/* /rpm/

rpm -ivh vsftpd-2.2.2-12.el6_5.1.x86_64.rpm
rpm -ivh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh libxml2-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh libxml2-python-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh createrepo-0.9.9-22.el6.noarch.rpm

[root@rac01 rpm]# createrepo ./
[root@rac01 rpm]# yum clean all
[root@rac01 rpm]# yum makecache

[root@rac01 rpm]#yum install -y libXp* xterm* unixODBC* sysstat* make* libstdc++* libgomp* libgcc* libaio* kernel-headers* glibc* gcc* elfutils* binutils* bind bind-devel bind-chroot caching-nameserver compat-libcap1* compat-libstdc++-33* openssh* xdpyinfo vi unzip
——————————————————————————————-
vi /etc/named.conf

options {
listen-on port 53 {any;};
directory “/var/named”;
dump-file “/var/named/data/cache_dump.db”;
statistics-file “/var/named/data/named_stats.txt”;
memstatistics-file “/var/named/data/named_mem_stats.txt”;
allow-query {any;};
recursion yes;

dnssec-enable yes;
dnssec-validation yes;

/* Path to ISC DLV key */
bindkeys-file “/etc/named.iscdlv.key”;

managed-keys-directory “/var/named/dynamic”;
};

logging {
channel default_debug {
file “data/named.run”;
severity dynamic;
};
};

zone “.” IN {
type hint;
file “/dev/null”;
};

zone “kingsql.org” IN {
type master;
file “kingsql.org.zone”;
};

zone “56.168.192.in-addr.arpa” {
type master;
file “192.168.56.rev”;
};

[root@rac01 named]# cd /var/named
[root@rac01 named]# pwd
/var/named
[root@rac01 named]# vi kingsql.org.zone
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101
cluster-scan IN A 192.168.56.156
cluster-scan IN A 192.168.56.157
cluster-scan IN A 192.168.56.158
——————————————————————————————–
[root@rac01 named]# vi 192.168.56.rev
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101
156 IN PTR cluster-scan.kingsql.org.
157 IN PTR cluster-scan.kingsql.org.
158 IN PTR cluster-scan.kingsql.org.
——————————————————————————————–
service network restart

cat /etc/resolv.conf
# Generated by NetworkManager
nameserver 192.168.56.101

chkconfig named on ## 设置开机自启动

service named start
Starting named: [OK]

nslookup cluster-scan.kingsql.org
nslookup 192.168.56.156
nslookup 192.168.56.157
nslookup 192.168.56.158
——————————————————————————————–
rpm -ivh pdksh-5.2.14-30.x86_64.rpm

chkconfig iptables off
service iptables stop

vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing – SELinux security policy is enforced.
# permissive – SELinux prints warnings instead of enforcing.
# disabled – No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted – Targeted processes are protected,
# mls – Multi Level Security protection.
SELINUXTYPE=targeted

groupadd -g 2000 oinstall
groupadd -g 2200 asmadmin
groupadd -g 2201 asmdba
groupadd -g 2202 asmoper
groupadd -g 2300 dba
groupadd -g 2301 oper
useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash -c “Grid Infrastructure Owner” grid
useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c “Oracle Software Owner” oracle
passwd grid
passwd oracle

mkdir -p /opt/ora11g/grid
mkdir -p /opt/ora11g/11.2.4/grid
chown -R grid:oinstall /opt
mkdir -p /opt/ora11g/oracle
chown oracle:oinstall /opt/ora11g/oracle
chmod -R 775 /opt

su – oracle

[oracle@rac1 ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [-f ~/.bashrc]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/opt/ora11g/oracle
export ORACLE_HOME=/opt/ora11g/oracle/product/11.2.4/dbhome_1
export ORACLE_SID=kingsql1 #2 节点是 kingsql2
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=/opt/ora11g/ogg:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/opt/ora11g/ogg:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_DATE_FORMAT=”yyyy-mm-dd HH24:MI:SS”
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
export ORACLE_UNQNAME=kingsql

if [$USER = “oracle”] || [$USER = “grid”]; then
if [$SHELL = “/bin/ksh”]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

su – grid

[grid@rac1 ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [-f ~/.bashrc]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/opt/ora11g/grid
export ORACLE_HOME=/opt/ora11g/11.2.4/grid
export ORACLE_SID=+ASM1 #2 节点是 +ASM2
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

if [$USER = “oracle”] || [$USER = “grid”]; then
if [$SHELL = “/bin/ksh”]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
export LANG=C

———————————————————————————————-

su – root

vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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

/sbin/sysctl -p

vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

vi /etc/pam.d/login

session required pam_limits.so

[root@rac1 ~]# service ntpd stop
关闭 ntpd：[失败]
[root@rac1 ~]# chkconfig ntpd off
[root@rac1 ~]# mv /etc/ntp.conf /etc/ntp.conf.original
[root@rac1 ~]# rm -rf /var/run/ntpd.pid
[root@rac01 ~]# shutdown -h now

——————————————————————————————-[root@rac01 ~]# fdisk -l

vi /etc/udev/rules.d/99-oracle-asmdevices.rules

查磁盘号
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdb
1ATA_VBOX_HARDDISK_VB1274608b-98003b66
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdc
1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdd
1ATA_VBOX_HARDDISK_VBc894130b-2f10eef0
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sde
1ATA_VBOX_HARDDISK_VB58f6ed82-b0dc76dc
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdf
1ATA_VBOX_HARDDISK_VB0e0cbf34-6238f247
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdg
1ATA_VBOX_HARDDISK_VB98788216-29530089

rac1 编写文件然后 copy 到其他节点
vi /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB1274608b-98003b66″, NAME=”asm-disk1″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0″, NAME=”asm-disk2″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBc894130b-2f10eef0″, NAME=”asm-disk3″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB58f6ed82-b0dc76dc”, NAME=”asm-disk4″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB0e0cbf34-6238f247″, NAME=”asm-disk5″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″
KERNEL==”sd*”, SUBSYSTEM==”block”, PROGRAM==”/sbin/scsi_id –whitelisted –replace-whitespace –device=/dev/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB98788216-29530089″, NAME=”asm-disk6″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″

[root@rac1 ~]# scp /etc/udev/rules.d/99-oracle-asmdevices.rules rac02:/etc/udev/rules.d/99-oracle-asmdevices.rules

[root@rac01 ~]# start_udev
Starting udev: [OK]

[root@rac1 ~]# ls -l /dev/asm*
brw-rw—- 1 grid asmadmin 8, 16 9 月 18 11:49 /dev/asm-disk1
brw-rw—- 1 grid asmadmin 8, 32 9 月 18 11:49 /dev/asm-disk2
brw-rw—- 1 grid asmadmin 8, 48 9 月 18 11:49 /dev/asm-disk3
brw-rw—- 1 grid asmadmin 8, 64 9 月 18 11:49 /dev/asm-disk4
brw-rw—- 1 grid asmadmin 8, 80 9 月 18 11:49 /dev/asm-disk5
brw-rw—- 1 grid asmadmin 8, 96 9 月 18 11:49 /dev/asm-disk6

[root@rac01 ~]# mv p13390677_112040_Linux-x86-64_3of7.zip /home/grid/
[grid@rac01 ~]$ cd grid/
[grid@rac01 grid]$ ls
install response runInstaller sshsetup welcome.html
readme.html rpm runcluvfy.sh stage
[grid@rac01 grid]$ cd rpm/
[grid@rac01 rpm]$ ls
cvuqdisk-1.0.9-1.rpm

[grid@rac01 rpm]$ su root
Password:

[root@rac1 ~]# rpm -ivh /home/grid/grid/rpm/cvuqdisk-1.0.9-1.rpm
Preparing… ########################################### [100%]
Using default group oinstall to install package
1:cvuqdisk ########################################### [100%]

——————————————————————————————–
[root@rac01 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.56.101 rac01

192.168.56.111 rac01-vip

192.168.1.229 rac01-priv

192.168.56.156 cluster-scan

[grid@rac01 grid]$ ./runInstaller

[root@rac01 ~]# /opt/ora11g/oraInventory/orainstRoot.sh

[root@rac01 ~]# /opt/ora11g/11.2.4/grid/root.sh

[root@rac01 ~]# su – grid
[grid@rac01 ~]$ crsctl status res -t

[grid@rac01 ~]$ ping cluster-scan.kingsql.org

[root@rac01 ~]# ping rac01-vip

asmca

[root@rac01 ~]# su – oracle
[oracle@rac01 ~]$
[oracle@rac01 ~]$ ls
p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip
[oracle@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_1of7.zip
[oracle@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_2of7.zip

[oracle@rac01 database]$ ./runInstaller

[root@rac01 ~]# /opt/ora11g/oracle/product/11.2.4/dbhome_1/root.sh

[root@rac01 ~]# su – grid
[grid@rac01 ~]$ crsctl status res -t

dbca

[root@rac01 ~]# cd /opt/ora11g/oracle/admin/kingsql/scripts/
[root@rac01 scripts]# ls
cloneDBCreation.sql init.ora postDBCreation.sql
CloneRmanRestore.sql kingsql1.sh postScripts.sql
CreateClustDBViews.sql kingsql1.sql rmanRestoreDatafiles.sql
initkingsqlTemp.ora lockAccount.sql
[root@rac01 scripts]# cat kingsql1.sql

[oracle@rac01 ~]$ sqlplus / as sysdba

SQL> show parameter db_unique
NAME TYPE VALUE
———————————— ———– ——————————
db_unique_name string kingsql
SQL> select instance_name from v$instance;

INSTANCE_NAME
—————-
kingsql1

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rac01 ~]$ exit
logout
[root@rac01 scripts]# su – grid
[grid@rac01 ~]$ crsctl status res 0t
CRS-2613: Could not find resource ‘0t’.
[grid@rac01 ~]$ crsctl status res -t
——————————————————————————–
NAME TARGET STATE SERVER STATE_DETAILS
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
ONLINE ONLINE rac01
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ora.OCR.dg
ONLINE ONLINE rac01
ora.asm
ONLINE ONLINE rac01 Started
ora.gsd
OFFLINE OFFLINE rac01
ora.net1.network
ONLINE ONLINE rac01
ora.ons
ONLINE ONLINE rac01
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac01
ora.cvu
1 ONLINE ONLINE rac01
ora.kingsql.db
1 ONLINE ONLINE rac01 Open
ora.oc4j
1 ONLINE ONLINE rac01
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.scan1.vip
1 ONLINE ONLINE rac01
ora.scan2.vip
1 ONLINE ONLINE rac01
ora.scan3.vip
1 ONLINE ONLINE rac01

[grid@rac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 15 00:59:29 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter db_unique

NAME TYPE VALUE
———————————— ———– ——————————
db_unique_name string +ASM
SQL> select instance_name from v$instance;

INSTANCE_NAME
—————-
+ASM1

SQL> quit

：