Home >php教程 >php手册 >Oracle 多端口多监听配置

Oracle 多端口多监听配置

WBOY
WBOYOriginal
2016-06-13 08:49:511005browse

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>


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn