一、环境介绍:

node01和node02组成cluster,已完成cluster配置,如图:

Configure HA for Oracle with Single Instance Oracle ASM_Single

安装的数据库软件oracle 10g r2.oracle的逻辑主机名已经在hosts文件定义,如下所示:

Configure HA for Oracle with Single Instance Oracle ASM_Instance_02

 

二、安装oracle database:

1、只安装oracle database software only:

这里么什么好说的,选择高级安装,只安装oracle database software only,其他一路下一步即可。

Configure HA for Oracle with Single Instance Oracle ASM_ASM_03

安装完成后首先创建监听程序,再创建ASM实例以及数据库实例,然后将oracle主目录打包,传到另一个节点,解压到oracle主目录。

完了后,再另外一个节点以root身份运行$ORACLE_HOME/bin/localconfig add命令,启动crs进程,否则在配置ASM实例时会报错的。

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_04

这个命令在两个节点都要执行的。运行完之后,CSS进程会自动启动的。如果之前运行过crs之类的,运行上述命令会报错的,在其后加个reset即可,如图:

Configure HA for Oracle with Single Instance Oracle ASM_Single_05

2、运行netca配置监听程序:

在其中一个节点执行即可:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_06

Configure HA for Oracle with Single Instance Oracle ASM_Instance_07

Configure HA for Oracle with Single Instance Oracle ASM_Instance_08

Configure HA for Oracle with Single Instance Oracle ASM_Configure_09 

3、运行dbca创建ASM实例:

首先在一个节点创建,创建后使其处于mount状态,然后在另一个节点同样运行dbca,创建ASM.

node02:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_10

Configure HA for Oracle with Single Instance Oracle ASM_Single_11

这里会弹出一个窗口,如下所示:

Configure HA for Oracle with Single Instance Oracle ASM_Single_12

点击OK创建ASM实例。

Configure HA for Oracle with Single Instance Oracle ASM_Single_13

点击create new选项:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_14

如果发现不到磁盘,可以点击右下角的改变磁盘路径,这里使用的did设备,所以路径是/dev/did/rdsk/*,一定要加这个*号,否则磁盘还是不会被发现。

接着点击OK创建磁盘组。

Configure HA for Oracle with Single Instance Oracle ASM_Instance_15

Configure HA for Oracle with Single Instance Oracle ASM_ASM_16

node01:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_17

Configure HA for Oracle with Single Instance Oracle ASM_ASM_18

下一步后,会提示创建新的磁盘组,这里不用创建点击mount all后,会出现一个节点创建的ASM实例,在本节点mount后会处于dismount状态,如图:

Configure HA for Oracle with Single Instance Oracle ASM_Instance_19

点击finish退出向导,然后在node02上运行dbca创建数据库实例。

4、运行dbca创建oracle数据库实例:

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_20

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_21

Configure HA for Oracle with Single Instance Oracle ASM_Configure_22

Configure HA for Oracle with Single Instance Oracle ASM_Single_23

Configure HA for Oracle with Single Instance Oracle ASM_Instance_24

Configure HA for Oracle with Single Instance Oracle ASM_ASM_25

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_26 

接着创建v_$sysstat和v_$archive_dest视图:

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_27

安装完成后,关闭数据库实例以及ASM实例,将/u01目录打包,传到另外一个节点进行解压,解压完成后运行localconfig add程序。

三、配置资源:

这里主要创建两个资源组,一个是asm实例资源组asm-inst-rg,类型是可伸缩的。另一个是asm磁盘组资源组asm-dg-rg,其类型是故障转移,如图:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_28

注册资源类型:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_29

创建scalable ASM实例资源组asm-inst-rg:

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_30

向asm-inst-rg资源组添加资源:

 

 

 

 

Configure HA for Oracle with Single Instance Oracle ASM_ASM_31

启用asm-inst-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_32 

Configure HA for Oracle with Single Instance Oracle ASM_Instance_33

创建asm-dg-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_Single_34

设置asm-dg-rg和asm-inst-rg的同位性:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_35

向asm-dg-rg资源组添加逻辑主机名资源:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_36

创建asm-dg-rs资源:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_37

启用asm-dg-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_38

Configure HA for Oracle with Single Instance Oracle ASM_Single_39

创建oracle实例资源:

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_40

创建监听器资源:

Configure HA for Oracle with Single Instance Oracle ASM_Instance_41

启用资源组:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_42

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_43 

切换下,是否成功:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_44

Configure HA for Oracle with Single Instance Oracle ASM_ASM_45