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

# 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

umask 022

———————————————————————————————–

su – grid

[grid@rac1 ~]$ vi .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# 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

umask 022

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

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

相关推荐: EXP、EXPDP的不同

1、EXPDP必须要dierctory 2、EXPDP可以导出没有分配空间的空表 3、EXPDP导出过程中会建立一个JOB且会产生一张表SYS_EXPORT_SCHEMA_01 ，导完后又会自动删除，所以 EXPDP无法在read only模式下操作 4…