nfs共享模式搭建rac,监听配置

本rac是使用nfs共享磁盘的方式搭建，$ORACLE_HOME为共享目录，监听配置文件仅一份，共享使用

 

 

1、hosts文件配置

lyrac1 -> cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1    localhost

#public
192.168.77.1    lyrac1
192.168.77.2    lyrac2

#private
192.168.78.1    lyrac1-priv
192.168.78.2    lyrac2-priv

#virtual
192.168.77.11    lyrac1-vip
192.168.77.12    lyrac2-vip

#share
192.168.77.3    share

 

 

2、listener.ora

lyrac1 -> cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_LIUYDB2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac2-vip)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.77.2)(PORT = 1521))
    )
  )

LISTENER_LIUYDB1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac1-vip)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.77.1)(PORT = 1521))
    )
  )

SID_LIST_LISTENER_LIUYDB2 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = liuydb)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
      (SID_NAME = liuydb2)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = liuydb)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
      (SID_NAME = liuydb1)
    )
  )

SID_LIST_LISTENER_LIUYDB1 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = liuydb)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
      (SID_NAME = liuydb1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = liuydb)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
      (SID_NAME = liuydb2)
    )
  )

lyrac1 ->

 

 

3、tnsname.ora

lyrac1 -> cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LIUYDB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = liuydb)
      (INSTANCE_NAME = liuydb2)
    )
  )

LIUYDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = liuydb)
      (INSTANCE_NAME = liuydb1)
    )
  )

LISTENERS_LIUYDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac2-vip)(PORT = 1521))
  )

LIUYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = lyrac2-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = liuydb)
    )
  )

 

4、启动监听

lsnrctl start listener_liuydb1

lsnrctl start listener_liuydb2

记住不要用lsnrctl start