Re: local_listener in 11gR2 RAC

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 18 Jul 2013 09:08:59 -0500
Message-ID: <CAEueRAUEbZNtdJ07Y6Kr5PHSSjgO96HT7rE=V8eKmzL3xDBJcg_at_mail.gmail.com>

It sounds like your local listener is not configured properly. Confirm these things:

• Your local listener is running out of your clusterware home, not your database home
• The clusterware listener configuration file (<GRID_HOME>/network/admin/listener.ora) looks like this:
• LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

Seth Miller

On Thu, Jul 18, 2013 at 8:49 AM, K R <kp0773_at_gmail.com> wrote:

> Yes. it is 11.2.0.3 . . Scan listener is registering . remote_listener
> is set to scan . and local_listener is set to the node vip .couple of time
> I did alter system register but when i do the lsnrctl status I do not see
> the node vip address
>
>
> On Thu, Jul 18, 2013 at 6:43 AM, Seth Miller <sethmiller.sm_at_gmail.com>wrote:
>
>> Kart,
>> The listener does not register with the instance, the instance registers
>> with the listener.
>>
>> You didn't mention it, but I am assuming you are using 11.2 which means
>> the
>> remote_listener parameter should be set to the SCAN.
>>
>> The local_listener parameter, however, hasn't changed. It should be using
>> either a tnsnames.ora entry or more likely, the full connection
>> descriptor.
>>
>> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1545)))).
>>
>> Use 'lsnrctl stat' to make sure that the listener is listening on that IP
>> and port. The instance will automatically register with the listener on a
>> regular basis but you can use 'alter system register;' to force a
>> registration to take place.
>>
>> Seth Miller
>>
>>
>> On Thu, Jul 18, 2013 at 2:23 AM, K R <kp0773_at_gmail.com> wrote:
>>
>> > All,
>> > in a 3 node RAC . one of the node's listener is not registering the
>> > instance . i try deleing adding listener but still no help.
>> > appreciate any help
>> >
>> > thanks
>> > Kart
>> >
>> >
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 18 2013 - 16:08:59 CEST