Just Step to upgrade (RAC) 10.2.0.4 to 11.1.0.6

Details:

Oracle Clusterware 10.2.0.4 => /u01/oracle/product/crs

Oracle Database 10.2.0.4 =>
/u01/oracle/product/10.2.0/db (DB)
/u01/oracle/product/10.2.0/asm (ASM)

Database Name => oradb

Need to upgrade to 11G (11.1.0.6)

Begin:

- Check Clusterware version:

# /u01/oracle/product/crs/bin/crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.4.0]

- Download 11G cluster and then uncompress

- Oracle Clusterware pre-installation checks:

$ ./runcluvfy.sh stage -pre crsinst -n all -verbose > /tmp/precheck.txt
.
.
.
Check....

- Stop all database resources.

- Prepare the Oracle Clusterware Home for upgrade (by root)

# ./clusterware/upgrade/preupdate.sh -crshome /u01/oracle/product/crs -crsuser oracle

Shutting down Oracle Cluster Ready Services (CRS):
Stopping resources. This could take several minutes.
Error while stopping resources. Possible cause: CRSD is down.
Shutdown has begun. The daemons should exit soon.
Checking to see if Oracle CRS stack is down...
Oracle CRS stack is down now.

- Upgrade the Oracle Clusterware (by oracle)

$./clusterware/runInstaller


After that Oracle need root user run "rootupgrade" on every nodes.

# /u01/oracle/product/crs/install/rootupgrade
.
.
.

Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
CRS stack on this node, is successfully upgraded to 11.1.0.6.0
Checking the existence of nodeapps on this node

Creating '/u01/oracle/product/crs/install/paramfile.crs' with data used for CRS configuration

Setting CRS configuration values in /u01/oracle/product/crs/install/paramfile.crs


*** when run every nodes then click "OK"

Check:

# /u01/oracle/product/crs/bin/crsctl check crs

Cluster Synchronization Services appears healthy
Cluster Ready Services appears healthy
Event Manager appears healthy

# /u01/oracle/product/crs/bin/crsctl query crs softwareversion
Oracle Clusterware version on node [hostname] is [11.1.0.6.0]

# /u01/oracle/product/crs/bin/crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.1.0.6.0]

$ /u01/oracle/product/crs/bin/cluvfy stage -post crsinst -n [listnodes]

$ /u01/oracle/product/crs/bin/crs_stat -t

- Install Oracle Database 11g Software

New PATH: /u01/oracle/product/11.1.0/db (Install Only Software)

$ ./database/runInstaller

- Execute the pre-database upgrade checks, utlu111i.sql to verify that all pre-requisites are met.

export ORACLE_HOME=/u01/oracle/product/10.2.0/db
export ORACLE_SID=oradb1


use sys:

SQL> spool /tmp/utlu111i.log

SQL> @/u01/oracle/product/11.1.0/db/rdbms/admin/utlu111i

Oracle Database 11.1 Pre-Upgrade Information Tool 11-14-2008 16:55:47
.**********************************************************************
Database:
**********************************************************************
--> name: ORADB
--> version: 10.2.0.4.0
--> compatible: 10.2.0.1.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V4
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 745 MB
.... AUTOEXTEND additional space required: 245 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 414 MB
.... AUTOEXTEND additional space required: 84 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 428 MB
.... AUTOEXTEND additional space required: 178 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
.... AUTOEXTEND additional space required: 30 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
WARNING: --> "sga_target" needs to be increased to at least 672 MB
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle OLAP API [upgrade] VALID
.
.
.

PL/SQL procedure successfully completed.

SQL> spool off

- Modify new Profile Env

export ORACLE_SID=oradb1

export ORACLE_HOME=/u01/oracle/product/11.1.0/db


- Upgrade Database => Database Upgrade Assistant (DBUA):

$ /u01/oracle/product/11.1.0/db/bin/dbua


- Check

SQL> select comp_name,version,status from dba_registry;

