8 安装数据库

runInstaller安装数据库软件。

Dbca创建数据库。

这两步很少出现问题。

完成后，查看cluster状态:

crs_stat –t

Name Type Target State Host

------------------------------------------------------------

ora.rac.db application ONLINE ONLINE rac1

ora....c1.inst application ONLINE ONLINE rac1

ora....c2.inst application ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

9 listener及tnsname配置

在rac2上，listener.ora

LISTENER_RAC2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521)(IP = FIRST))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521)(IP = FIRST))

)

)

SID_LIST_LISTENER_RAC2 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = RAC2)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

)

)

rac1上的listener.ora类似。

Tnsnames.ora

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))

(LOAD_BALANCE = yes)

(FAILOVER =yes )

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rac.oracle.com)

)

)

LISTENERS_RAC =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))

)

RAC2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rac.oracle.com)

(INSTANCE_NAME = rac2)

)

)

RAC1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rac.oracle.com)

(INSTANCE_NAME = rac1)

)

)

LOCAL_RAC =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))

)

登陆到rac1、rac2实例，修改local_listener参数：

alter system set *.local_listener='local_rac' scope=both;

alter system set*. remote_listener= LISTENERS_RAC