richard

87 积分	0 好友	3 主题

发消息

RAC监听中的问题

1^#

发表于 2012-6-12 19:52:42 | 查看: 5695| 回复: 3

RHEL 5.5 X64

10gR2 RAC node 2

SQL> select * from v$version where rownum<3;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production

=====================================================

$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-JUN-2012 15:53:57
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

复制代码

$ cat /data/oracle/product/10.2.0/db/network/admin/listener.ora
# listener.ora.sjdb1 Network Configuration File: /data/oracle/product/10.2.0/db/network/admin/listener.ora.sjdb1
# Generated by Oracle configuration tools.
LISTENER_SJDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sjdb1_vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.108.15)(PORT = 1521)(IP = FIRST))
)
)
SID_LIST_LISTENER_SJDB1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /data/oracle/product/10.2.0/db)
(PROGRAM = extproc)
)
)

复制代码

show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.108.16)(PORT = 15
21))
remote_listener string LISTENERS_SJDB

复制代码

$ lsnrctl status LISTENER_SJDB1
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 12-JUN-2012 15:56:40
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sjdb1_vip)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SJDB1
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 08-JUN-2012 15:16:28
Uptime 4 days 0 hr. 40 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/oracle/product/10.2.0/db/network/admin/listener.ora
Listener Log File /data/oracle/product/10.2.0/db/network/log/listener_sjdb1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.108.16)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.108.15)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SJDB" has 2 instance(s).
Instance "SJDB1", status READY, has 2 handler(s) for this service...
Instance "SJDB2", status READY, has 1 handler(s) for this service...
Service "SJDBXDB" has 2 instance(s).
Instance "SJDB1", status READY, has 1 handler(s) for this service...
Instance "SJDB2", status READY, has 1 handler(s) for this service...
Service "SJDB_XPT" has 2 instance(s).
Instance "SJDB1", status READY, has 2 handler(s) for this service...
Instance "SJDB2", status READY, has 1 handler(s) for this service...
The command completed successfully