Message-Id: <10537.110268@fatcity.com> From: Alex Hillman Date: Fri, 23 Jun 2000 10:02:33 -0400 Subject: local_listener This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFDD1B.ADA92320 Content-Type: text/plain; charset="iso-8859-1" Could somebody explain to me (but please not citing docs - because I read it) why and when do I need this parameter in the init.ora and entry in tsnames.ora. I created two listeners in the listener.ora - LISTENER (port 1521) and TESTLISTENER(port 1526) and correct entries for DB aliaces in tnsnames.ora. Then opened NET8i guide and read on the page 7-10 that for PMON to register on the not default address (default is TCP/IP with port 1521) - one need to have local_listener=TESTLISTENER in init.ora and entry TNSLISTENER=(address=(prot=tcp)(host=host_name)(port=1526)) in tnsnames.ora. In my case everything worked fine without these entries in init.ora and tnsnames.ora. So question is what PMON registering mean. Alex Hillman ------_=_NextPart_001_01BFDD1B.ADA92320 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable local_listener

Could somebody explain to me (but = please not citing docs - because I read it) why and when do I need this = parameter in the init.ora and entry in tsnames.ora. I created two = listeners in the listener.ora - LISTENER (port 1521) and = TESTLISTENER(port 1526) and correct entries for DB aliaces in = tnsnames.ora. Then opened NET8i guide and read on the page 7-10 that = for PMON to register on the not default address (default is TCP/IP with = port 1521) - one need to have local_listener=3DTESTLISTENER in init.ora = and entry = TNSLISTENER=3D(address=3D(prot=3Dtcp)(host=3Dhost_name)(port=3D1526)) = in tnsnames.ora. In my case everything worked fine without these = entries in init.ora and tnsnames.ora. So question is what PMON = registering mean.

Alex Hillman