$ORACLE_HOME\network\admin中的listener.ora的配置如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bruce)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1\BIN)
(SID_NAME = bruce)
)
)
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1621))
)
C:\Users\xxxxxxxx>lsnrctl status--默认是listener
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:38:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:27:24
Uptime 0 days 0 hr. 11 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
Service "bruceXDB" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
Service "bruce_XPT" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Users\xxxxxxxx>lsnrctl start listener2
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:39:01
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系统参数文件为E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入E:\oracle\product\10.2.0\db_1\network\log\listener2.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
STATUS of the LISTENER
------------------------
Alias listener2
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:39:07
Uptime 0 days 0 hr. 0 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\xxxxxxxx>lsnrctl status listener2
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:39:15
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
STATUS of the LISTENER
------------------------
Alias listener2
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:39:07
Uptime 0 days 0 hr. 0 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
365
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
