RE: listener

From: Nelson, Allan <anelson_at_midf.com>
Date: Wed, 16 Jul 2003 13:59:11 -0500
Message-Id: <25937.338115@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C34BCC.57BCF7B7
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

I do not believe that you can have a listener on box a and a database on box b. Listeners monitor for connections on their indicated port. They then fork and exec a server process for the connection. In this sense the RDBMS never talks to the listener. The listener is responsible to manage the communications.
=20

Allan

	-----Original Message-----
	From: oramagic_at_hotmail.com [mailto:oramagic_at_hotmail.com]=20
	Sent: Wednesday, July 16, 2003 2:44 PM
	To: Multiple recipients of list ORACLE-L
	Subject: listener

=09
=09

Is it possible to have listner running on box a while databases running on X,Y,Z . If yes , then how does oracle instance find the address of the box running the listner , if I configure ini.ora with service_name . Does it mean that local tnsnames.ora file ( on server X,Y,Z) should haave an entry for this service_name .=20

	=20
	-ak
	=20


______________________________________________________________________________

This email is intended solely for the person or entity to which it is = addressed and may contain confidential and/or privileged information. = Copying, forwarding or distributing this message by persons or entities other= =
than the addressee is prohibited. If you have received this email in error, = please contact the sender immediately and delete the material from any = computer. This email may have been monitored for policy compliance. [021216]

------_=_NextPart_001_01C34BCC.57BCF7B7
Content-Type: text/html;
charset=us-ascii
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 5.50.4923.2500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D732035618-16072003><FONT face=3DArial color=3D#0000ff =

size=3D2>I do=20
not believe that you can have a listener on box a and a database on box = b. =20
Listeners monitor for connections on their indicated port.  They then =
=66ork=20

and exec a server process for the connection.  In this sense the RDBMS=20 never talks to the listener.  The listener is responsible to manage the=
=20

communications.</FONT></SPAN></DIV>
<DIV><SPAN class=3D732035618-16072003><FONT face=3DArial color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D732035618-16072003><FONT face=3DArial color=3D#0000ff=20 size=3D2>Allan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">   <DIV></DIV>
  <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft><FONT=
=20

  face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20   oramagic_at_hotmail.com [mailto:oramagic_at_hotmail.com] <BR><B>Sent:</B> = Wednesday,=20
  July 16, 2003 2:44 PM<BR><B>To:</B> Multiple recipients of list=20   ORACLE-L<BR><B>Subject:</B> listener<BR><BR></FONT></DIV>   <DIV><FONT face=3DArial size=3D2>Is it possible to have listner running on = box=20
  a  while databases running on X,Y,Z . If yes , then how does oracle=20   instance find the address of the box running the listner , if I configure=20   ini.ora with service_name . Does it mean that local tnsnames.ora file ( on=
=20

  server X,Y,Z) should haave an entry for this service_name . </FONT></DIV>

  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>-ak</FONT></DIV>
  <DIV><FONT face=3DArial =

size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>

<P>__________________________________________________________________________=

____<br>
This email is intended solely for the person or entity to which it is = addressed and may contain confidential and/or privileged information. = Copying, forwarding or distributing this message by persons or entities other= =
than the addressee is prohibited. If you have received this email in error, = please contact the sender immediately and delete the material from any = computer. This email may have been monitored for policy compliance. = Received on Wed Jul 16 2003 - 13:59:11 CDT