Centos7.0安装oracle rac 11.2.0.4

最新推荐文章于 2023-12-13 22:27:17 发布

一只行走鸟

最新推荐文章于 2023-12-13 22:27:17 发布

阅读量1.3k

点赞数

文章标签： linux

本文链接：https://blog.csdn.net/weixin_40368523/article/details/105952075

版权

Centos7.0安装oracle rac 11.2.0.4

一、安装前的准备：
   安装包：
   采用企业版：两个为oracle的软件安装包第三个为grid的安装包
百度盘链接：https://pan.baidu.com/s/1Gal4MO-m_BA1nyigpmveNg 提取码：75iz
   硬件环境：
      Cpu 56核心
      内存: 512G
      共享存储： 4T
   网络环境：
      注意：未安装之前vip和scan ip不能ping通，公共ip和vip、scan ip为同一网段
      oracle1
         public ip:172.26.68.83
         virtual ip:172.26.68.84
         private ip:172.16.122.253
      oracle2
         public ip:172.26.68.85
         virtual ip:172.26.68.86
      private ip:172.16.122.254

scan ip:172.26.68.87

二、系统环境
[root@node1 ~]# uname -a

Linux node1 3.10.0-123.el7.x86_64 #1 SMP Mon Jun 30 12:09:22 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

[root@node1 ~]# cat /etc/redhat-release

CentOS Linux release 7.0.1406 (Core)

关闭防火墙并更改selinux配置文件

systemctl stop firewalld
systemctl disable firewalld
sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/’ /etc/selinux/config

配置好网络环境可以参考host文件
关闭时间服务器，并更改配置文件名称。采用集群自带的时间服务器
三、host文件修改
[root@node1 ~]# vi /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#Public-IP
172.26.68.83 node1
172.26.68.85 node2
#Private-IP
172.16.122.253 node1-priv
172.16.122.254 node2-priv
#Virtual-IP
172.26.68.84 node1-vip
172.26.68.86 node2-vip
#Scan-IP
172.26.68.87 rac-scan

四、配置用户组

groupadd -g 1010 oinstall
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1022 asmoper
groupadd -g 1031 dba
groupadd -g 1032 oper
useradd -u 1100 -g oinstall -G dba,asmoper,asmadmin,asmdba -d /home/grid -m grid
useradd -u 1101 -g oinstall -G oper,dba,asmdba -d /home/oracle -m oracle
echo “grid:grid”|chpasswd
echo “oracle:oracle”|chpasswd

五、配置安装目录

mkdir -p /u01/app/grid
mkdir -p /u01/app/11.2/grid
mkdir -p /u01/app/oracle/product/11.2/db_1
chown -R grid:oinstall /u01
chmod -R 775 /u01/app
chown -R oracle:oinstall /u01/app/oracle

六、配置nslookup解析,否则在安装grid做最后校验时会报scanip解析问题
节点1
mv /usr/bin/nslookup /usr/bin/nslookup.bak
vi /usr/bin/nslookup
#!/bin/bash
HOSTNAME=${1}
if [[ $HOSTNAME = “scanip” ]]; then
echo “Server: 172.26.68.84”
echo “Address: 172.26.68.84#53”
echo “Non-authoritative answer:”
echo “Name: rac-scan”
echo "Address: 172.26.68.87 "
else
/usr/bin/nslookup.original $HOSTNAME
fi

chmod 755 /usr/bin/nslookup
nslookup rac-scan
节点2
mv /usr/bin/nslookup /usr/bin/nslookup.bak
vi /usr/bin/nslookup
#!/bin/bash
HOSTNAME=${1}
if [[ $HOSTNAME = “scanip” ]]; then
echo “Server: 172.26.68.86”
echo “Address: 172.26.68.86 #53”
echo “Non-authoritative answer:”
echo “Name: rac-scan”
echo "Address: 172.26.68.87 "
else
/usr/bin/nslookup.original $HOSTNAME
fi

权限及测试

chmod 755 /usr/bin/nslookup
nslookup rac-scan

注意：以下磁盘为虚机的磁盘状态：可以在测试的时候参考（之后的udev和asmlib都是测试环境的状态）
七、配置磁盘
[root@node1 ~]# fdisk -l

Disk /dev/sda: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00045fb6

