Message-Id: <25937.338148@fatcity.com> From: "Tanel Poder" Date: Thu, 17 Jul 2003 02:08:57 +0300 Subject: Re: listener 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
Hi!
 
Your databases actually have to = register with your=20 listener on remote machine.
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.
 
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...
 
Tanel.
 
----- Original Message -----
From:=20 AK
To: Multiple recipients of list = ORACLE-L=20
Sent: Wednesday, July 16, 2003 = 10:44=20 PM
Subject: listener

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 . =
 
-ak