Oracle安装报告

Oracle 安装部署手册

中博信息技术研究院有限责任公司

2010年2月

目录

第一章 HACMP的设计与实现 ____________________________________________________ 1

一、拓扑结构示意图_____________________________________________________ 1

二、在每个节点上安装AIX _______________________________________________ 1

1.基本操作系统安装_____________________________________________________ 1

2.rootvg文件系统扩充 ___________________________________________________ 1

三、系统软件包及HACMP软件安装_________________________________________ 2

1.安装架构HACMP所需要的系统软件包___________________________________ 2

2.安装HACMP软件_____________________________________________________ 2

四、网络配置___________________________________________________________ 2

五、rhosts文件设置 ____________________________________________________ 3

六、TTY的配置与测试 ___________________________________________________ 3

七、HACMP热备配置 _____________________________________________________ 3

1.配置卷组、逻辑卷、文件系统___________________________________________ 3

2.创建应用程序启动关闭脚本____________________________________________ 21

3.建立集群____________________________________________________________ 21

4.配置拓扑及通信______________________________________________________ 21

5.配置service ip _______________________________________________________ 22

6.配置应用服务器______________________________________________________ 22

7.配置资源组__________________________________________________________ 22

8.修改资源组__________________________________________________________ 23

9.验证和同步__________________________________________________________ 23

10.启动hacmp ________________________________________________________ 24第二章在HACMP上Oracle10g安装与配置______________________________________ 24

一、检查Oracle10g需要的系统包是否已经安装____________________________ 24

二、创建安装Oracle所需要的组以及用户_________________________________ 24

三、修改内核参数以及shell limits _____________________________________ 25

四、创建Oracle数据库逻辑卷___________________________________________ 26

五、创建安装Oracle软件的本地目录_____________________________________ 26

六、设置Oracle用户的环境变量_________________________________________ 26

七、在两个节点上分别安装Oracle软件并配置 _____________________________ 27

1.节点1： ____________________________________________________________ 27

2.节点2： ____________________________________________________________ 27

第一章HACMP的设计与实现一、拓扑结构示意图

二、在每个节点上安装AIX

1.基本操作系统安装

Aix6.1 64位、

文件系统：jfs2

2.rootvg文件系统扩充

/:2G，

/home:4G

/usr:10G，

/tmp:2G，

/opt:10G

/var:4G

交换分区：32G

三、系统软件包及HACMP软件安装

1.安装架构HACMP所需要的系统软件包

bos.adt、bos.clvm、https://www.wendangku.net/doc/805901031.html,pat、bos.data、bos.perf、X11.Dt、https://www.wendangku.net/doc/805901031.html,pat、rsct.basic、rsct.core、https://www.wendangku.net/doc/805901031.html,pat

2.安装HACMP软件

除cluster.hativoli、cluster.haview外全部安装

四、网络配置

为了保证所有节点上都能够解析所有集群的地址，必须保证每个节点上的/etc/hosts文件有所有节点的本机IP，服务IP和永久IP.

五、rhosts文件设置

完成在hosts下的配置以后进入两个节点的

/usr/es/sbin/cluster/etc/rhosts下编写本节点的本机IP和备用IP，再添加另外一个节点的本机IP和永久IP

六、TTY的配置与测试

在节点1执行#cat < /dev/tty1

在节点2执行#cat /etc/hosts > /dev/tty1

在节点1上看到/etc/hosts内容

七、HACMP热备配置

1.配置卷组、逻辑卷、文件系统

1)在节点1：

a)建立卷组

#Smitty mkvg

Automatically restart 设为no

卷组名：

oravg01/oravg02/oravg03/oravg04/oravg05/oravg06/oravg07/oravg08/orav g09/oravg10/oravg11/oravg12/oravg13

b)创建lv（裸设备）

Oravg01上的lv：

