Re: RAC question
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