- 最后登录
- 2014-9-4
- 在线时间
- 60 小时
- 威望
- 87
- 金钱
- 552
- 注册时间
- 2011-10-12
- 阅读权限
- 50
- 帖子
- 35
- 精华
- 1
- 积分
- 87
- UID
- 16
|
1#
发表于 2012-6-12 19:52:42
|
查看: 5762 |
回复: 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
复制代码
问题:监听器是动态注册的,那么使用lsnrctl status 看不到呢 |
|