RE: two listeners problem ???

Hello,

It should not be all that uncommon. We have 7 databases each on our development and test machines that are tied to their production counterparts, and, over time, some of the databases have lagged behind others (lots of reasons for that, esp. mgt. priorities), leaving us with multiple listeners (7.3.4, 8.1.6, and 8.1.7) on some of the machines. It takes a bit longer to recycle, and you have to think a minute before you act, but not too bad.

Thank you,

Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - psherman_at_elcom.com

-----Original Message-----
Sent: Monday, April 08, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L

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
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Janet Linsy
> INET: janetlinsy_at_yahoo.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: Yechiel Adar
  INET: adaryechiel_at_hotmail.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: Sherman, Paul R.
  INET: PSherman_at_elcom.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).