RAC question

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 9 Mar 2011 22:37:57 +0000 (UTC)
Message-ID: <pan.2011.03.09.22.37.57_at_email.here.invalid>

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 Received on Wed Mar 09 2011 - 16:37:57 CST