mklv -y tms_redo_1_01 -t raw oravg01 512m mklv -y tms_redo_1_02 -t raw oravg01 512m mklv -y tms_redo_2_01 -t raw oravg01 512m mklv -y tms_redo_2_02 -t raw oravg01 512m mklv -y tms_redo_3_01 -t raw oravg01 512m mklv -y tms_redo_3_02 -t raw oravg01 512m mklv -y tms_confile_01 -t raw oravg01 512m mklv -y tms_confile_02 -t raw oravg01 512m mklv -y tms_confile_03 -t raw oravg01 512m mklv -y tms_system_01 -t raw oravg01 2048m mklv -y tms_sysaux_01 -t raw oravg01 2048m mklv -y tms_pwfile -t raw oravg01 128m mklv -y tms_undo_01 -t raw oravg01 4096m mklv -y tms_undo_02 -t raw oravg01 4096m mklv -y tms_temp_01 -t raw oravg01 4096m mklv -y tms_index_01 -t raw oravg01 512m mklv -y tms_users_01 -t raw oravg01 512m mklv -y tms_tools_01 -t raw oravg01 512m mklv -y tms_spfile_01 -t raw oravg01 512m mklv -y tms_lvora01_001 -t raw oravg01 4096m

mklv -y tms_lvora01_003 -t raw oravg01 4096m mklv -y tms_lvora01_004 -t raw oravg01 4096m mklv -y tms_lvora01_005 -t raw oravg01 4096m mklv -y tms_lvora01_006 -t raw oravg01 4096m mklv -y tms_lvora01_007 -t raw oravg01 4096m mklv -y tms_lvora01_008 -t raw oravg01 4096m mklv -y tms_lvora01_009 -t raw oravg01 4096m mklv -y tms_lvora01_010 -t raw oravg01 4096m mklv -y tms_lvora01_011 -t raw oravg01 4096m mklv -y tms_lvora01_012 -t raw oravg01 4096m mklv -y tms_lvora01_013 -t raw oravg01 4096m mklv -y tms_lvora01_014 -t raw oravg01 4096m mklv -y tms_lvora01_015 -t raw oravg01 4096m mklv -y tms_lvora01_016 -t raw oravg01 4096m mklv -y tms_lvora01_017 -t raw oravg01 4096m mklv -y tms_lvora01_018 -t raw oravg01 4096m mklv -y tms_lvora01_019 -t raw oravg01 4096m Oravg02上的lv：

mklv -y tms_lvora02_001 -t raw oravg02 4096m mklv -y tms_lvora02_002 -t raw oravg02 4096m mklv -y tms_lvora02_003 -t raw oravg02 4096m

mklv -y tms_lvora02_005 -t raw oravg02 4096m mklv -y tms_lvora02_006 -t raw oravg02 4096m mklv -y tms_lvora02_007 -t raw oravg02 4096m mklv -y tms_lvora02_008 -t raw oravg02 4096m mklv -y tms_lvora02_009 -t raw oravg02 4096m mklv -y tms_lvora02_010 -t raw oravg02 4096m mklv -y tms_lvora02_011 -t raw oravg02 4096m mklv -y tms_lvora02_012 -t raw oravg02 4096m mklv -y tms_lvora02_013 -t raw oravg02 4096m mklv -y tms_lvora02_014 -t raw oravg02 4096m mklv -y tms_lvora02_015 -t raw oravg02 4096m mklv -y tms_lvora02_016 -t raw oravg02 4096m mklv -y tms_lvora02_017 -t raw oravg02 4096m mklv -y tms_lvora02_018 -t raw oravg02 4096m mklv -y tms_lvora02_019 -t raw oravg02 4096m mklv -y tms_lvora02_020 -t raw oravg02 4096m mklv -y tms_lvora02_021 -t raw oravg02 4096m mklv -y tms_lvora02_022 -t raw oravg02 4096m mklv -y tms_lvora02_023 -t raw oravg02 4096m mklv -y tms_lvora02_024 -t raw oravg02 4096m mklv -y tms_lvora02_025 -t raw oravg02 3072m

Oravg05上的lv：

