Oracle multi-port multiple listening configuration
[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, have 1 handler (s) for the 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, have 1 handler (s) for the This service ...
The command completed successfully
Lsnrctl>
http://www.bkjia.com/PHPjc/1079444.html www.bkjia.com true http://www.bkjia.com/PHPjc/1079444.html techarticle Oracle multiport Multi-monitor configuration [oracle@localhost admin]$ more Listener.ora # listener.ora Network configuration File:/oracle/app/or Acle/product/10.2.0/db_1/network/admin/listener ...
