Re: local_listener in 11gR2 RAC
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 18 Jul 2013 09:08:59 -0500
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@xxxxxxxxx> 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@xxxxxxxxx>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@xxxxxxxxx> 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
>> >
>> >
>> > --
>> > //www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
