Oracle 多端口多监听配置_PHP教程

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>