REDHAT AS5虚拟机 安装oracle 10g rac (六）

描述REDHAT AS5虚拟机上安装oracle 10g RAC的过程[@more@]

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/56630/viewspace-1035698/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/56630/viewspace-1035698/