Re: 11gr2 Clusterware config (or: does anyone know what an endpoint is?)
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- Date: Sat, 5 Feb 2011 16:04:54 -0600
Yeah, I did the RTFM bit on MOS, but none of it actually applied to my
situation. The update on the SR that came in last night showed that the MOS
tech didnt really understand the doc either, so he started up an
experimental cluster and figured out the appropriate commands himself. That
wasnt an option for me since I dont currently have a play 11g cluster up and
running. Fyi, the scan listener prefix is typicall LISTENER and an
'endpoint' appears to be protocol: port, so to add a scan listener manually
would be:
srvctl add scan_listener -l LISTENER -p TCP:1521
On Sat, Feb 5, 2011 at 12:09 PM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx>wrote:
> As a comment for Martin's post:
> I believe the MOS note shoule be : How to Modify SCAN Setting after
> Installation [ID 972500.1]
>
> --
> Kamus <kamusis@xxxxxxxxx>
>
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
>
>
> On Fri, Feb 4, 2011 at 4:16 PM, Martin Bach
> <development@xxxxxxxxxxxxxxxxx> wrote:
> > Hi Andrew,
> >
> > There are 2 mos notes about how to change the scan post the installation.
> I
> > have also bogged about it (see below for the link, I don't have the exact
> > url to my post at hand right now). None of the solutions involves crsctl
> > BTW, and I would definitely not use this command for ora.* prefixed
> > resources.
> >
> > Let me know if you can't locate the post and I will dig up the url.
> >
> > Hope this helps,
> >
> > Martin
> >
> > Martin Bach
> >
> > Oracle Certified Master 10g
> > http://martincarstenbach.wordpress.com
> > http://www.linkedin.com/in/martincarstenbach
> >
> > ----- Reply message -----
> > From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
> > Date: Thu, Feb 3, 2011 18:27
> > Subject: 11gr2 Clusterware config (or: does anyone know what an endpoint
> > is?)
> > To: "Surachart Opun" <surachart@xxxxxxxxx>
> > Cc: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
> >
> >
> > I guess I didnt explain the problem. There are now 3 ips for SCAN, and
> they
> > show up properly in DNS and in srvctl config scan, but according to
> Oracle I
> > have to add another scan listener. I cant figure out the correct syntax
> of
> > the command to add a scan listener, primarily because I dont know what a
> > scan prefix or an endpoint is.
> >
> > On Thu, Feb 3, 2011 at 11:35 AM, Surachart Opun <surachart@xxxxxxxxx>
> wrote:
> >
> >> >srvctl config scan also showed just two
> >> How about nslookup and dig command-line show you?
> >> 2 IPs or 3 IPs
> >>
> >> >Oracle usually said dont use crsctl for this kind of stuff except as a
> >> last resort.
> >>
> >> if you need to add resource SCAN or SCAN LISTNER - you may need it
> >>
> >> If you want to use "srvctl" -> check DNS see 3 IPs(mayby reverse DNS
> too),
> >> remove SCAN + SCAN LISTENER and then ADD again by srvctl
> >>
> >>
> >> Good Luck
> >> Surachart Opun
> >> http://surachartopun.com
> >> Oracle ACE, OCE, OCP
> >>
> >>
> >> On Thu, Feb 3, 2011 at 11:41 PM, Andrew Kerber
> >> <andrew.kerber@xxxxxxxxx>wrote:
> >>
> >>> srvctl config scan also showed just two. And if your dns is configured
> >>> properly, it should show all 3 entries. At least it does on Solaris
> and
> >>> on
> >>> oel. When does the third entry not show?
> >>>
> >>> does crsctl add the entry to the endpoints_listener.ora file?
> >>>
> >>> The last time I checked, Oracle usually said dont use crsctl for this
> >>> kind
> >>> of stuff except as a last resort.
> >>>
> >>>
> >>> On Thu, Feb 3, 2011 at 10:30 AM, Surachart Opun
> >>> <surachart@xxxxxxxxx>wrote:
> >>>
> >>>> To Andrew,
> >>>>
> >>>>
> >>>> > The nslookup showed only 2 ip addresses, not the required 3.
> >>>> nslookup -> that depends on your DNS server
> >>>>
> >>>> what do you see in?
> >>>> $ srvctl config scan
> >>>>
> >>>> Oracle suggests 3 IPs, so you can have 2 IPs for SCAN.
> >>>>
> >>>>
> >>>> >Has anyone used the srvctl add scan_listener command
> >>>> nope, I added IP SCAN and scan listener by using "crsctl"
> >>>>
> >>>> Example:
> >>>> # crsctl status res ora.LISTENER_SCAN1.lsnr -p
> >>>>
> >>>> and then check attribute for using with SCAN2 Listener
> >>>> and use
> >>>> > crsctl add resource
> >>>>
> >>>>
> >>>>
> >>>>
> http://download.oracle.com/docs/cd/E11882_01/rac.112/e16794/crsref.htm#CHDIHGHE
> >>>>
> >>>>
> >>>> Good Luck
> >>>> Surachart Opun
> >>>> http://surachartopun.com
> >>>> Oracle ACE, OCE, OCP
> >>>>
> >>>>
> >>>>
> >>>> On Thu, Feb 3, 2011 at 11:17 PM, Andrew Kerber
> >>>> <andrew.kerber@xxxxxxxxx>wrote:
> >>>>
> >>>>> So, I recently took ownership of an 11gR2 cluster. One of the first
> >>>>> things I noticed is that the SCAN was not set up correctly. The
> >>>>> nslookup
> >>>>> showed only 2 ip addresses, not the required 3. I am not sure how
> they
> >>>>> managed to install it this way, but I am trying to fix it. I had the
> >>>>> network guys add the 3rd ip to the scan round robin, then ran (after
> >>>>> stopping scan and scan listener):
> >>>>>
> >>>>> srvctl modify scan -n <scan-name>
> >>>>>
> >>>>> Well, we had connection (connect failures on every third attempt)
> >>>>> problems and oracle said I had to add a scan listener, and gave me
> the
> >>>>> syntax for adding a scan listener (ie, they copied it out of the
> doc).
> >>>>> (see
> >>>>> below). So, now I have given oracle the output of my srvctl config
> >>>>> scan
> >>>>> command asked for an example of what the command should look like
> with
> >>>>> my
> >>>>> given information. And no answer yet. So I suspect that oracle
> support
> >>>>> doesnt know exactly how to do this either. Has anyone used the
> srvctl
> >>>>> add
> >>>>> scan_listener command, or know how to do it?
> >>>>>
> >>>>> srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p
> >>>>> [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>]
> >>>>> [/SDP:<port>]]
> >>>>> -l <lsnr_prefix> SCAN listener name prefix
> >>>>> -s Skip the checking of ports
> >>>>> -p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>]
> >>>>> [/SDP:<port>] SCAN Listener endpoints
> >>>>> -h Print usage
> >>>>>
> >>>>>
> >>>>> --
> >>>>> Andrew W. Kerber
> >>>>>
> >>>>> 'If at first you dont succeed, dont take up skydiving.'
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>> --
> >>> Andrew W. Kerber
> >>>
> >>> 'If at first you dont succeed, dont take up skydiving.'
> >>>
> >>
> >>
> >
> >
> > --
> > Andrew W. Kerber
> >
> > 'If at first you dont succeed, dont take up skydiving.'
> >
> >
> >
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
