本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
