没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
传 DBA 成功之道 授 IT 人立身之业
- 2 -
目录
1. 环境介绍
..............................................................................................................................................................
3
2. 所需介质
..............................................................................................................................................................
3
3. 操作系统信息
......................................................................................................................................................
3
3.1 RAC 节点服务器
....................................................................................................................................
3
3.2 DNS 服务器
.............................................................................................................................................
6
3.3 SAN 服务器
.............................................................................................................................................
7
4. 正式部署安装
......................................................................................................................................................
7
4.1 配置 DNS 服务
........................................................................................................................................
7
4.1.1 安装 bind 三个包
........................................................................................................................
7
4.1.2 配置主区域
..................................................................................................................................
7
4.1.3 给两个节点配置 DNS
...................................................................................................................
9
4.1.4 测试
..............................................................................................................................................
9
4.2 配置/etc/hosts
........................................................................................................................................
10
4.3 系统配置
................................................................................................................................................
11
4.3.1 修改/etc/sysctl.conf
............................................................................................................
11
4.3.2 生效
............................................................................................................................................
11
4.3.3 修改/etc/security/limits.conf
.........................................................................................
11
4.4 配置 YUM 源并安装所需包
................................................................................................................
11
4.4.1 配置 YUM 源
................................................................................................................................
11
4.4.2 将光驱挂载上
............................................................................................................................
12
4.4.3 安装所需包
................................................................................................................................
12
4.5 创建用户和组
........................................................................................................................................
12
4.5.1 创建组
........................................................................................................................................
12
4.5.2 创建用户
....................................................................................................................................
12
4.5.3 设置口令
....................................................................................................................................
12
4.6 创建安装目录以及授权
........................................................................................................................
12
4.7 配置境变量
............................................................................................................................................
12
4.8 Iscsi 挂载磁盘并配置 UDEV
...............................................................................................................
14
4.9 禁用 NTP 服务
......................................................................................................................................
16
4.10 解压介质
............................................................................................................................................
16
4.11 校验
........................................................................................................................................................
17
4.12 安装
....................................................................................................................................................
18
4.12.1 安装 GI
......................................................................................................................................
18
4.12.2 创建 ASM 磁盘组
.......................................................................................................................
32
4.12.3 安装 RDBMS 软件
.......................................................................................................................
34
4.12.4 创建数据库
...............................................................................................................................
40
5. 最终结果
............................................................................................................................................................
50
传 DBA 成功之道 授 IT 人立身之业
- 3 -
1. 环境介绍
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
2. 所需介质
linuxamd64_12c_database_1of2.zip
linuxamd64_12c_database_2of2.zip
linuxamd64_12c_grid_1of2.zip
linuxamd64_12c_grid_2of2.zip
-- 这里只给出 Oracle 相关的,操作系统以及其他软件请自身准备。
3. 操作系统信息
3.1 RAC 节点服务器
(以 node1 节点为例)
[root@12crac1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)
[root@12crac1 ~]# uname -a
Linux 12crac1.luocs.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
传 DBA 成功之道 授 IT 人立身之业
- 4 -
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
传 DBA 成功之道 授 IT 人立身之业
- 5 -
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
剩余64页未读,继续阅读
资源评论
workdinner
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Screenshot_20240427_031602.jpg
- 网页PDF_2024年04月26日 23-46-14_QQ浏览器网页保存_QQ浏览器转格式(6).docx
- 直接插入排序,冒泡排序,直接选择排序.zip
- 在排序2的基础上,再次对快排进行优化,其次增加快排非递归,归并排序,归并排序非递归版.zip
- 实现了7种排序算法.三种复杂度排序.三种nlogn复杂度排序(堆排序,归并排序,快速排序)一种线性复杂度的排序.zip
- 冒泡排序 直接选择排序 直接插入排序 随机快速排序 归并排序 堆排序.zip
- 课设-内部排序算法比较 包括冒泡排序、直接插入排序、简单选择排序、快速排序、希尔排序、归并排序和堆排序.zip
- Python排序算法.zip
- C语言实现直接插入排序、希尔排序、选择排序、冒泡排序、堆排序、快速排序、归并排序、计数排序,并带图详解.zip
- 常用工具集参考用于图像等数据处理
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功