Oracle 10g RAC Release 2 on IBM System p and i Running AIX 5L with SAN Storage
点击数:1144发布日期:2020-05-23 17:03:17 来源:Oracle 10g RAC Release 2 on IBM System p and i Running AIX 5
新闻摘要:Oracle 10g RAC Release 2 on IBM System p and i Running AIX 5L with SAN Storage
黑龙江UNICOM
Oracle10gRAC Release 2 on IBM System p and i Running AIX5Lwith SAN Storage
安装配置指南
目录
TOC \o "1-6" \h \z 1 安装过程的检查和核对工作... PAGEREF _Toc188933324 \h 5
2 配置操作系统的提示信息(在两台主机上操作) PAGEREF _Toc188933325 \h 6
3 系统配置检查(在两台主机上操作) PAGEREF _Toc188933326 \h 6
4 确定AIX版本和补丁--- must be AIX TL 5300-06(在两台主机上操作) PAGEREF _Toc188933327 \h 7
5 检查hacmp 5.3 所需要的FileSets(在两台主机上操作) PAGEREF _Toc188933328 \h 7
6 添加users和groups. PAGEREF _Toc188933329 \h 8
7 配置内核参数和修改shell sLimits(在两台主机上操作) PAGEREF _Toc188933330 \h 8
8 Configure System Configuration Parameters(在两台主机上操作) PAGEREF _Toc188933331 \h 9
9 配置异步 I/O(在两台主机上操作) PAGEREF _Toc188933332 \h 9
10 调整与网络有关的参数(在两台主机上操作) PAGEREF _Toc188933333 \h 9
11 检查系统重启时的配置情况(在两台主机上操作) PAGEREF _Toc188933334 \h 10
12 网络配置有关的工作.... PAGEREF _Toc188933335 \h 10
13 检查hosts文件.... PAGEREF _Toc188933336 \h 11
14 检查default gateway.. PAGEREF _Toc188933337 \h 11
15 节点之间用户等效访问机制的配置(only rsh) PAGEREF _Toc188933338 \h 12
16 配置Oracle 环境变量(在两台主机上操作) PAGEREF _Toc188933339 \h 13
17 Cluster Nodes 间的系统时间同步的配置.... PAGEREF _Toc188933340 \h 13
17.1 Server端的配置... PAGEREF _Toc188933341 \h 13
17.2 Client端的配置... PAGEREF _Toc188933342 \h 14
18 使用CVU确定安装必备的先决条件是否已经具备... PAGEREF _Toc188933343 \h 14
19 runcluvfy.sh工具进行检查.... PAGEREF _Toc188933344 \h 14
19.1 Checking 网络配置... PAGEREF _Toc188933345 \h 15
19.2 Checking 硬件和操作系统的配置... PAGEREF _Toc188933346 \h 15
19.3 Checking 所需要的操作系统的配置... PAGEREF _Toc188933347 \h 15
19.4 Verifying Oracle Clusterware Requirements with CVU.. PAGEREF _Toc188933348 \h 15
19.5 验证是否准备好安装Oracle Database. PAGEREF _Toc188933349 \h 15
20 Clusterware安装.... PAGEREF _Toc188933350 \h 16
20.1 开启X11窗口... PAGEREF _Toc188933351 \h 16
20.2 修改oraparam.ini和cluster.ini文件... PAGEREF _Toc188933352 \h 16
20.3 启动安装CRS. PAGEREF _Toc188933353 \h 16
20.4 运行orainstRoot.sh. PAGEREF _Toc188933354 \h 17
20.5 Specify Home Details. PAGEREF _Toc188933355 \h 17
20.6 Specify Cluster Configuration. PAGEREF _Toc188933356 \h 18
20.7 specify Network interface usage. PAGEREF _Toc188933357 \h 19
20.8 Specify Oracle Cluster Registry(OCR) Location. PAGEREF _Toc188933358 \h 20
20.9 Specify Voting Disk Location. PAGEREF _Toc188933359 \h 21
20.10 其它步骤根据提示进行... PAGEREF _Toc188933360 \h 22
20.11 在安装完成之前执行配置脚本... PAGEREF _Toc188933361 \h 22
21 配置vipca之前对network interface 的核对工作.... PAGEREF _Toc188933362 \h 24
22 开始运行vipca,完成vip的配置工作.... PAGEREF _Toc188933363 \h 25
23 在全部node上修改.profile文件.... PAGEREF _Toc188933364 \h 27
24 验证 CSS misscount 参数.... PAGEREF _Toc188933365 \h 27
25 CRS(Cluster Ready Services)的健康检查工作.... PAGEREF _Toc188933366 \h 28
25.1 在每一个node上检查CRS进程 : PAGEREF _Toc188933367 \h 28
25.2 crs_stat -t. PAGEREF _Toc188933368 \h 28
25.3 olsnodes. PAGEREF _Toc188933369 \h 28
25.4 CRS health check. PAGEREF _Toc188933370 \h 29
25.5 cssd, crsd, evmd health check. PAGEREF _Toc188933371 \h 29
25.6 CRS software version query. PAGEREF _Toc188933372 \h 29
26 Interconnect 网络配置的检查.... PAGEREF _Toc188933373 \h 30
27 OCR content Check.. PAGEREF _Toc188933374 \h 30
27.1 检查ocr的完整性... PAGEREF _Toc188933375 \h 30
27.2 检查 Voting Disks. PAGEREF _Toc188933376 \h 30
28 清除安装失败的CRS. PAGEREF _Toc188933377 \h 31
29 安装CRS 10.2.0.3补丁.... PAGEREF _Toc188933378 \h 32
29.1 停止全部node上的CRS应用... PAGEREF _Toc188933379 \h 32
29.2 停止全部node上的(root用户)CRS. PAGEREF _Toc188933380 \h 32
29.3 crs备份... PAGEREF _Toc188933381 \h 33
29.4 安装patchset. PAGEREF _Toc188933382 \h 33
29.5 CRS 软件版本的检查工作... PAGEREF _Toc188933383 \h 34
30 安装 Oracle 10g R2. PAGEREF _Toc188933384 \h 34
30.1 在全部node上执行... PAGEREF _Toc188933385 \h 35
30.2 安装RDBMS的后续工作... PAGEREF _Toc188933386 \h 35
31 安装rdbms 10.2.0.3补丁.... PAGEREF _Toc188933387 \h 35
32 建库.... PAGEREF _Toc188933388 \h 36
33 启动/停止集群... PAGEREF _Toc188933389 \h 38
33.1 停止 Oracle RAC 10g 环境... PAGEREF _Toc188933390 \h 38
33.2 启动 Oracle RAC 10g 环境... PAGEREF _Toc188933391 \h 38
33.3 使用 SRVCTL 启动/停止所有实例... PAGEREF _Toc188933392 \h 39
34 SQL*NET配置.... PAGEREF _Toc188933393 \h 39
34.1 listener.ora. PAGEREF _Toc188933394 \h 39
34.2 tnsnames.ora. PAGEREF _Toc188933395 \h 40
34.3 示例... PAGEREF _Toc188933396 \h 42
34.3.1 hosts文件的配置... PAGEREF _Toc188933397 \h 42
34.3.2 监听器的配置... PAGEREF _Toc188933398 \h 42
34.3.3 tnsnames.ora文件配置... PAGEREF _Toc188933399 \h 43
35 安装产品测试结果... PAGEREF _Toc188933400 \h 44
36 附录.... PAGEREF _Toc188933401 \h 45
1 安装过程的检查和核对工作
Operations |
Done On Each Node : Yes/No ? |
||
prm1 |
node2 |
||
1 |
Check the Hardware equirements ---硬件环境的检查 |
|
|
2 |
Check the Network Requirements ---软件环境的检查 |
|
|
3 |
Check the Software Requirements ---操作系统软件需求的检查 |
|
|
4 |
Create Required UNIX Groups and User ---group和user的检查 |
|
|
5 |
Configure Kernel Parameters and Shell Limits ---内核参数和shell的限制修改检查 |
|
|
6 |
Identify Required Software Directories ---确定安装目录 |
|
|
7 |
Identify or Create an Oracle Base Directory- --建立oracle_base目录,确定oracle mount点 |
|
|
8 |
Create the CRS Home Directory- --创建ORA_CRS_HOME目录 |
|
|
9 |
Choose a Storage Option for Oracle CRS,Database, and Recovery Files ---为CRS、DATABASE、Recovery Files选择存储类型检查 |
|
|
10 |
Create Directories for Oracle CRS,Database, or Recovery Files ---创建相关目录 |
|
|
11 |
ACCESS Disk Storage concurently from all nodes participating to the RAC cluster ---cluster下全部node并发访问存储的检查,以及相关权限的验证工作 |
|
|
12 |
Synchronize the System Time on Cluster Nodes ---cluster下全部node的时间同步的配置 |
|
|
13 |
Configure the oracle User's Environment ---配置oracle用户环境 |
|
|
2 配置操作系统的提示信息(在两台主机上操作)
# for root export PS1={`hostname`:`who am i | sed 's/ .*$//'`}'$PWD # '
# for oracle export PS1={`hostname`:`who am i | sed 's/ .*$//'`'@$ORACLE_SID}$PWD $ '
# for oracle glogin.sql SQL> set sqlprompt '_connect_identifier> '
|
3 系统配置检查(在两台主机上操作)
检查配置: # prtconf
检查主机名: # hostname
检查内存 [odsdb1:/#]lsattr -El sys0 -a realmem realmem 31850496 Amount of usable physical memory in Kbytes False [odsdb2:/#]lsattr -El sys0 -a realmem realmem 31850496 Amount of usable physical memory in Kbytes False
检查paging space [odsdb1:/#]lsps -a Page Space Physical Volume Volume Group Size %Used Active Auto Type hd6 hdisk0 rootvg 32768MB 1 yes yes lv prm2#[/] lsps -a [odsdb2:/#]lsps -a Page Space Physical Volume Volume Group Size %Used Active Auto Type hd6 hdisk0 rootvg 32768MB 1 yes yes lv
检查/tmp
上一篇:oracle数据库的升级和补丁图文推荐
|