Oracle 多端口多监听配置
时间:2015-12-16 18:37 来源:linux.it.net.cn 作者:IT
Oracle 多端口多监听配置
[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
SID_LIST_LISTENER2 =
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Ora10)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 108.88.3.93)(PORT = 1522))
)
)
LISTENER2 =
( DESCRIPTION =
(ADDRESS = (HOST = 108.88.3.93)(PROTOCOL = TCP)(PORT = 1523))
)
[oracle@localhost admin]$
[oracle@localhost admin]$ lsnrctl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2015 06:05:37
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start LISTENER2
Starting /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))
Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER2
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 10-DEC-2015 06:05:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))
Services Summary...
Service "Ora10" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status LISTENER2
Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER2
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 10-DEC-2015 06:05:44
Uptime 0 days 0 hr. 0 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523)))
Services Summary...
Service "Ora10" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
(责任编辑：IT)
| Oracle 多端口多监听配置 [oracle@localhost admin]$ more listener.ora # listener.ora Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) ) SID_LIST_LISTENER2 = ( SID_LIST = (SID_DESC = (GLOBAL_DBNAME = Ora10) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 108.88.3.93)(PORT = 1522)) ) ) LISTENER2 = ( DESCRIPTION = (ADDRESS = (HOST = 108.88.3.93)(PROTOCOL = TCP)(PORT = 1523)) ) [oracle@localhost admin]$ [oracle@localhost admin]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-DEC-2015 06:05:37 Copyright (c) 1991, 2005, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> start LISTENER2 Starting /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523))) Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523))) STATUS of the LISTENER ------------------------ Alias LISTENER2 Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 10-DEC-2015 06:05:44 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523))) Services Summary... Service "Ora10" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> status LISTENER2 Connecting to (DESCRIPTION=(ADDRESS=(HOST=108.88.3.93)(PROTOCOL=TCP)(PORT=1523))) STATUS of the LISTENER ------------------------ Alias LISTENER2 Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 10-DEC-2015 06:05:44 Uptime 0 days 0 hr. 0 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oracle/app/oracle/product/10.2.0/db_1/network/log/listener2.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=108.88.3.93)(PORT=1523))) Services Summary... Service "Ora10" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> (责任编辑：IT) |