易网时代-编程资源站

首页 / 数据库 / MySQL / Oracle Enterprise Linux 6.4安装Oracle Database 12C RAC图文详细教程

Oracle Database 12c发布也有一周了，这几天尝试了下单机、RESTART和RAC的安装，其中发生了不少趣事。比如安装Oracle 12c Restart花费了4小时多最终笔记本死机、RAC安装过程中采用HAIP特性却失败等等。Oracle 12c RAC引入了Flex Cluster的概念，但我尚未研究成功。下面是传统方式安装Oracle 12c RAC的教程。Oracle 单实例从32位迁移到 64位方法 http://www.linuxidc.com/Linux/2012-03/55759.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle RAC 11.2（12C）正确关闭顺序 http://www.linuxidc.com/Linux/2014-05/101346.htm环境介绍OS: Oracle Enterprise Linux 6.4 （For RAC Nodes），Oracle Enterprise Linux 5.8（For DNS Server），Openfiler 2.3（For SAN Storage）DB: GI and Database 12.1.0.1所需介质linuxamd64_12c_database_1of2.ziplinuxamd64_12c_database_2of2.ziplinuxamd64_12c_grid_1of2.ziplinuxamd64_12c_grid_2of2.zip– 这里只给出Oracle相关的，操作系统以及其他软件请自身准备。操作系统信息RAC节点服务器:（以node1节点为例）
[root@12crac1 ~]# cat /etc/RedHat-release
Red Hat Enterprise Linux Server release 6.4 （Santiago）[root@12crac1 ~]# uname -a
Linux 12crac1.linuxidc.com 2.6.39-400.17.1.el6uek.x86_64 #1 SMP Fri Feb 22 18:16:18 PST 2013 x86_64 x86_64 x86_64 GNU/Linux[root@12crac1 ~]# grep MemTotal /proc/meminfo
MemTotal: 2051748 kB[root@12crac1 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 5119996 kB[root@12crac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 45G 16G 27G 38% /
tmpfs 2.0G 652M 1.4G 32% /dev/shm
/dev/sda1 194M 50M 135M 27% /boot 网络配置信息：备注：从下面信息中可以发现，每个节点服务器我都添加了五个网卡，eth0用于PUBLIC，而eth1~eth4用于Private，本想采用HAIP特性。但我在安装实验过程中HAIP特性上发生了节点2无法启动ASM实例的问题，因此最后只用了其中eth1接口。至于HAIP导致的问题，可能是出于BUG，这个问题还有待仔细troubleshooting。（节点1）
[root@12crac1 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:75:36:ED
inet addr:192.168.1.150 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe75:36ed/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:64 errors:0 dropped:0 overruns:0 frame:0
TX packets:56 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:7014 （6.8 KiB） TX bytes:6193 （6.0 KiB）eth1 Link encap:Ethernet HWaddr 00:0C:29:75:36:F7
inet addr:192.168.80.150 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe75:36f7/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:12 errors:0 dropped:0 overruns:0 frame:0
TX packets:12 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:720 （720.0 b） TX bytes:720 （720.0 b）eth2 Link encap:Ethernet HWaddr 00:0C:29:75:36:01
inet addr:192.168.80.151 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe75:3601/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:9 errors:0 dropped:0 overruns:0 frame:0
TX packets:10 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:540 （540.0 b） TX bytes:636 （636.0 b）eth3 Link encap:Ethernet HWaddr 00:0C:29:75:36:0B
inet addr:192.168.80.152 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe75:360b/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:5 errors:0 dropped:0 overruns:0 frame:0
TX packets:10 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:300 （300.0 b） TX bytes:636 （636.0 b）eth4 Link encap:Ethernet HWaddr 00:0C:29:75:36:15
inet addr:192.168.80.153 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe75:3615/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1 errors:0 dropped:0 overruns:0 frame:0
TX packets:9 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:60 （60.0 b） TX bytes:566 （566.0 b）lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 （0.0 b） TX bytes:0 （0.0 b）（节点2）
[root@12crac2 ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:A1:81:7C
inet addr:192.168.1.151 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fea1:817c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:126 errors:0 dropped:0 overruns:0 frame:0
TX packets:62 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:10466 （10.2 KiB） TX bytes:6193 （6.0 KiB）eth1 Link encap:Ethernet HWaddr 00:0C:29:A1:81:86
inet addr:192.168.80.154 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fea1:8186/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:23 errors:0 dropped:0 overruns:0 frame:0
TX packets:27 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2081 （2.0 KiB） TX bytes:1622 （1.5 KiB）eth2 Link encap:Ethernet HWaddr 00:0C:29:A1:81:90
inet addr:192.168.80.155 Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fea1:8190/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1 errors:0 dropped:0 overruns:0 frame:0
TX packets:10 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:60 （60.0 b） TX bytes:636 （636.0 b）eth3 Link encap:Ethernet HWaddr 00:0C:29:A1:81:9A
inet addr:192.168.80.156 Bcast:192.168.80.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 （0.0 b） TX bytes:0 （0.0 b）eth4 Link encap:Ethernet HWaddr 00:0C:29:A1:81:A4
inet addr:192.168.80.157 Bcast:192.168.80.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 （0.0 b） TX bytes:0 （0.0 b）lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 （0.0 b） TX bytes:0 （0.0 b）确认防火墙和SELinux是禁用的（以Node1为例，两个节点相同）
[root@12crac1 ~]# iptables -L
Chain INPUT （policy ACCEPT）
target prot opt source destination Chain FORWARD （policy ACCEPT）
target prot opt source destination Chain OUTPUT （policy ACCEPT）
target prot opt source destination 如果防火墙没禁用，那么通过如下方式修改：
[root@12crac1 ~]# service iptables stop
[root@12crac1 ~]# chkconfig iptables off[root@12crac1 ~]# getenforce
Disabled如果SELinux没有被禁止，那就通过如下方式修改：
[root@12crac1 ~]# cat /etc/selinux/config
-- 改成SELINUX=disabled
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted DNS服务器：[root@dns12c ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.8 （Tikanga）[root@dns12c ~]# uname -a
Linux dns12c.linuxidc.com 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux[root@dns12c ~]# grep MemTotal /proc/meminfo
MemTotal: 494596 kB[root@dns12c ~]# grep SwapTotal /proc/meminfo
SwapTotal: 3277252 kB[root@dns12c ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:7A:FD:82
inet addr:192.168.1.158 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:114941 errors:0 dropped:0 overruns:0 frame:0
TX packets:6985 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:11015974 （10.5 MiB） TX bytes:1151788 （1.0 MiB）lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:104 errors:0 dropped:0 overruns:0 frame:0
TX packets:104 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:9531 （9.3 KiB） TX bytes:9531 （9.3 KiB）Iptables和SELinux也禁止。 SAN服务器：Openfiler 2.3来部署的，在这里分配3个LUN，大小分别为5G和两个8G。正式部署安装1、配置DNS服务以下操作在DNS服务器上进行：安装bind三个包
[root@dns12c ~]# rpm -ivh /mnt/Server/bind-9.3.6-20.P1.el5.x86_64.rpm
[root@dns12c ~]# rpm -ivh /mnt/Server/bind-chroot-9.3.6-20.P1.el5.x86_64.rpm
[root@dns12c ~]# rpm -ivh /mnt/Server/caching-nameserver-9.3.6-20.P1.el5.x86_64.rpm配置主区域
[root@dns12c ~]# cd /var/named/chroot/etc
[root@dns12c etc]# cp -p named.caching-nameserver.conf named.conf
[root@dns12c etc]# cat named.conf
options {
listen-on port 53 { any; };
listen-on-v6 port 53 { ::1; };
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"; // Those options should be used carefully because they disable port
// randomization
// query-source port 53;
// query-source-v6 port 53; allow-query { any; };
allow-query-cache { any; };
};
logging {
channel default_debug {
file "data/named.run";
severity dynamic;
};
};
view any_resolver {
match-clients { any; };
match-destinations { any; };
recursion yes;
include "/etc/named.zones";
};

[root@dns12c etc]# cp -p named.rfc1912.zones named.zones
[root@dns12c etc]# cat named.zones
zone "linuxidc.com" IN {
type master;
file "linuxidc.com.zone";
allow-update { none; };
};zone "1.168.192.in-addr.arpa" IN {
type master;
file "1.168.192.local";
allow-update { none; };
};
[root@dns12c ~]# cd /var/named/chroot/var/named
[root@12crac1 named]# cp -p named.zero linuxidc.com.zone
[root@12crac1 named]# cp -p named.local 1.168.192.local
[root@12crac1 named]# cat linuxidc.com.zone
$TTL 86400
@ IN SOA dns.linuxidc.com. root.linuxidc.com. （
42 ; serial （d. adams）
3H ; refresh
15M ; retry
1W ; expiry
1D ） ; minimum
IN NS dns.linuxidc.com.
scan IN A 192.168.1.154
scan IN A 192.168.1.155
scan IN A 192.168.1.156
gns IN A 192.168.1.157
12crac1 IN A 192.168.1.150
12crac2 IN A 192.168.1.151[root@12crac1 named]# cat 1.168.192.local
$TTL 86400
@ IN SOA dns.linuxidc.com. root.linuxidc.com. （
1997022700 ; Serial
28800 ; Refresh
14400 ; Retry
3600000 ; Expire
86400 ） ; Minimum
IN NS dns.linuxidc.com.
154 IN PTR scan.linuxidc.com.
155 IN PTR scan.linuxidc.com.
156 IN PTR scan.linuxidc.com.
157 IN PTR gns.linuxidc.com. nslookup或 dig检查给两个节点配置DNS（以Node1为例，两个节点相同）
[root@12crac1 ~]# cat /etc/resolv.conf
#domain localdomain
search localdomain
nameserver 192.168.1.158 测试：[root@12crac1 ~]# nslookup scan.linuxidc.com
Server: 192.168.1.158
Address: 192.168.1.158#53Name: scan.linuxidc.com
Address: 192.168.1.156
Name: scan.linuxidc.com
Address: 192.168.1.154
Name: scan.linuxidc.com
Address: 192.168.1.155[root@12crac1 ~]# nslookup 192.168.1.154
Server: 192.168.1.158
Address: 192.168.1.158#53154.1.168.192.in-addr.arpa name = scan.linuxidc.com.[root@12crac1 ~]# nslookup 192.168.1.155
Server: 192.168.1.158
Address: 192.168.1.158#53155.1.168.192.in-addr.arpa name = scan.linuxidc.com.[root@12crac1 ~]# nslookup 192.168.1.156
Server: 192.168.1.158
Address: 192.168.1.158#53156.1.168.192.in-addr.arpa name = scan.linuxidc.com. 2、配置/etc/hosts修改/etc/hosts文件，前两行不懂，添加hostname对应信息。（以Node1为例，两个节点相同）
[root@12crac1 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6# For Public
192.168.1.150 12crac1.linuxidc.com 12crac1
192.168.1.151 12crac2.linuxidc.com 12crac2# For VIP
192.168.1.152 12crac1-vip.linuxidc.com 12crac1-vip.linuxidc.com
192.168.1.153 12crac2-vip.linuxidc.com 12crac2-vip.linuxidc.com# For Private IP
192.168.80.150 12crac1-priv1.linuxidc.com 12crac1-priv1
192.168.80.151 12crac1-priv2.linuxidc.com 12crac1-priv2
192.168.80.152 12crac1-priv3.linuxidc.com 12crac1-priv3
192.168.80.153 12crac1-priv4.linuxidc.com 12crac1-priv4
192.168.80.154 12crac2-priv1.linuxidc.com 12crac2-priv1
192.168.80.155 12crac2-priv2.linuxidc.com 12crac2-priv2
192.168.80.156 12crac2-priv3.linuxidc.com 12crac2-priv3
192.168.80.157 12crac2-priv4.linuxidc.com 12crac2-priv4# For SCAN IP
# 192.168.1.154 scan.linuxidc.com
# 192.168.1.155 scan.linuxidc.com
# 192.168.1.155 scan.linuxidc.com# For DNS Server
192.168.1.158 dns12c.linuxidc.com dns12c更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-11/109542p2.htm

1
2
3
4
5
6
7
8
9..
12
下一页

Oracle 12C 数据库管理小结如何在Ubuntu 14.04 LTS上安装MariaDB相关资讯 Oracle 12c

RedHat Enterprise Linux7.0安装（今 12:59）
Oracle 12C 新特性-扩展数据类型（07月16日）
Oracle Enterprise Manager Cloud （04月10日）

Oracle 12C 新特性-表分区或子分区（07月16日）
Oracle 12c中如何自动启动PDB （04月10日）
在OEL6.4上安装Oracle Database （04月10日）

本文评论查看全部评论（0）