了解下oracle listener 的动态和静态注册
比较下面的输出和参考下面文章,应该能明白吧
不多说了,比较简单,先吃饭再看
http://space.itpub.net/12361284/viewspace-679
$ lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 28-JUN-2008 22:32:46
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hpl3k429)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
Start Date 28-JUN-2008 22:30:49
Uptime 0 days 0 hr. 1 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /var/app/oracle/network/admin/listener.ora
Listener Log File /var/app/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hpl3k429)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test1" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test1XDB" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test1_XPT" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
The command completed successfully
$ cat listener.ora
# listener.ora Network Configuration File: /var/app/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /var/app/oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hpl234)(PORT = 1521))
)
)
$ lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 28-JUN-2008 22:50:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hp1234)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
Start Date 28-JUN-2008 22:49:10
Uptime 0 days 0 hr. 1 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /var/app/oracle/network/admin/listener.ora
Listener Log File /var/app/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hp1234)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test1" has 2 instance(s).
Instance "test1", status UNKNOWN, has 1 handler(s) for this service...
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test1XDB" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test1_XPT" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
The command completed successfully
$ vi listener.ora
"listener.ora" 19 lines, 413 characters
# listener.ora Network Configuration File: /var/app/oracle/network/admin/listene
r.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /var/app/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test1)
(ORACLE_HOME = /var/app/oracle)
(GLOBAL_DBNAME = test1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hp1234)(PORT = 1521))
)
阅读(1665) | 评论(0) | 转发(0) |
