I know that Oracle 10g can utilize Oracle 11g ASM. Can it also use 11g
CRS?

I am getting ready to convert my last 9.2.0.8 DB to 11G. Here are
specifics, for those who appreciate this type of thing:

SQL> select database_role from v$database;

DATABASE_ROLE
----------------
PHYSICAL STANDBY

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL>

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
-bash-3.00$ crs_stat -l
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.cvu
TYPE=ora.cvu.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.lpo-oracle-01.ASM1.asm
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.lpo-oracle-01.LISTENER_LPO-ORACLE-01.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.lpo-oracle-01.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.lpo-oracle-01.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.lpo-oracle-01.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.lpo-oracle-02.ASM2.asm
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.lpo-oracle-02.LISTENER_LPO-ORACLE-02.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-02

NAME=ora.lpo-oracle-02.gsd
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.lpo-oracle-02.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-02

NAME=ora.lpo-oracle-02.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-02

NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on lpo-oracle-01

-bash-3.00$

The plan is to break the replication, upgrade the database to 11G and
"racify" it. The method to "racify" the database hasn't changed that much
since the version 7:

1) Re-create control file with MAXINSTANCES set to > 1
2) Alter database and add another logfile thread
3) Enable thread
4) Create additional UNDO tablespace.
5) Register the DB with RAC (srvctl add).

Only the last step is different from the aforementioned version 7, when
we were still hunting mammoths using stone-tipped spears and wooden clubs.


--
http://mgogala.byethost5.com

On Mar 9, 2:37*pm, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:
I don't know what 11g or CRS are, but does MOS 337737.1 tell what you
need?

jg
--
@home.com is bogus.
http://ars.userfriendly.org/cartoons/?id=19990815

On Wed, 09 Mar 2011 16:45:57 -0800, joel garry wrote:


No, it doesn't help me. I tried it unsuccessfully. I am looking for
someone who has practical experience with that stuff.



--
http://mgogala.byethost5.com

On Mar 10, 8:54*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:


In 11g, the "crs" and ASM are one install and the rdbms binaries are
another install - unlike 10g where the ASM and RDBMS could be the same
set of binaries - you need to rethink your binaries. In 11g, the
"grid" OCR/VOTE are actually stored in ASM not as a separate device as
in 10g. There are a lot of differences. The installation is also very
different in how it does the install and how it does things like the
"cluster alias (aka SCAN VIP)" and you will want to know how to use
the SCAN.

See the master upgrade note: 1152016.1

Due to some nasty little gotcha's when doing the database upgrade, I
would go directly to 11.2.0.2.

Before you EVER do an upgrade, test, test test and test some more.

Depending on your size, it may be just as easy to do this via export/
import to new hardware - again depending on how big it is... 11g is a
VERY different beast than 9iRAC or even 10gRAC

On Fri, 11 Mar 2011 18:39:05 -0800, onedbguru wrote:

Look at the original post: I do have cluster, I don't have ASM. I have to
upgrade 9i RAC. The standby is on OCFS2. And I did test. What I was
asking is whether 10g can use Oracle 11 cluster ready services (CRS) to
communicate between instances? I was unsuccessful with that. I was able
to make Oracle 10g use Oracle 11g ASM.



--
http://mgogala.byethost5.com

On Mar 12, 1:49*pm, Mladen Gogala <mgog... (AT) no (DOT) address.invalid> wrote:
It is my understanding that yes, you can use 11g grid+ASM with a 10g
RAC database.

Install 11.2.0.2 Grid Infrastructure which includes the cluster stack
AND ASM. As stated earlier, the Cluster stack (formerly CRS) and ASM
are combined into one.
Install 10gRAC (preferably 10.2.0.5) database software
Create and move the database.

On Sat, 12 Mar 2011 17:57:54 -0800, onedbguru wrote:

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

Mladen:

# I was able to get a single instance 10g to work, but it wouldn't
start as a cluster instance.

My crystal ball is broken sorry so could you please give error
messages and/or log file entries that might be applicable here?

On Sun, 13 Mar 2011 06:23:07 -0700, John Hurley wrote:

John, with all due respect, have you ever been doing something like that?



--
http://mgogala.byethost5.com

Mladen:

# John, with all due respect, have you ever been doing something like
that?

Using a crystal ball? Trying to solve a problem that includes an
Oracle error message?

I do have a magic 8 ball that some vendor gave me at some point.

I have to think that not a lot of people are trying to go from a 9i
single instance database directly into an 11.2 RAC setup. Many people
would do the RAC setup and migrate data into it via one of several
means.

You did however say that it did not work ... usually when something
"does not work" one receives error messages and/or entries in one or
more log files ... usually.