我的编程空间,编程开发者的网络收藏夹
学习永远不晚

OEL安装RAC 配置DNS文档

短信预约 -IT技能 免费直播动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

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

        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文档 OEL安装DNS文档1.docx


免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

OEL安装RAC 配置DNS文档

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

Oracle 12c RAC 安装文档

博客园 首页 新随笔 联系 管理 订阅 随笔- 91  文章- 0  评论- 11  Oracle 12c RAC 安装文档   参考文档
Oracle 12c RAC 安装文档
2018-01-24

Zabbix安装配置文档-Part3.配

一、             添加 Oracle监控Oracle监控也参考zabbix wiki上如下的方法(调用zabora工具):http://www.zabbix.com/wiki/howto/monitor/db/orcale/or
2023-01-31

Linux下如何安装和配置DNS服务器

这篇文章主要介绍“Linux下如何安装和配置DNS服务器”,在日常操作中,相信很多人在Linux下如何安装和配置DNS服务器问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”Linux下如何安装和配置DNS服务器
2023-06-10

hadoop安装文件配置教程

这篇文章主要讲解了“hadoop安装文件配置教程”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“hadoop安装文件配置教程”吧! 1.目前只是单机环境,namenode和datanode都在
2023-06-03

Node.js安装配置图文教程

本文为大家分享了Node.js安装配置教程,供大家参考,具体内容如下1、本安装步骤可参考:http://www.runoob.com/nodejs/nodejs-install-setup.html 2、Node.js安装包及源码下载地址:
2022-06-04

在Linux系统上安装配置DNS服务器的步骤

本篇内容介绍了“在Linux系统上安装配置DNS服务器的步骤”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!简介DNS 是计算机域名系统 (D
2023-06-12

mysql安装之多实例多配置文件安装

一、多实例安装简介 所谓多实例安装其实是指在一台机器上开启多个不同的mysql服务端口(3306,3307),运行多个mysql服务进程,这些服务进程通过不同的socket监听不同的服务端口来提供各自的服务;多实例安装主要目的是为了有效利用服务器资源,但是也存
mysql安装之多实例多配置文件安装
2020-05-22

一文学会 CentOS7 安装配置 Redis

✅作者简介:2022年博客新星 第八。热爱国学的Java后端开发者,修心和技术同步精进。 🍎个人主页:Java Fans的博客 🍊个人信条:不迁怒,不贰过。小知识,大智慧。 💞当前专栏:
2023-08-24

编程热搜

目录