Device Boot Start End Blocks Id System
/dev/sda1 * 1 26 204800 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 26 281 2048000 82 Linux swap / Solaris
Partition 2 does not end on cylinder boundary.
/dev/sda3 281 2356 16669696 83 Linux
/dev/sda4 2356 2611 2048000 5 Extended
/dev/sda5 2356 2611 2046976 83 Linux

Disk /dev/sdb: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00056199

Device Boot Start End Blocks Id System

Disk /dev/sdc: 27.9 GB, 27917287424 bytes
255 heads, 63 sectors/track, 3394 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
[root@node1 ~]# fdisk /dev/sdb

WARNING: DOS-compatible mode is deprecated. It’s strongly recommended to
switch off the mode (command ‘c’) and change display units to
sectors (command ‘u’).

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1): 1
Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610):
Using default value 2610

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@node2 ~]# mkfs.ext4 /dev/sdb1
[root@node1 ~]# vi /etc/fstab
/dev/sdb1 /u01 ext4 defaults 0 0
[root@node1 ~]# mount /u01
八、修改内核参数
[root@node1 ~]# vi /etc/sysctl.conf 添加以下内容

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 50331648
kernel.shmmax = 59055800320
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 1048576
net.core.wmem_max = 2097152
net.core.netdev_max_backlog = 3000
net.core.somaxconn = 20480
net.core.optmem_max = 81920
vm.max_map_count=262144
net.ipv4.tcp_mem = 513920 2097152 4194304
net.ipv4.tcp_rmem = 256960 1048576 2097152
net.ipv4.tcp_wmem = 256960 1048576 2097152
net.ipv4.tcp_keepalive_time = 1800
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_sack = 1
net.ipv4.tcp_fack = 1
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_max_syn_backlog = 8192

[root@node1 ~]# sysctl -p
八、配置oracle和grid的用户资源额
[root@node1 ~]# vi /etc/security/limits.conf

oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 58982400
oracle soft memlock 58982400
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
grid hard memlock 3355443
grid soft memlock 3355443

[root@node1 ~]# cat /etc/pam.d/login

session required /lib64/security/pam_limits.so

九、修改变量环境
[root@node1 ~]# vi /etc/profile