mklv -y tms_lvora05_001 -t raw oravg05 4096m mklv -y tms_lvora05_002 -t raw oravg05 4096m mklv -y tms_lvora05_003 -t raw oravg05 4096m mklv -y tms_lvora05_004 -t raw oravg05 4096m mklv -y tms_lvora05_005 -t raw oravg05 4096m mklv -y tms_lvora05_006 -t raw oravg05 4096m mklv -y tms_lvora05_007 -t raw oravg05 4096m mklv -y tms_lvora05_008 -t raw oravg05 4096m mklv -y tms_lvora05_009 -t raw oravg05 4096m mklv -y tms_lvora05_010 -t raw oravg05 4096m mklv -y tms_lvora05_011 -t raw oravg05 4096m mklv -y tms_lvora05_012 -t raw oravg05 4096m mklv -y tms_lvora05_013 -t raw oravg05 4096m mklv -y tms_lvora05_014 -t raw oravg05 4096m mklv -y tms_lvora05_015 -t raw oravg05 4096m mklv -y tms_lvora05_016 -t raw oravg05 4096m mklv -y tms_lvora05_017 -t raw oravg05 4096m mklv -y tms_lvora05_018 -t raw oravg05 4096m mklv -y tms_lvora05_019 -t raw oravg05 4096m mklv -y tms_lvora05_020 -t raw oravg05 4096m mklv -y tms_lvora05_021 -t raw oravg05 4096m

mklv -y tms_lvora05_023 -t raw oravg05 4096m mklv -y tms_lvora05_024 -t raw oravg05 4096m mklv -y tms_lvora05_025 -t raw oravg05 3072m Oravg06上的lv：

mklv -y tms_lvora06_001 -t raw oravg06 4096m mklv -y tms_lvora06_002 -t raw oravg06 4096m mklv -y tms_lvora06_003 -t raw oravg06 4096m mklv -y tms_lvora06_004 -t raw oravg06 4096m mklv -y tms_lvora06_005 -t raw oravg06 4096m mklv -y tms_lvora06_006 -t raw oravg06 4096m mklv -y tms_lvora06_007 -t raw oravg06 4096m mklv -y tms_lvora06_008 -t raw oravg06 4096m mklv -y tms_lvora06_009 -t raw oravg06 4096m mklv -y tms_lvora06_010 -t raw oravg06 4096m mklv -y tms_lvora06_011 -t raw oravg06 4096m mklv -y tms_lvora06_012 -t raw oravg06 4096m mklv -y tms_lvora06_013 -t raw oravg06 4096m mklv -y tms_lvora06_014 -t raw oravg06 4096m mklv -y tms_lvora06_015 -t raw oravg06 4096m mklv -y tms_lvora06_016 -t raw oravg06 4096m mklv -y tms_lvora06_017 -t raw oravg06 4096m

mklv -y tms_lvora06_019 -t raw oravg06 4096m mklv -y tms_lvora06_020 -t raw oravg06 4096m mklv -y tms_lvora06_021 -t raw oravg06 4096m mklv -y tms_lvora06_022 -t raw oravg06 4096m mklv -y tms_lvora06_023 -t raw oravg06 4096m mklv -y tms_lvora06_024 -t raw oravg06 4096m mklv -y tms_lvora06_025 -t raw oravg06 3072m Oravg09上的lv：

mklv -y tms_lvora09_001 -t raw oravg09 4096m mklv -y tms_lvora09_002 -t raw oravg09 4096m mklv -y tms_lvora09_003 -t raw oravg09 4096m mklv -y tms_lvora09_004 -t raw oravg09 4096m mklv -y tms_lvora09_005 -t raw oravg09 4096m mklv -y tms_lvora09_006 -t raw oravg09 4096m mklv -y tms_lvora09_007 -t raw oravg09 4096m mklv -y tms_lvora09_008 -t raw oravg09 4096m mklv -y tms_lvora09_009 -t raw oravg09 4096m mklv -y tms_lvora09_010 -t raw oravg09 4096m mklv -y tms_lvora09_011 -t raw oravg09 4096m mklv -y tms_lvora09_012 -t raw oravg09 4096m mklv -y tms_lvora09_013 -t raw oravg09 4096m

