Yes. Here is a template example:
Spfile.ora:
*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ORACLE_SID)))'
listener.ora:
LISTENER_ORACLE_SID=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS = (PROTOCOL = IPC)(KEY = ORACLE_SID))
(ADDRESS= (PROTOCOL= TCP)(HOST= HOSTNAME)(PORT= PORT_NUMBER))
)
)
LISTENER_ORACLE_SID_2 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = HOSTNAME)(Port = PORT_NUMBER_2))
)
SID_LIST_LISTENER_ORACLE_SID_2 =
(SID_LIST =
(SID_DESC= (ORACLE_HOME= ORACLE_HOME) (SID_NAME=ORACLE_SID))
)
Nenad
Homepage: http://nenadnoveljic.com
Twitter: NenadNoveljic
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Beckstrom Jeffrey
Sent: Dienstag, 29. November 2016 13:37
To: oracle-l-freelists; oracle-db-l
Subject: Multiple listeners for a single database
For a database that has a LOCAL_LISTENER init.ora parameter and for which that
listener uses dynamic registration for the database, is it possible to have a
second listener with static information for the same database?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
____________________________________________________
Please consider the environment before printing this e-mail.
Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain
confidential or privileged information. If you are not the named addressee you
should in particular not disseminate, distribute, modify or copy this e-mail.
Please notify the sender immediately by e-mail, if you have received this
message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
processing of incoming e-mails cannot be guaranteed. All liability of the
Vontobel Group and its affiliates for any damages resulting from e-mail use is
excluded. You are advised that urgent and time sensitive messages should not be
sent by e-mail and if verification is required please request a printed
version.<br/>
</p>
</body>
</html>
