OEL安装RAC 配置DNS文档

来源：这里教程网时间：2026-03-03 12:38:35 作者：

下边有完整的附件 完整文档以及操作流程如下 [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-eth1 编辑两个节点的 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安装RAC 配置DNS文档

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推