OEL安装RAC 配置DNS文档
下边有完整的附件
完整 文档以及操作流程如下
[root@rac01 ~]# cd OracleLinux-R6-U6-Server-x86_64-dvd/
[root@rac01 OracleLinux-R6-U6-Server-x86_64-dvd]# ls
EFI GPL LoadBalancer README-en.html RELEASE-NOTES-x86_64-en.html ResilientStorage Server
EULA HighAvailability media.repo RELEASE-NOTES-en RELEASE-NOTES-x86-en RPM-GPG-KEY supportinfo
eula.en_US images Packages RELEASE-NOTES-en.html RELEASE-NOTES-x86-en.html RPM-GPG-KEY-oracle TRANS.TBL
eula.py isolinux README-en RELEASE-NOTES-x86_64-en repodata ScalableFileSystem UEK3
[root@rac01 OracleLinux-R6-U6-Server-x86_64-dvd]# cd Packages/
[root@rac01 Packages]# cd /etc/yum.repos.d/
[root@rac01 yum.repos.d]# ls
public-yum-ol6.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
[root@rac01 yum.repos.d]# mkdir -p /rpm
[root@rac01 yum.repos.d]# cd /rpm
[root@rac01 rpm] cp /root/OracleLinux-R6-U6-Server-x86_64-dvd/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
rpm -ivh ksh-20120801-21.el6.x86_64.rpm
[root@rac01 rpm]# createrepo ./
Spawning worker 0 with 3848 pkgs
Workers Finished
Gathering worker results
Saving Primary metadata
Saving file lists metadata
Saving other metadata
Generating sqlite DBs
Sqlite DBs complete
[root@rac01 rpm]#
[root@rac01 rpm]# yum clean all kill -9 结束进程的
[root@rac01 rpm]# yum makecache
[root@rac01 rpm]#yum install 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
[root@rac01 rpm]#yum install 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
yum install oracle-database-server-11gR2-preinstall -y
--------------------------------------------------------------------------------------------
首先选择网卡是桥接网络仅主机静态的并且把 dns 网络写上
vi /etc/sysconfig/network-scripts/ifcfg-eth2 编辑两个节点的 DNS 配置 两个 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.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
ns2 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
chkconfig named on
service named start
nslookup cluster-scan.kingsql.org
nslookup 192.168.56.156
nslookup 192.168.56.157
nslookup 192.168.56.158
-------------------------------------------------------------------------------------------- 不配 DNS 一下
[root@rac01 ~]# chkconfig iptables off
[root@rac01 ~]# service iptables stop
[root@rac01 ~]# vi /etc/selinux/config
groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 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 /u01/app/grid
mkdir -p /u01/app/11.2.4/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
----------------------------------------------------------------------------------------------
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=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.4/dbhome_1
export ORACLE_SID=kingsql
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=/u01/app/ogg:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/u01/app/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
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=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.4/grid
export ORACLE_SID=+ASM1
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
----------------------------------------------------------------------------------------------
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
[root@rac01 ~]# /sbin/sysctl -p
----------------------------------------------------------------------------------------------
[root@rac01 ~]# 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
[root@rac01 ~]# vi /etc/pam.d/login
session required pam_limits.so
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.222 rac01-priv
192.168.1.231 rac02-priv
192.168.56.158 cluster-scan
192.168.56.158 rac-cluster-scan 以上网址自己根据自己网址更改
[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.105 rac01
192.168.56.106 rac02
192.168.56.111 rac01-vip
192.168.56.112 rac02-vip
192.168.1.221 rac01-priv
192.168.1.238 rac02-priv
192.168.56.158 cluster-scan 以上网址自己根据自己网址更改
[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 关机 虚拟机创建磁盘 （磁盘设置成共享模式）
一个 12g 一个 30g 两块磁盘
-------------------------------------------------------------------------------------------- 、
[root@rac01 ~]# 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
[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 到其他节点
/etc/udev/rules.d/99-oracle-asmdevices.rules
[root@rac01 ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="", NAME="asm-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="", 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_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", SYMLINK+="asm-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
// 这里是用 2 种方式绑定的 UDEV ，可以选择其中一个即可，不要完全照抄
[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@rac01 ~]# ls -l /dev/asm*
brw-rw---- 1 grid asmadmin 8, 16 5 月 17 12:09 /dev/asm-diskb
lrwxrwxrwx 1 root root 3 5 月 17 12:09 /dev/asm-diskc -> sdc
[root@rac01 ~]# mv p13390677_112040_Linux-x86-64_3of7.zip /home/grid/
--------------------------------------------------------------------------------------------
su - grid
--------------------------------------------------------------------------------------------
[grid@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_3of7.zip
[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%]
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
su - grid
[grid@rac01 grid]$ ./runInstaller
脚本二运行时间较长
[root@rac01 ~]# /opt/ora11g/oraInventory/orainstRoot.sh 执行脚本 需要在 rac01 执行完 第一条脚本后，在 rac02 在执行第一个脚本
[root@rac02 ~]# /opt/ora11g/oraInventory/orainstRoot.sh
[root@rac01 ~]# /opt/ora11g/11.2.4/grid/root.sh 执行脚本 需要在 rac01 执行完 第二条脚本后，在 rac02 在执行第二个脚本
[root@rac02 ~]# /opt/ora11g/11.2.4/grid/root.sh
[root@rac01 ~]# su - grid
[grid@rac01 ~]$ crsctl status res -t
[grid@rac01 ~]$ ping cluster-scan
[root@rac01 ~]# ping rac01-vip
[grid@rac01 grid]$ 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
--------------------------------------------------------------------------------------------
[oracle@rac01 ~]$ dbca
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
[
[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
OEL安装DNS文档1.docx
