一、环境介绍:

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

Configure HA for Oracle with Single Instance Oracle ASM_Configure

安装的数据库软件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_ASM_04

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

Configure HA for Oracle with Single Instance Oracle ASM_Instance_05

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

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

Configure HA for Oracle with Single Instance Oracle ASM_Configure_06

Configure HA for Oracle with Single Instance Oracle ASM_Single_07

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_08

Configure HA for Oracle with Single Instance Oracle ASM_Single_09 

3、运行dbca创建ASM实例:

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

node02:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_10

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_11

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

Configure HA for Oracle with Single Instance Oracle ASM_ASM_12

点击OK创建ASM实例。

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_13

点击create new选项:

Configure HA for Oracle with Single Instance Oracle ASM_Instance_14

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

接着点击OK创建磁盘组。

Configure HA for Oracle with Single Instance Oracle ASM_Configure_15

Configure HA for Oracle with Single Instance Oracle ASM_Instance_16

node01:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_17

Configure HA for Oracle with Single Instance Oracle ASM_Single_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_Single_20

Configure HA for Oracle with Single Instance Oracle ASM_ASM_21

Configure HA for Oracle with Single Instance Oracle ASM_ASM_22

Configure HA for Oracle with Single Instance Oracle ASM_Single_23

Configure HA for Oracle with Single Instance Oracle ASM_Configure_24

Configure HA for Oracle with Single Instance Oracle ASM_Single_25

Configure HA for Oracle with Single Instance Oracle ASM_Configure_26 

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

Configure HA for Oracle with Single Instance Oracle ASM_Configure_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_Oracle_29

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

Configure HA for Oracle with Single Instance Oracle ASM_ASM_30

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

 

 

 

 

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_31

启用asm-inst-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_32 

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_33

创建asm-dg-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_34

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

Configure HA for Oracle with Single Instance Oracle ASM_Oracle_35

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

Configure HA for Oracle with Single Instance Oracle ASM_Single_36

创建asm-dg-rs资源:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_37

启用asm-dg-rg资源组:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_38

Configure HA for Oracle with Single Instance Oracle ASM_Instance_39

创建oracle实例资源:

Configure HA for Oracle with Single Instance Oracle ASM_Single_40

创建监听器资源:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_41

启用资源组:

Configure HA for Oracle with Single Instance Oracle ASM_ASM_42

Configure HA for Oracle with Single Instance Oracle ASM_Configure_43 

切换下,是否成功:

Configure HA for Oracle with Single Instance Oracle ASM_Configure_44

Configure HA for Oracle with Single Instance Oracle ASM_ASM_45