10.2.0.2 Upgrade

Wednesday 04 June, 2008 - 23:37

I have now successfully upgraded a singleton 10.2.0.1 database with and without ASM. My only worry is that the upgrade script (catupgrd.sql) takes over one (1) hour to run on my VAIO. Fortunately, this script does not have to be run for the ASM instance.

Still, I could be looking atabout 4.5hours to get a 10.2.0.2 instance running with ASM. I cannot afford to make any mistakes with this.

(1) 30 Minutes planning

(2) 30 minutes for Linux configuration changes (depending on what packages have been installed)

(3) 30 minutes for 10.2.0.1 installation of ASM database software

(4) 30 minutes for 10.2.0.1 installation of user database software

(5) 30 minutes for creation and backup of user database

(6) 30 minutes for 10.2.0.2 upgrade of ASM database

(7) 90 minutes for 10.2.0.2 upgrade of user database

It looks like I will have to juggle many installations at the same time in order to meet the timings for all the installation scenarios. If there are four (4) scenarios per day, then I am looking at an average of 2.5 hours per scenario.

The minimum number of Linux boxes that need to be installed are:

2 for the primary RAC (10.2.0.1)

2 for the physical standby RAC (10.2.0.1)

1 for Grid Control (10.1.0.3)

2 for ODD and EVEN (10.2.0.2)