Re: 11gr2 Clusterware config (or: does anyone know what an endpoint is?)
Date: Fri, 4 Feb 2011 01:44:06 +0700
Message-ID: <AANLkTi=8HNaqA=jwTy8S+QoRvBAi-dMzrDJU2EZB3fJx_at_mail.gmail.com>
you should check from this link:
http://download.oracle.com/docs/cd/E11882_01/rac.112/e16794/crsref.htm#CHDIHGHE
and check from old resource:
# crsctl status res ora.LISTENER_SCAN1.lsnr -p
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
ACL=owner:oracle:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE= ACTION_SCRIPT= ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX% AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
CHECK_TIMEOUT=30
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2)) DEGREE=1
DESCRIPTION=Oracle SCAN listener resource ENABLED=1
ENDPOINTS=TCP:1521
FAILOVER_DELAY=0
FAILURE_INTERVAL=0 FAILURE_THRESHOLD=0 HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.scan1.vip)
dispersion:active(type:ora.scan_listener.type) pullup(ora.scan1.vip) START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.scan1.vip) STOP_TIMEOUT=0 TYPE_VERSION=1.2
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
VERSION=11.2.0.2.0 And then need to add LISTENER_SCAN2 for SCAN2 (if I think right what you what and* you have to have SCAN2*)
# crsctl add resource ora.LISTENER_SCAN2.lsnr -type ora.scan_listener.type
-attr
"VERSION=11.2.0.2.0,STOP_DEPENDENCIES=hard(intermediate:ora.scan2.vip),START_DEPENDENCIES=hard(ora.scan2.vip)
dispersion:active(type:ora.scan_listener.type)
pullup(ora.scan2.vip),'ACL=owner:oracle:rwx,pgrp:oinstall:r-x,other::r--'"
that's sample...
Good Luck
Surachart Opun
http://surachartopun.com
Oracle ACE, OCE, OCP
On Fri, Feb 4, 2011 at 1:27 AM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> 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_at_gmail.com>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_at_gmail.com>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_at_gmail.com>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_at_gmail.com
>>>> > 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.'
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2011 - 12:44:06 CST