Re: RAC question

From: joel garry <joel-garry_at_home.com>
Date: Wed, 9 Mar 2011 16:45:57 -0800 (PST)
Message-ID: <a9a4dd2c-f4c8-4aec-a481-cf9009b31c69_at_j13g2000pro.googlegroups.com>

On Mar 9, 2:37 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> 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

I don't know what 11g or CRS are, but does MOS 337737.1 tell what you need?

jg

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

Received on Wed Mar 09 2011 - 18:45:57 CST