Oracle upgrade from 10.0.2 to 10.0.3 Oracle Database Tips by Donald Burleson

 

Question: Currently my database running on 10.0.2 version.  I have to upgrade for some errors on my application side. I even don't have an basic idea how to start this upgrade.

 

Answer: (by Michael Cunningham) -

MAKE SURE YOU BACKUP THE DATABASE FIRST.

When you download the patch you should have a README.html file and that is the best place to look for instructions. There are extra sections in this file so you only need to read the parts that pertain to your current version of oracle (which you say is 10.0.2).

The general idea for an Oracle upgrade is:

1. verify prerequisites (such as AIX patches)
2. take a complete backup
3. shutdown oracle database and other services
4. install the 10.0.3 database kernel using the runInstaller script
5. startup oracle services
6. startup each database with STARTUP UPGRADE (this is what you will use for your minor upgrade)
7. run a script (such as ?/rdbms/admin/catupgrd.sql)
   restart the database

Again, the best thing to do is read that README.txt file.

Also see MOSC note 337096.1.
 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.