Oracle RAC upgrade from 10.1.0.3 to 10.1.0.4

Note1: This cookbook shows only the minimal steps to upgrade RAC on the new mid-range PCs as configured by FIO for Oracle installation.

Note2: It supposes NO DATABASE is created at the moment of the upgrade

1. Installing Oracle Database 10g Products

• use OUI from ORACLE_HOME

cd $ORACLE_HOME/oui/bin/
./runInstaller

• Source: /ORA/dbs01/oracle/home/cds/10103companion/Disk1/stage/products.xml
• Destination: OraRDBMS10gHome
• Path: /ORA/dbs01/oracle/product/10.1.0/rdbms
• What: Oracle Database 10g Products (with NCOMP)
• INSTALL
• Error "File not found": Ignore
• As root: /ORA/dbs01/oracle/product/10.1.0/rdbms/root.sh (then option 3)

2. Patchset installation - CRS upgrade

• Shutting down ASM instances

for n in 11 12; do srvctl stop asm -n itrac${n}; done;

• Shutdown CRS (slow)

for n in 11 12; do ssh itrac${n} 'sudo /etc/init.d/init.crs stop'; done;

• Startup OUI provided with the Patchset

   cd cds/patchset_10.1.0.4/Disk1/ 
   ./runInstaller

• Select correct ORACLE_HOME (the one in which CRS is installed)

• As root: /ORA/dbs01/oracle/product/10.1.0/crs/install/root10104.sh (all nodes)

(after few minutes, at the end of the procedure you should see: "10.1.0.4 patch successfully applied.")

• NOTE: root.sh script mentioned above automatically starts up ASM and database instance on the patched node.

3. Patchset installation - database software upgrade

• Shutting down ASM instances

for n in 11 12; do srvctl stop asm -n itrac${n}; done;

• Startup OUI provided with the Patchset.

cd cds/patchset_10.1.0.4/Disk1/
./runInstaller

• Select correct ORACLE_HOME (the one in which Database binaries are installed)

• As root: /ORA/dbs01/oracle/product/10.1.0/rdbms/root.sh

• Run OEM Database Control patch on all cluster nodes except the one on which OUI was running.

   
$ORACLE_HOME/sysman/install/configPatch.pl

• Run the script to create symbolic links to OCCI libraries:

 
$ORACLE_HOME/bin/occi_links.sh