今天在客户碰到一问题
,在这里记录一下:
/etc/hosts文件配置为
引用
127.0.0.1 localhost loopback # loopback (lo0) name/address
#public network
192.200.31.3 hisdb01
192.200.31.4 hisdb02
#virtual ip address
192.200.31.19 hisdb01_vip
192.200.31.20 hisdb02_vip
#private network used for rac
10.0.0.1 hisdb01_priv
10.0.0.2 hisdb02_priv
listener.ora文件配置为
引用
LISTENER_HISDB02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hisdb02_vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.200.31.4)(PORT = 1521)(IP = FIRST))
)
)
SID_LIST_LISTENER_HISDB02 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/products/rdbms)
(PROGRAM = extproc)
)
)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_HISDB02=OFF
INBOUND_CONNECT_TIMEOUT_ =0
PREFER_LEAST_LOADED_NODE_LISTENER_LISTENER_HISDB02=OFF
主机上监听状态显示
引用
oracle.orcl2@hisdb02:/home/oracle$lsnrctl status listener
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 05-FEB-
2010 10:58:49
Copyright (c) 1991, 2005,
Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1
.0 - Production
Start Date 03-FEB-2010 16:00:32
Uptime 1 days 18 hr. 58 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/products/rdbms/network/admin/listener.ora
Listener Log File /oracle/products/rdbms/network/log/listener.log
Listening Endpoints Summary..