Listener设置
Single db的监听器设置和查看
lsnrctl status- ->察看listener状态
lsnrctl stop - ->关闭listener
lsnrctl start - ->开起listener
Listener配置文件:
Listener Parameter File : /oracle/product/10.2.0/network/admin/listener.ora
RHCS db的监听器设置和查看
lsnrctl status listener_rhcsnode1
lsnrctl status listener_rhcsnode2
LSNRCTL> status listener_rhcsnode1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhcsnode1db1-vip)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias listener_rhcsnode1
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 19-APR-2010 12:11:57
Uptime 22 days 22 hr. 29 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/network/log/listener_rhcsnode1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.178.1.64)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "rhcsnode1" has 2 instance(s).
Instance "rhcsnode1", status UNKNOWN, has 1 handler(s) for this service...
Instance "rhcsnode1", status READY, has 1 handler(s) for this service...
Service "rhcsnode1_XPT" has 1 instance(s).
Instance "rhcsnode1", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@rhcsnode1db1: /home/oracle> more /oracle/product/10.2.0/network/admin/listener.ora
# listener.ora Network Configuration File: /oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER_RHCSNODE2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = rhcsnode2)
(ORACLE_HOME = /oracle/product/10.2.0)
(SID_NAME = rhcsnode2)
)
)
LISTENER_RHCSNODE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhcsnode1db1-vip)(PORT = 1521))
)
LISTENER_RHCSNODE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhcsnode2db1-vip)(PORT = 1521))
)
SID_LIST_LISTENER_RHCSNODE1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = rhcsnode1)
(ORACLE_HOME = /oracle/product/10.2.0)
(SID_NAME = rhcsnode1)
)
)
其他公司的rhcs listener怎样设置呢?
为什么区别开来?
这里用vip好吗 合理吗?
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23490498/viewspace-677052/
,如需转载,请注明出处,否则将追究法律责任。