The listener.ora can be kept simple, doesn't need the SID_LIST. Here's
an example, I'm running just the 8.1.7 listener bound to ports 1521 &
1526. And it listens for 8.1.5 & 8.1.7 databases.
# ----------------------
# Filename: listener.ora
# ----------------------
#
LSNR01 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01))
(ADDRESS= (PROTOCOL= TCP)(Host= egate-ne5.uswc.uswest.com)(Port=
1521))
)
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF
LSNR02 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02))
(ADDRESS= (PROTOCOL= TCP)(Host= egate-ne5.uswc.uswest.com)(Port=
1526))
)
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF
Hamid Alavi wrote:
>
> My problem still NOT solved, I have setup lister817 separatley and check my
> tnsname.ora also when I try to start the listener817 got the listener
> already started message but when I run lsnrctl services , I can not see the
> service in the list.
> My next test is to add the 817 listener to 816 and start it under 816, what
> do you think , any idea?
> I have done all the recommendation from the list but still no hope.
> Thanks all for your support.
>
> -----Original Message-----
> Sent: Monday, April 08, 2002 9:52 AM
> To: Multiple recipients of list ORACLE-L
>
> I joined in a bit late on this thread, so you might have your problem fixed.
> Your SID_LIST_LISTENER entry in the listener.ora should say
> SID_LIST_LISTENER816 and SID_LIST_LISTENER817. When starting the listener,
> do the following:
>
> (w/environment set for 816) lsnrctl start listener816
> (w/environment set for 817) lsnrctl start listener817
>
> In theory, you don't have to specify the sids, because the databases can
> register themselves with the listener, but I have had issues with this, so I
> just use the old sid list method. Which reminds me, you databases will all
> register with the default listener (on port 1521) unless you tell them
> otherwise with this init.ora entry:
>
> local_listener = "(address = (protocol = tcp)(host = gatech-devner1)(port =
> 1522))"
>
> I forget when this local_listener entry was implemented, but I know it is
> there for 8.1.7.
>
> One reason for having different listeners is for running databases in a
> cluster. Depending on how you have your cluster configured, you will need
> at least one listener per node.
>
> Jay Hostetter
> Oracle DBA
> D. & E. Communications
> Ephrata, PA USA
>
> >>> adaryechiel_at_hotmail.com 04/08/02 12:16PM >>>
> Please excuse my idiotic curiosity.
> Why do you need 2 listeners on the same machine?
> I always install the listener of the higher version and disable the previous
> one.
>
> Yechiel Adar. Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Saturday, April 06, 2002 8:08 AM
>
> > Hi,
> >
> > I have two databases ORCL817 and ORCL816 in version
> > 817, 816 on the same machine Sun 5.7. I'd like to
> > configure seperate listener for each database. I used
> > different port, listener name (1521 and LISTENER817
> > for ORCL817 , 1522 and LISTENER816 for ORCL816), but
> > somehow the listener on 1522 cannot be started.
> > Why???
> >
> > Here is the listener.ora and tnsnames.ora for both
> > database:
> >
> > listener.ora for 816
> > =========================
> > LISTENER816 =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 1522))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 2481))
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (GLOBAL_DBNAME = ORCL816)
> > (ORACLE_HOME =
> > /export/apps/oracle/admin/product/8.1.6)
> > (SID_NAME = ORCL816)
> > )
> >
> > tnsnames.ora for 816
> > =========================
> > ORCL816 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 1522))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = ORCL816)
> > )
> > )
> >
> > listener.ora for 817
> > =========================
> > LISTENER817 =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 1521))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 2481))
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (GLOBAL_DBNAME = ORCL817)
> > (ORACLE_HOME =
> > /export/apps/oracle/admin/product/8.1.7)
> > (SID_NAME = ORCL817)
> > )
> > )
> >
> > tnsnames.ora
> > =================
> > ORCL817 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > gatech-denver1)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = ORCL817)
> > )
> > )
> >
> > Anyone knows what went wrong? Thank you!
> >
> > Janet
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jay Hostetter
> INET: jhostetter_at_decommunications.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).
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.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: Suzy Vordos
INET: lvordos_at_qwest.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 Mon Apr 08 2002 - 13:42:34 CDT