mklv -y tms_lvora09_015 -t raw oravg09 4096m mklv -y tms_lvora09_016 -t raw oravg09 4096m mklv -y tms_lvora09_017 -t raw oravg09 4096m mklv -y tms_lvora09_018 -t raw oravg09 4096m mklv -y tms_lvora09_019 -t raw oravg09 4096m mklv -y tms_lvora09_020 -t raw oravg09 4096m mklv -y tms_lvora09_021 -t raw oravg09 4096m mklv -y tms_lvora09_022 -t raw oravg09 4096m mklv -y tms_lvora09_023 -t raw oravg09 4096m mklv -y tms_lvora09_024 -t raw oravg09 4096m mklv -y tms_lvora09_025 -t raw oravg09 3072m Oravg10上的lv：

mklv -y tms_lvora10_001 -t raw oravg10 4096m mklv -y tms_lvora10_002 -t raw oravg10 4096m mklv -y tms_lvora10_003 -t raw oravg10 4096m mklv -y tms_lvora10_004 -t raw oravg10 4096m mklv -y tms_lvora10_005 -t raw oravg10 4096m mklv -y tms_lvora10_006 -t raw oravg10 4096m mklv -y tms_lvora10_007 -t raw oravg10 4096m mklv -y tms_lvora10_008 -t raw oravg10 4096m mklv -y tms_lvora10_009 -t raw oravg10 4096m

mklv -y tms_lvora10_011 -t raw oravg10 4096m mklv -y tms_lvora10_012 -t raw oravg10 4096m mklv -y tms_lvora10_013 -t raw oravg10 4096m mklv -y tms_lvora10_014 -t raw oravg10 4096m mklv -y tms_lvora10_015 -t raw oravg10 4096m mklv -y tms_lvora10_016 -t raw oravg10 4096m mklv -y tms_lvora10_017 -t raw oravg10 4096m mklv -y tms_lvora10_018 -t raw oravg10 4096m mklv -y tms_lvora10_019 -t raw oravg10 4096m mklv -y tms_lvora10_020 -t raw oravg10 4096m mklv -y tms_lvora10_021 -t raw oravg10 4096m mklv -y tms_lvora10_022 -t raw oravg10 4096m mklv -y tms_lvora10_023 -t raw oravg10 4096m mklv -y tms_lvora10_024 -t raw oravg10 4096m mklv -y tms_lvora10_025 -t raw oravg10 3072m Oravg11上的lv：

mklv -y tms_lvora11_001 -t raw oravg11 4096m mklv -y tms_lvora11_002 -t raw oravg11 4096m mklv -y tms_lvora11_003 -t raw oravg11 4096m mklv -y tms_lvora11_004 -t raw oravg11 4096m mklv -y tms_lvora11_005 -t raw oravg11 4096m

mklv -y tms_lvora11_007 -t raw oravg11 4096m mklv -y tms_lvora11_008 -t raw oravg11 4096m mklv -y tms_lvora11_009 -t raw oravg11 4096m mklv -y tms_lvora11_010 -t raw oravg11 4096m mklv -y tms_lvora11_011 -t raw oravg11 4096m mklv -y tms_lvora11_012 -t raw oravg11 4096m mklv -y tms_lvora11_013 -t raw oravg11 4096m mklv -y tms_lvora11_014 -t raw oravg11 4096m mklv -y tms_lvora11_015 -t raw oravg11 4096m mklv -y tms_lvora11_016 -t raw oravg11 4096m mklv -y tms_lvora11_017 -t raw oravg11 4096m mklv -y tms_lvora11_018 -t raw oravg11 4096m mklv -y tms_lvora11_019 -t raw oravg11 4096m mklv -y tms_lvora11_020 -t raw oravg11 4096m mklv -y tms_lvora11_021 -t raw oravg11 4096m mklv -y tms_lvora11_022 -t raw oravg11 4096m mklv -y tms_lvora11_023 -t raw oravg11 4096m mklv -y tms_lvora11_024 -t raw oravg11 4096m mklv -y tms_lvora11_025 -t raw oravg11 3072m Oravg12上的lv：

mklv -y tms_lvora12_001 -t raw oravg12 4096m

