Re: listener

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 17 Jul 2003 02:08:57 +0300
Message-Id: <25937.338148@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_009A_01C34C08.61732010 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!

Your databases actually have to register with your listener on remote = machine.
Your databases have to have tnsnames.ora configured with entry for = listener location as well and your instances' REMOTE_LISTENER parameter = has to specify the tns alias for listener location. That way databases = can register themselves with listener and give it all necessary connect = information.

I believe that you actually can specify the whole tns address string for = remote_listener parameter, like you can do with local_listener...

Tanel.

Original Message -----=20 From: AK=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 16, 2003 10:44 PM Subject: listener

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

-ak

------=_NextPart_000_009A_01C34C08.61732010 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Your databases actually have to =
register with your=20
listener on remote machine.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Your databases have to have =
tnsnames.ora configured=20
with entry for listener location as well and your instances' = REMOTE_LISTENER=20
parameter has to specify the tns alias for listener location. That way = databases=20
can register themselves with listener and give it all necessary connect=20 information.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I believe that you actually can specify =
the whole=20
tns address string for remote_listener parameter, like you can do with=20 local_listener...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tanel.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Doramagic_at_hotmail.com =
href=3D"mailto:oramagic_at_hotmail.com">AK</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, July 16, 2003 = 10:44=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> listener</DIV>
  <DIV><BR></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> Received on Wed Jul 16 2003 - 18:08:57 CDT