COMP_NAME VERSION STATUS
----------------------------------- ---------- --------
Oracle Enterprise Manager 11.1.0.6.0 VALID
OLAP Catalog 11.1.0.6.0 VALID
Spatial 11.1.0.6.0 VALID
Oracle Multimedia 11.1.0.6.0 VALID
Oracle XML Database 11.1.0.6.0 VALID
Oracle Text 11.1.0.6.0 VALID
Oracle Data Mining 11.1.0.6.0 VALID
Oracle Expression Filter 11.1.0.6.0 VALID
Oracle Rule Manager 11.1.0.6.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Database Catalog Views 11.1.0.6.0 VALID
Oracle Database Packages and Types 11.1.0.6.0 VALID
JServer JAVA Virtual Machine 11.1.0.6.0 VALID
Oracle XDK 11.1.0.6.0 VALID
Oracle Database Java Packages 11.1.0.6.0 VALID
OLAP Analytic Workspace 11.1.0.6.0 VALID
Oracle OLAP API 11.1.0.6.0 VALID
Oracle Real Application Clusters 11.1.0.6.0 VALID



$ /u01/oracle/product/crs/bin/srvctl config database -d oradb
oratest oradb1 /u01/oracle/product/11.1.0/db
.
.
SQL> select name, value from v$parameter
where name like '%dump_dest' or name like 'diag%'

NAME VALUE
-------------------- --------------------------------------------------
background_dump_dest /u01/oracle/product/diag/rdbms/oradb/oradb1/trace
user_dump_dest /u01/oracle/product/diag/rdbms/oradb/oradb1/trace
core_dump_dest /u01/oracle/product/diag/rdbms/oradb/oradb1/cdump
diagnostic_dest /u01/oracle/product

$ /u01/oracle/product/crs/bin/crs_stat -t

- Upgrade Oracle ASM (install Database Software)

New PATH: /u01/oracle/product/11.1.0/db (Install Only Software)

$ ./database/runInstaller

- Upgrade ASM

Stop the database and start up the DBUA.

$ /u01/oracle/product/crs/bin/srvctl stop database -d oradb

$ export ORACLE_HOME=/u01/oracle/product/11.1.0/asm

$ /u01/oracle/product/11.1.0/asm/bin/dbua


- Check

$ /u01/oracle/product/crs/bin/srvctl config asm -n [node name]

+ASM1 /u01/oracle/product/11.1.0/asm
.
.

- Modify Disk Group Compatibility Attributes and Database Compatibility parameter.

Database:

$ /u01/oracle/product/crs/bin/srvctl start database -d oradb

SQL> show parameter compatible

NAME TYPE VALUE
------------ ----------- ----------
compatible string 10.2.0.1.0

SQL> alter system set compatible='11.1.0' scope=spfile;

System altered.

$ /u01/oracle/product/crs/bin/srvctl stop database -d oradb

$ /u01/oracle/product/crs/bin/srvctl start database -d oradb

ASM:

$ export ORACLE_HOME=/u01/oracle/product/11.1.0/asm

$ export ORACLE_SID=+ASM1

SQL> select name,compatibility,database_compatibility from v$asm_diskgroup;

NAME COMPATIBIL DATABASE_C
---------- ---------- ----------
DATA1 10.1.0.0.0 10.1.0.0.0
DATA2 10.1.0.0.0 10.1.0.0.0

SQL> alter diskgroup DATA1 set attribute 'compatible.asm'='11.1.0';

Diskgroup altered.

SQL> alter diskgroup DATA1 set attribute 'compatible.rdbms'='11.1.0';

Diskgroup altered.

SQL> alter diskgroup DATA2 set attribute 'compatible.asm'='11.1.0';

Diskgroup altered.

SQL> alter diskgroup DATA2 set attribute 'compatible.rdbms'='11.1.0';

Diskgroup altered.

SQL> select name,compatibility,database_compatibility from v$asm_diskgroup;

NAME COMPATIBIL DATABASE_C
---------- ---------- ----------
DATA1 11.1.0.0.0 11.1.0.0.0
DATA2 11.1.0.0.0 11.1.0.0.0

- Check

$ /u01/oracle/product/crs/bin/crs_stat -t

.
.
.

Upgraded...