Re: RAC query

Chris Williams wrote:
> Hi everyone,
>
> I'm just checking whether I understand the way Oracle RAC is suspposed
> to work.
>
> I have two nodes, named pora1 and pora2. Both nodes access the cluster
> registry and voting disk files on raid storage, mounted on /oracrs . All
> other data files are mounted at /u02
> Both disks are OCFS.
>
> pora2 is up and hosting the instance correctly: ie
>
> crs_stat -t :
> -------------------------------------------------------
> ora....v1.inst application ONLINE OFFLINE
> ora....v2.inst application ONLINE ONLINE pora2
> ora.biodev.db application ONLINE ONLINE pora2
> ora....A1.lsnr application ONLINE OFFLINE
> ora.pora1.gsd application ONLINE OFFLINE
> ora.pora1.ons application ONLINE OFFLINE
> ora.pora1.vip application ONLINE ONLINE pora1
> ora....A2.lsnr application ONLINE ONLINE pora2
> ora.pora2.gsd application ONLINE ONLINE pora2
> ora.pora2.ons application ONLINE ONLINE pora2
> ora.pora2.vip application ONLINE ONLINE pora2
>
> However, pora1 cannot start its copy of the instance with the following
> error in $CRS_HOME/crs/log/pora1.log :
> --------------------------------------------------------------------
> 2005-04-27 13:54:37.188: Attempting to start `ora.biodev.biodv1.inst` on
> member `pora1`
> 2005-04-27 13:59:53.001: CRS-1005: Failed to get required resources
>
> 2005-04-27 14:03:51.822: [RUNCONTEXT::RUNSCRIPT:2718129072]
> StartResource error for ora.biodev.biodv1.inst error code = 1
> 2005-04-27 14:03:54.552: Start of `ora.biodev.biodv1.inst` on member
> `pora1` failed.
> ------------------------------------------------------------------------
>
> Are both instances meant to be online at once and there some resource
> sharing error going on, or is only one meant to be online at a time.
>
> If anyone has any information about what is going on, it would be
> greatly appreciated!
>
> Kind regards,
>
> Chris W.

You can have one or all nodes on-line at the same time and unless performing maintenance all nodes should be started and in-use. If you don't have at least two ... you don't have RAC.

There are too many possible issues for me to diagnose anything from here ... Starting with the lack of version number and whether the cluster has ever actually been up.

I would suggest you open an iTAR.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)