mklv -y tms_lvora12_003 -t raw oravg12 4096m mklv -y tms_lvora12_004 -t raw oravg12 4096m mklv -y tms_lvora12_005 -t raw oravg12 4096m mklv -y tms_lvora12_006 -t raw oravg12 4096m mklv -y tms_lvora12_007 -t raw oravg12 4096m mklv -y tms_lvora12_008 -t raw oravg12 4096m mklv -y tms_lvora12_009 -t raw oravg12 4096m mklv -y tms_lvora12_010 -t raw oravg12 4096m mklv -y tms_lvora12_011 -t raw oravg12 4096m mklv -y tms_lvora12_012 -t raw oravg12 4096m mklv -y tms_lvora12_013 -t raw oravg12 4096m mklv -y tms_lvora12_014 -t raw oravg12 4096m mklv -y tms_lvora12_015 -t raw oravg12 4096m mklv -y tms_lvora12_016 -t raw oravg12 4096m mklv -y tms_lvora12_017 -t raw oravg12 4096m mklv -y tms_lvora12_018 -t raw oravg12 4096m mklv -y tms_lvora12_019 -t raw oravg12 4096m mklv -y tms_lvora12_020 -t raw oravg12 4096m mklv -y tms_lvora12_021 -t raw oravg12 4096m mklv -y tms_lvora12_022 -t raw oravg12 4096m mklv -y tms_lvora12_023 -t raw oravg12 4096m

mklv -y tms_lvora12_025 -t raw oravg12 3072m Oravg13上的lv：

mklv -y tms_lvora13_001 -t raw oravg13 4096m mklv -y tms_lvora13_002 -t raw oravg13 4096m mklv -y tms_lvora13_003 -t raw oravg13 4096m mklv -y tms_lvora13_004 -t raw oravg13 4096m mklv -y tms_lvora13_005 -t raw oravg13 4096m mklv -y tms_lvora13_006 -t raw oravg13 4096m mklv -y tms_lvora13_007 -t raw oravg13 4096m mklv -y tms_lvora13_008 -t raw oravg13 4096m mklv -y tms_lvora13_009 -t raw oravg13 4096m mklv -y tms_lvora13_010 -t raw oravg13 4096m mklv -y tms_lvora13_011 -t raw oravg13 4096m mklv -y tms_lvora13_012 -t raw oravg13 4096m mklv -y tms_lvora13_013 -t raw oravg13 4096m mklv -y tms_lvora13_014 -t raw oravg13 4096m mklv -y tms_lvora13_015 -t raw oravg13 4096m mklv -y tms_lvora13_016 -t raw oravg13 4096m mklv -y tms_lvora13_017 -t raw oravg13 4096m mklv -y tms_lvora13_018 -t raw oravg13 4096m mklv -y tms_lvora13_019 -t raw oravg13 4096m

mklv -y tms_lvora13_021 -t raw oravg13 4096m mklv -y tms_lvora13_022 -t raw oravg13 4096m mklv -y tms_lvora13_023 -t raw oravg13 4096m mklv -y tms_lvora13_024 -t raw oravg13 4096m mklv -y tms_lvora13_025 -t raw oravg13 3072m Oravg03上的lv：

mklv -y rl_redo_1_01 -t raw oravg03 512m mklv -y rl_redo_1_02 -t raw oravg03 512m mklv -y rl_redo_2_01 -t raw oravg03 512m mklv -y rl_redo_2_02 -t raw oravg03 512m mklv -y rl_redo_3_01 -t raw oravg03 512m mklv -y rl_redo_3_02 -t raw oravg03 512m mklv -y rl_confile_01 -t raw oravg03 512m mklv -y rl_confile_02 -t raw oravg03 512m mklv -y rl_confile_03 -t raw oravg03 512m mklv -y rl_system_01 -t raw oravg03 2048m mklv -y rl_sysaux_01 -t raw oravg03 2048m mklv -y rl_pwfile -t raw oravg03 128m mklv -y rl_undo_01 -t raw oravg03 4096m mklv -y rl_undo_02 -t raw oravg03 4096m mklv -y rl_temp_01 -t raw oravg03 4096m

