oracle11GR2RACforAIX614完全安装手册XXXX1110.docx资源-CSDN文库

版权申诉

99 浏览量 2022-04-28 16:14:24 上传评论收藏 2.83MB DOCX 举报

资源推荐

资源详情

资源评论

Oracle11gR2 RAC for AIX
目录
主机规划..........................................................................................................................................3
1 硬件环境...............................................................................................................................3
2 软件环境...............................................................................................................................3
3 RAC 拓朴图..........................................................................................................................4
4 网络规划...............................................................................................................................4
4.1 IP 地址要求...............................................................................................................4
4.2 DNS 服务器（可选）...............................................................................................5
5 安装目录规划.......................................................................................................................5
6 存储规划...............................................................................................................................6
6.1 grid、ASM 安装目录................................................................................................6
6.2 Clusterware 安装目录................................................................................................6
6.3 OCR、VOTE 存储规划............................................................................................6
6.4 数据库数据文件存储规划........................................................................................6
安装准备..........................................................................................................................................7
1 系统硬件环境检查...............................................................................................................7
1.1 Oracle11gR2 RAC 最低安装要求：........................................................................7
1.2 验证方法：................................................................................................................7
1.2.1 确认内存大小.................................................................................................7
1.2.2  确认 SWAP 空间，最少 4G。.....................................................................7
1.2.3 确认/tmp 大于 1.5GB 和/oracle 目录空间 15GB..........................................8
1.2.4  确认系统结构................................................................................................8
1.2.5  确认系统 CPU 个数和主频：......................................................................8
2 安装操作系统软件包...........................................................................................................8
2.1 安装 FILESETS.........................................................................................................8
2.2  安装 PATCHES.........................................................................................................9
3 配置 IP 地址........................................................................................................................10
4 修改/etc/hosts 文件.............................................................................................................10
5 文件系统准备.....................................................................................................................11
5.1 方法 1：使用命令创建...........................................................................................11
5.2 方法 2：使用 smit 创建..........................................................................................11
6 调整系统参数.....................................................................................................................13
6.1 打开异步 IO.............................................................................................................13
6.2 调整虚拟内存管理..................................................................................................13
6.3 调整 maxuproc（系统最大进程数）和 ncargs（系统块大小）参数.................14
6.4 调整 SHELL 限制....................................................................................................14
6.5 确认网络配置参数..................................................................................................14
7 创建用户、组.....................................................................................................................15
7.1 要求..........................................................................................................................15
7.2 创建命令：..............................................................................................................16

7.3 修改用户属性..........................................................................................................16
7.3.1 grid 用户.......................................................................................................16
7.3.2 oracle 用户....................................................................................................17
7.3.3 root 用户.......................................................................................................17
8 用户环境变量设置.............................................................................................................18
8.1 grid 用户...................................................................................................................18
8.2 oracle 用户...............................................................................................................19
9 用户 shell 限制....................................................................................................................20
10 创建安装目录并修改权限...............................................................................................20
11 SSH 信任关系设置（可选）...........................................................................................20
11.1 首先在两台机器上安装好 OpenSSH 软件；......................................................20
11.2 然后在 grid 安装中选择自动配置 SSH 双机信任关系......................................21
11.2.1 方法 1..........................................................................................................21
11.2.2 方法 2..........................................................................................................22
12 配置磁盘设备...................................................................................................................22
12.1 设置磁盘属性........................................................................................................22
12.2 修改用于数据库存储的 PV 的属主.....................................................................23
12.3 修改用于数据库存储的 PV 的权限.....................................................................23
12.4 清除 PVID..............................................................................................................23
13 配置 NTP 服务（可选）.................................................................................................23
安装 Grid........................................................................................................................................24
1 Grid 安装前检查.................................................................................................................24
2 执行 rootpre.sh....................................................................................................................24
3 安装 grid..............................................................................................................................24
4 Clusterware 安装校验.........................................................................................................36
安装 Database................................................................................................................................38
创建 ASM 磁盘组..........................................................................................................................45
DBCA 创建数据库........................................................................................................................47
安装完成后....................................................................................................................................55
1 备份 root.sh.........................................................................................................................55
2 重新编译全部 PL/SQL modules........................................................................................55
3 备份 spfile 文件..................................................................................................................55
4 RAC 集群系统维护命令....................................................................................................55
5 启动和关闭集群系统命令.................................................................................................56
5.1 启动集群件和集群数据库......................................................................................56
5.2 关闭 RAC 集群数据库和集群件............................................................................56