Re: Multiple listeners for MTS

Ok,
I got it working by
putting an additional line like:
*.local_listener='LISTENER_TEST3'
*.local_listener='LISTENER_TEST3_2'

the second line is my new listener,
now both listener is running MTS now.

Dominica

dominica_at_gmail.com wrote:
> Hi All,
>
> I am on oracle 10.2.0.2 (on solaris 64 bits).
>
> Current setup:
>
> 1) Oracle server running one LISTENER, call LISTENER_TEST3 ,
> running MTS server. (everything is fine).
> (this one listen on 41521)
>
> Inside init.ora file:
> *.local_listener='LISTENER_TEST3'
>
> Qn:
> I am trying to add an additional LISTENER called LISTENER_TEST3_2
> using a different port 41525.
> It work for me for dedicated.
>
> But I only could add a dedicated one. Everything is fine for the
> additional listener.
> I wonder how to add the "additional one " and also running MTS.
> I wonder whether I have to
> put one more line inside the init.ora for the
> "local_listener" (I am going to look up the documentation).
> I am posting this "post" is wondering whether other people use
> an additional listener before or it is a "bad" idea.
>
>
>
> lsnrctl serv LISTENER_TEST3_2
>
> LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 25-FEB-2008
> 18:33:59
>
> Copyright (c) 1991, 2005, Oracle. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
> (HOST=test3.db.testcompany.com)(PORT=41525)))
> Services Summary...
> Service "TEST3" has 1 instance(s).
> Instance "TEST3", status UNKNOWN, has 1 handler(s) for this
> service...
> Handler(s):
> "DEDICATED" established:1 refused:0
> LOCAL SERVER
> The command completed successfully
>
> Thanks in advance.
>
>
>
> Dominica
Received on Mon Feb 25 2008 - 18:05:27 CST