mklv -y rl_index_01 -t raw oravg03 512m mklv -y rl_users_01 -t raw oravg03 512m mklv -y rl_tools_01 -t raw oravg03 512m mklv -y rl_spfile_01 -t raw oravg03 512m mklv -y rl_lvora03_001 -t raw oravg03 4096m mklv -y rl_lvora03_002 -t raw oravg03 4096m mklv -y rl_lvora03_003 -t raw oravg03 4096m mklv -y rl_lvora03_004 -t raw oravg03 4096m mklv -y rl_lvora03_005 -t raw oravg03 4096m mklv -y rl_lvora03_006 -t raw oravg03 4096m mklv -y rl_lvora03_007 -t raw oravg03 4096m mklv -y rl_lvora03_008 -t raw oravg03 4096m mklv -y rl_lvora03_009 -t raw oravg03 4096m mklv -y rl_lvora03_010 -t raw oravg03 4096m mklv -y rl_lvora03_011 -t raw oravg03 4096m mklv -y rl_lvora03_012 -t raw oravg03 4096m mklv -y rl_lvora03_013 -t raw oravg03 4096m mklv -y rl_lvora03_014 -t raw oravg03 4096m mklv -y rl_lvora03_015 -t raw oravg03 4096m mklv -y rl_lvora03_016 -t raw oravg03 4096m mklv -y rl_lvora03_017 -t raw oravg03 4096m mklv -y rl_lvora03_018 -t raw oravg03 4096m

Oravg04上的lv：

mklv -y rl_lvora04_001 -t raw oravg04 4096m mklv -y rl_lvora04_002 -t raw oravg04 4096m mklv -y rl_lvora04_003 -t raw oravg04 4096m mklv -y rl_lvora04_004 -t raw oravg04 4096m mklv -y rl_lvora04_005 -t raw oravg04 4096m mklv -y rl_lvora04_006 -t raw oravg04 4096m mklv -y rl_lvora04_007 -t raw oravg04 4096m mklv -y rl_lvora04_008 -t raw oravg04 4096m mklv -y rl_lvora04_009 -t raw oravg04 4096m mklv -y rl_lvora04_010 -t raw oravg04 4096m mklv -y rl_lvora04_011 -t raw oravg04 4096m mklv -y rl_lvora04_012 -t raw oravg04 4096m mklv -y rl_lvora04_013 -t raw oravg04 4096m mklv -y rl_lvora04_014 -t raw oravg04 4096m mklv -y rl_lvora04_015 -t raw oravg04 4096m mklv -y rl_lvora04_016 -t raw oravg04 4096m mklv -y rl_lvora04_017 -t raw oravg04 4096m mklv -y rl_lvora04_018 -t raw oravg04 4096m mklv -y rl_lvora04_019 -t raw oravg04 4096m mklv -y rl_lvora04_020 -t raw oravg04 4096m

mklv -y rl_lvora04_022 -t raw oravg04 4096m mklv -y rl_lvora04_023 -t raw oravg04 4096m mklv -y rl_lvora04_024 -t raw oravg04 4096m mklv -y rl_lvora04_025 -t raw oravg04 3072m Oravg05上的lv：

mklv -y rl_lvora07_001 -t raw oravg07 4096m mklv -y rl_lvora07_002 -t raw oravg07 4096m mklv -y rl_lvora07_003 -t raw oravg07 4096m mklv -y rl_lvora07_004 -t raw oravg07 4096m mklv -y rl_lvora07_005 -t raw oravg07 4096m mklv -y rl_lvora07_006 -t raw oravg07 4096m mklv -y rl_lvora07_007 -t raw oravg07 4096m mklv -y rl_lvora07_008 -t raw oravg07 4096m mklv -y rl_lvora07_009 -t raw oravg07 4096m mklv -y rl_lvora07_010 -t raw oravg07 4096m mklv -y rl_lvora07_011 -t raw oravg07 4096m mklv -y rl_lvora07_012 -t raw oravg07 4096m mklv -y rl_lvora07_013 -t raw oravg07 4096m mklv -y rl_lvora07_014 -t raw oravg07 4096m mklv -y rl_lvora07_015 -t raw oravg07 4096m mklv -y rl_lvora07_016 -t raw oravg07 4096m