RE: two listeners problem ???

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).