Re: local_listener in 11gR2 RAC

From: K R <kp0773_at_gmail.com>
Date: Thu, 18 Jul 2013 11:06:32 -0700
Message-ID: <CABPz0xjTKJ=T4sMM65YVbdLSJJkmPfm3+-YmsHW+mJunPMiOew_at_mail.gmail.com>

Hi Seth,
yes they run from grid home . and i have not done any update to lisener.ora. here is mine
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))             # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))             # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # 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=ON              # line added by
Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line
added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line

added by Agent

On Thu, Jul 18, 2013 at 7:08 AM, Seth Miller <sethmiller.sm_at_gmail.com>wrote:

> 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
>
>
>

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

Received on Thu Jul 18 2013 - 20:06:32 CEST