| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Multiple Listeners
It is my understanding that you don't need the;
"SID_LIST_LISTENERDB2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = DBAME2)
(ORACLE_HOME = /path/to/oracle/home)
)
)"
section if you define the "service_names" entry in your init.ora files. You should do one or the other.
Please correct if I'm wrong, but this is how it works on my 8.1.6 instances.
-----Original Message-----
Aschenbrenner
Sent: Monday, July 16, 2001 6:27 PM
To: Multiple recipients of list ORACLE-L
Edward,
Yes, you can setup multiple listeners. Here is an example:
LISTENERDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
)
LISTENERDB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522))
)
SID_LIST_LISTENERDB1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = DBAME1)
(ORACLE_HOME = /path/to/oracle/home)
)
)
SID_LIST_LISTENERDB2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = DBAME2)
(ORACLE_HOME = /path/to/oracle/home)
)
)
After you have set this up, you can start the listeners individually:
lsnrctl start listenerdb1
lsnrctl start listenerdb2
Hope that helps...
Alan
Alan Aschenbrenner
Oracle DBA
IHS Group
alan.aschenbrenner_at_ihs.com
(303)-858-6394
-----Original Message-----
Carr
Sent: Monday, July 16, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box. I have
three
databases on the system with one LISTENER for all of them. Is it
possible
to configure multiple listeners, one for each database? We have tried
in
the past with no success... If there is a document on the web somebody
could
point me to, that would be great! I have searched for one but must not
be
searching correctly.
TIA,
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: alan.aschenbrenner_at_ihs.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: c-glenn.travis_at_wcom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 18 2001 - 09:22:01 CDT
 |
 |