if [ $USER = "oracle" ]||[ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
export PATH=$PATH:/u01/11.2.0/grid/bin

十、修改Oracle和grid用户的环境变量

[oracle@node1 ~]$ vi .bash_profile

export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=node1      #node2上改为node2
export ORACLE_SID=racdb1                    #node2上改为 racdb2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
export ORACLE_UNQNAME=racdb				#node1&node2一定要保持一致
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
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
export EDITOR=vi
export LANG=en_US
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
umask 022

[oracle@node1 ~]$ su - grid
[grid@node1 ~]$ vi .bash_profile

export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=+ASM1                       #node2上改为 +ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2/grid
export ORACLE_TERM=xterm
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
export TNS_ADMIN=$ORACLE_HOME/network/admin
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
export EDITOR=vi	
export LANG=en_US
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
umask 022

同理node2做同样配置
十一、配置共享存储

注意：以下是用的两种方式管理asm磁盘可以任选一种
[root@node1 ~]# fdisk /dev/sdc
…
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
Last cylinder or +size or +sizeM or +sizeK (1-3263, default 3263): +1024M
…
Command (m for help): n
Command action
e extended
p primary partition (1-4)
e
Partition number (1-4): 2
First cylinder (126-3263, default 126):
Using default value 126
Last cylinder or +size or +sizeM or +sizeK (126-3263, default 3263):
Using default value 3263
…
Command (m for help): n
Command action
l logical (5 or over)
p primary partition (1-4)
l
First cylinder (126-3263, default 126):
Using default value 126
Last cylinder or +size or +sizeM or +sizeK (126-3263, default 3263): +1024M
按照这个步骤，一共分三个 1GB，两个 5GB 和两个 3GB 的扩展磁盘。这里的实验分区结果
如下，最后多了点磁盘，也一块分区，不浪费。
十一、安装asm的软件包

[root@node2 ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo 下载阿里云的镜像
[root@node1 ~]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm
warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing… ########################################### [100%]
1:oracleasmlib ########################################### [100%]
[root@node1 ~]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm
warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing… ########################################### [100%]
package oracleasm-support-2.1.8-1.el6.x86_64 is already installed
[root@node1 ~]# yum install oracleasm -y 7.0和7.1没有这个包我采用的yum安装的
Node2也安装这几个包
十三、配置oracleasm

执行此过程先重启系统
[root@node2 ~]# service oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets (’[]’). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]
Fdisk -l对应编辑
Device Boot Start End Blocks Id System
/dev/sdc1 1 132 1060258+ 83 Linux
/dev/sdc2 133 3394 26202015 5 Extended
/dev/sdc5 133 264 1060258+ 83 Linux
/dev/sdc6 265 396 1060258+ 83 Linux
/dev/sdc7 397 1034 5124703+ 83 Linux
/dev/sdc8 1035 1672 5124703+ 83 Linux
/dev/sdc9 1673 2055 3076416 83 Linux
/dev/sdc10 2056 2438 3076416 83 Linux
/dev/sdc11 2439 3394 7679038+ 83 Linux
service oracleasm createdisk OCR_VOTE1 /dev/sdc1
service oracleasm createdisk OCR_VOTE2 /dev/sdc5
service oracleasm createdisk OCR_VOTE3 /dev/sdc6
service oracleasm createdisk ASM_DATA1 /dev/sdc7
service oracleasm createdisk ASM_DATA2 /dev/sdc8
service oracleasm createdisk ASM_FLA1 /dev/sdc9
service oracleasm createdisk ASM_FLA2 /dev/sdc10

Asm的磁盘情况
[root@node2 ~]# service oracleasm listdisks
ASM_DATA1
ASM_DATA2
ASM_FLA1
ASM_FLA2
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
[root@node2 ~]#
十四、建立oracle asm磁盘

第一次测试用udev管理asm
添加五块盘
识别不到磁盘的uuid 在.vmx文件添加disk.EnableUUID =“TRUE”
for i in c d e f g
do
echo “KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==”/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i", SYMLINK+=“asm-disk$i”,OWNER=“grid”, GROUP=“asmadmin”,MODE=“0660"” >>/etc/udev/rules.d/99-oracle-asmdevices.rules
done

/sbin/partprobe /dev/sdc
/sbin/partprobe /dev/sdd
/sbin/partprobe /dev/sde
/sbin/partprobe /dev/sdf
/sbin/partprobe /dev/sdg

/sbin/udevadm test /sys/block/sdc
/sbin/udevadm test /sys/block/sdd
/sbin/udevadm test /sys/block/sde
/sbin/udevadm test /sys/block/sdf
/sbin/udevadm test /sys/block/sdg

[root@ol7-122-rac1 ~]# /sbin/udevadm control --reload-rules

[root@ol7-122-rac1 ~]# ll /dev/asm*
lrwxrwxrwx 1 root root 3 Apr 19 17:15/dev/asm-diskc -> sdc
lrwxrwxrwx 1 root root 3 Apr 19 17:16/dev/asm-diskd -> sdd
lrwxrwxrwx 1 root root 3 Apr 19 17:16/dev/asm-diske -> sde
lrwxrwxrwx 1 root root 3 Apr 19 17:16/dev/asm-diskf -> sdf
lrwxrwxrwx 1 root root 3 Apr 19 17:16/dev/asm-diskg -> sdg

[root@ol7-122-rac1 ~]# ll /dev/sd*
brw-rw---- 1 root disk 8, 0 Apr 19 16:47 /dev/sda
brw-rw---- 1 root disk 8, 1 Apr 19 16:47 /dev/sda1
brw-rw---- 1 root disk 8, 2 Apr 19 16:47 /dev/sda2
brw-rw---- 1 root disk 8, 3 Apr 19 16:47 /dev/sda3
brw-rw---- 1 root disk 8, 16 Apr 19 16:47 /dev/sdb
brw-rw---- 1 root disk 8, 17 Apr 19 16:47 /dev/sdb1
brw-rw---- 1 grid asmadmin 8, 32 Apr 1917:18 /dev/sdc
brw-rw---- 1 grid asmadmin 8, 48 Apr 1917:18 /dev/sdd
brw-rw---- 1 grid asmadmin 8, 64 Apr 1917:18 /dev/sde
brw-rw---- 1 grid asmadmin 8, 80 Apr 1917:18 /dev/sdf
brw-rw---- 1 grid asmadmin 8, 96 Apr 1917:18 /dev/sdg

十五、建立互信

[root@node1 ~]# su– oracle
[oracle@node1 ~]$ mkdir .ssh
[root@node2 ~]# su– oracle
[oracle@node2 ~]$ mkdir .ssh
[oracle@node1 ~]$ ssh-keygen -t rsa
…回车下去…
[oracle@node1 ~]$ ssh-keygen -t dsa
…回车下去…
[oracle@node2 ~]$ ssh-keygen -t rsa
…回车下去…
[oracle@node2 ~]$ ssh-keygen -t dsa
…回车下去…
[oracle@node1 ~]$ cat .ssh/id_rsa.pub>>.ssh/authorized_keys
[oracle@node1 ~]$ cat .ssh/id_dsa.pub>>.ssh/authorized_keys
[oracle@node1 ~]$ ssh node2 cat .ssh/id_rsa.pub>>.ssh/authorized_keys
[oracle@node1 ~]$ ssh node2 cat .ssh/id_dsa.pub>>.ssh/authorized_keys
[oracle@node1 ~]$ scp .ssh/authorized_keys node2:~/.ssh
下面开始相互建立，对自己和对 node2 一起通信。
[oracle@node1 ~]$ ssh node2 date
[oracle@node1 ~]$ ssh node2-priv date
[oracle@node1 ~]$ ssh node1 date
[oracle@node1 ~]$ ssh node1-priv date
同样，在 node2 也做这些操作
[oracle@node2 ~]$ ssh node1 date
[oracle@node2 ~]$ ssh node1-priv date
[oracle@node2 ~]$ ssh node2 date
[oracle@node2 ~]$ ssh node2-priv date
再切入 grid 用户，再次做以上操作。
[oracle@node1 ~]$ su– grid
[grid@node1 ~]$ mkdir .ssh
[oracle@node2 ~]$ su– grid
[grid@node2 ~]$ mkdir .ssh
[grid@node1 ~]$ ssh-keygen -t rsa
[grid@node1 ~]$ ssh-keygen -t dsa
[grid@node2 ~]$ ssh-keygen -t rsa
[grid@node2 ~]$ ssh-keygen -t dsa
[grid@node1 ~]$ cat .ssh/id_rsa.pub >> .ssh/authorized_keys
[grid@node1 ~]$ cat .ssh/id_dsa.pub >> .ssh/authorized_keys
[grid@node1 ~]$ ssh node2 cat .ssh/id_rsa.pub >> .ssh/authorized_keys
[grid@node1 ~]$ ssh node2 cat .ssh/id_dsa.pub >> .ssh/authorized_keys
[grid@node1 ~]$ scp .ssh/authorized_keys node2:~/.ssh
[grid@node1 ~]$ ssh node2 date
[grid@node1 ~]$ ssh node2-priv date
[grid@node1 ~]$ ssh node1 date
[grid@node1 ~]$ ssh node1-priv date
[grid@node2 ~]$ ssh node1 date
[grid@node2 ~]$ ssh node1-priv date
[grid@node2 ~]$ ssh node2 date
[grid@node2 ~]$ ssh node2-priv date

十五、安装grid软件

安装依赖包
yum install compat-libstdc+±33 compat-libcap1 gcc gcc-c++ libgomp elfutils-libelf-devel glibc-devel glibc-headers libaio-devel libstdc+±devel sysstat unixODBC unixODBC-devel -y
以下是监测需要的32位的包，去下载以下相应的包网上能找到一整套
在这里插入图片描述
[root@node1 soft]# rpm -ivh --nodeps --force *.rpm
解压软件
[root@node1 ~]# cd /usr/local/src/grid/rpm
[root@node1 rpm]# rpm -ivh cvuqdisk-1.0.7-1.rpm 拷贝到node2下执行
[grid@node1 grid]$ ./runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose >/tmp/1.txt 检查
[grid@node1 grid]$ ./runInstaller
在这里插入图片描述

这里可能会出现路径或者权限的问题

在这里插入图片描述

按顺序执行脚本 node1、node2
执行./root.sh的时候打开另外的终端执行[root@node1 ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
重新执行./root.sh需要清除历史记录
/u01/11.2.0/grid/crs/install/rootcrs.pl -verbose -deconfig -force
/u01/11.2.0/grid/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode
按照提示在 node1 和 node2 中分别跑两个脚本
在这里插入图片描述

看见；两个节点执行完后点ok

安装结束
检查状态：
检查集群节点：
[grid@node1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
检查 Clusterware 资源：
[grid@node1 ~]$ crs_stat -t
Name Type Target State Host

ora…ER.lsnr ora…er.type ONLINE ONLINE node1
ora…N1.lsnr ora…er.type ONLINE ONLINE node1
ora.OVDATA.dg ora…up.type ONLINE ONLINE node1
ora.asm ora.asm.type ONLINE ONLINE node1
ora.cvu ora.cvu.type ONLINE ONLINE node1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora…network ora…rk.type ONLINE ONLINE node1
ora…SM1.asm application ONLINE ONLINE node1
ora…E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip ora…t1.type ONLINE ONLINE node1
ora…SM2.asm application ONLINE ONLINE node2
ora…E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip ora…t1.type ONLINE ONLINE node2
ora.oc4j ora.oc4j.type ONLINE ONLINE node1
ora.ons ora.ons.type ONLINE ONLINE node1
ora.scan1.vip ora…ip.type ONLINE ONLINE node1
检查集群节点：
[grid@node1 ~]$ olsnodes -n
node1 1
node2 2
确认针对 Oracle Clusterware 文件的 Oracle ASM 功能：
如果在 Oracle ASM 上安装了 OCR 和表决（仲裁）磁盘文件，则以 Grid Infrastructure 安装所有者的身份，使用下面的命令语法来确认当前正在运行已安装的 Oracle ASM：
[grid@node1 ~]$ srvctl status asm -a
ASM is running on node2,node1
ASM is enabled.
检查 Oracle 集群注册表 (OCR)：
[grid@node1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2592
Available space (kbytes) : 259528
ID : 608872705
Device/File Name : +OVDATA
Device/File integrity check succeeded

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

 Cluster registry integrity check succeeded

 Logical corruption check bypassed due to non-privileged user

检查表决磁盘：
[grid@node1 ~]$ crsctl query css votedisk
##STATE File Universal Id File Name Disk group

ONLINE 959652292dfc4fecbf590b4fc47e6fd6 (/dev/mapper/ORACLE-lv_ocrvote1) [OVDATA]
ONLINE 775a3d10318b4fadbf0238d8eaed460e (/dev/mapper/ORACLE-lv_ocrvote2) [OVDATA]
ONLINE 7afe1a60f09c4f4ebf4a641c60d810c4 (/dev/mapper/ORACLE-lv_ocrvote3) [OVDATA]
Located 3 voting disk(s).
验证工作结束，不要忘了在node2上也进行上述验证！
配置ASM，为数据和快速恢复区创建 ASM 磁盘组：（只在node1做）
登录grid用户
[grid@node1 ~]$ asmca

在这里插入图片描述

完成
创建数据库
[oracle@node1 src]$ cd database/
[oracle@node1 database]$ ./runInstaller

在这里插入图片描述

遇到一个未公开的bug 19692824
解决方法：

忽略 Oracle 11.2.0.4安装过程中的 undefined symbol error 错误并继续安装，软件安装过程将会在没有错误的情况下成功结束
下载并安装patch 19692824
为11.2.0.4的HOME设置诸如ORACLE_HOME, PATH等等的环境变量，并使用下面的命令来重新编译失败的target
$ make -f $ORACLE_HOME/sysman/lib/ins_emagent.mk agent nmhs

执行脚本
在这里插入图片描述

建库
[oracle@node1 ~]$ dbca

在这里插入图片描述

密码Admin123
在这里插入图片描述

密码是安装grid asm的密码 Admin123
在这里插入图片描述

建议不要选enable archiving 会增加20分钟建库时间
在这里插入图片描述

点击ok
在这里插入图片描述

注意：85%进度出现警告(如下)，可以忽略。主要是10.2.0.4补丁建议em访问方式改为https而不是原来的http；
如果想要使用https方式，请根据警告提示的步骤去执行。
在这里插入图片描述

验证
[oracle@node1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2018 14:10:09

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 08-MAY-2018 11:51:53
Uptime 0 days 2 hr. 18 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.26.68.83)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.26.68.84)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for this service…
Service “racdb” has 1 instance(s).
Instance “racdb1”, status READY, has 1 handler(s) for this service…
Service “racdbXDB” has 1 instance(s).
Instance “racdb1”, status READY, has 1 handler(s) for this service…
The command completed successfully
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 8 14:11:36 2018

Connected to:
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

SQL>

一只行走鸟

关注

0
点赞
踩
6

收藏

觉得还不错? 一键收藏
0
评论
Centos7.0安装oracle rac 11.2.0.4

Centos7.0安装oracle rac 11.2.0.4一、安装前的准备：   安装包：   采用企业版：两个为oracle的软件安装包第三个为grid的安装包   硬件环境：      Cpu 56核心 &...
复制链接

扫一扫