Linux ORACLE RAC 10201 Upgrade 10203____linux

I. Preparatory work

1. Effective backup

Make a physical backup of Oracle software and databases.

2. Check for invalid objects.

3. Ensure system's free space is above 50M.

4. Shared_pool_size and java_pool_size are at least 150Mb.

5. Close the database and close the Oracle process.

6. Back up the related configuration file two. Backup Tstz

Download and extract Patch 5601428, apply the Patch ( apply the Patch do not need to close the database ) reference 399832.1.

$unzip P5601428_10201_generic.zip  5601428

$CD 5601428

$opatch Apply

$sqlplus '/as sysdba '

Sql>@?/rdbms/admin/utltzuv2.sql

Sql>host

$CD $ORACLE _home/oracore/zoneinfo

$more Tzuv2ext_*.log

$more Tzuv2ext_*.bad

Sql>select * from Sys.sys_tzuv2_temptab;

Three. to upgrade

1. Upgrade CRS

$ CD Disk1
$./runinstaller

--next

--Select the CRS home directory

--next

--check Summary

--install

--when prompt Login As Root,execute $ORACLE _home/root.sh on both nodes

2. Upgrade Oracle Software

$ CD Disk1
$./runinstaller

--Select Oracle Home directory

--next

--check Summary

--install

--when prompt Login As Root,execute $ORACLE _home/root.sh on both nodes

Executes on two nodes under $oracle_home/install root102.sh

3. Start monitoring

$srvctl Start Listener-n jktz1

4. Upgrade the database

$sqlplus "/as sysdba"

Startup Nomount

ALTER SYSTEM SET cluster_database=false scope=spfile;

Shutdown Immediate

Startup Upgrade

Spool Update.log

@?/rdbms/admin/catupgrd.sql

Spool off

ALTER SYSTEM SET cluster_database=true scope=spfile;

CD $ORACLE _home/install

./changeperm.sh

5. Check the invalid object and compile the invalid object.

6. Post-upgrade check

#su –oracle

--Checking The Status of the Oracle clusterware installation

$crsctl Query CRS Softwareversion–lists

--chech CRS Status

Ocrcheck

./app/oracle/product/10.2.0/crs/bin/olsnodes

Crsctl Query CRS Votedisk

Crsctl Query CRS Activeversion

$ CRSCTL Check CRS

$crs _stat–t

Four. Restart the database and apply the test.

Five-fallback scheme

1. Uninstall Upgrade pack

(1) Initialize the parameter cluster_database to false . Close database and Oracle All processes

( 2 The following two files are backed up

 oracle_home/rdbms/admin/catrelod.sql 

Oracle_home/network/admin/tnsnames.ora

( 3)

 $ cd $ORACLE _home 

 $ sqlplus/nolog 

 sql> CONNECT sys/sys_password as SYSDBA 

sql> STARTUP downgrade 

 sql> SPOOL downgrade.out 

 sql> @?/rdbms/admin/catdwgrd.sql 

 sql> SPOOL off 

 sql> SHUTDOWN IMMEDIATE 

 sql> EXIT 

(4) Copy the previous backup file to the original directory.

 $ sqlplus/nolog 

 sql> CONNECT sys/sys_password as SYSDBA 

 sql> STARTUP downgrade
    
 sql> SPOOL catrelod.out 
 
 sql> @?/rdbms/admin/catrelod.sql 
 
 sql> SPOOL off 
 
 sql> SHUTDOWN IMMEDIATE 
 
 (5) Restore the database file, compile the invalid object, and set the   parameter to   
 
 2. Enable the original software backup and the original backup database. &NBSP