Re: RAC question

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 30 Mar 2011 12:08:49 -0700 (PDT)
Message-ID: <40a0a96a-5355-4171-9e22-8588e3695c15_at_q40g2000prh.googlegroups.com>



On Mar 13, 2:19 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Sun, 13 Mar 2011 11:00:24 -0700, Steve Howard wrote:
> > On Mar 12, 11:05 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> >> On Sat, 12 Mar 2011 17:57:54 -0800, onedbguru wrote:
> >> > It is my understanding that yes, you can use 11g grid+ASM with a 10g
> >> > RAC database.
>
> >> Excellent. That is my question. I tried unsuccessfully. I was able to
> >> get a single instance 10g to work, but it wouldn't start as a cluster
> >> instance. Did you do it and, if yes, how exactly is that done? That is
> >> what I am asking.
>
> >> --http://mgogala.byethost5.com
>
> > Hi Mladen,
>
> > I am almost positive I did this (10.2.0.4 database managed by 11.2.0.2
> > CRS) last September when I first tested 11.2.0.2.  However, my notes
> > from that testing aren't very good.  However, I will be doing this again
> > later this week, so this is a timely question.
>
> > I will forward anything I do to you.
>
> > Thanks,
>
> > Steve
>
> Thanks, Steve. I will also be doing that this week. My CIO was nice
> enough to make necessary equipment available.
>
> --http://mgogala.byethost5.com

Hi Mladen,

I'm sure you have an answer by now, but for the sake of completeness I wanted to respond in case some poor soul wandering the internet stumbles on this in an hour of desperation.

Yes, 11.2.0.2 ASM/Grid Infrastructure can manage a 10.2.0.4 database...


dell11gr2:oracle:apptest2:/home/oracle>sp

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 30 15:05:33 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from gv$database;

OPEN_MODE



READ WRITE
READ WRITE SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options
dell11gr2:oracle:apptest2:/home/oracle>profile 1) apptest2
2) +ASM2
Please select an ORACLE environment from the list above: 2
USER...............oracle
ORACLE_SID.........+ASM2
ORACLE_HOME......../u01/app/11.2.0/grid
ORACLE_BASE......../u01/app/oracle
HOST...............dell11gr2 192.168.1.20
*************************************************

dell11gr2:oracle:+ASM2:/home/oracle>sp

SQL*Plus: Release 11.2.0.2.0 Production on Wed Mar 30 15:05:49 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Real Application Clusters and Automatic Storage Management options

SQL> Received on Wed Mar 30 2011 - 14:08:49 CDT

Original text of this message