本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