Step By Step process of applying Oracle Upgrade Patches
Posted on 2006-10-19
I have two oracle databases on my machine 9i (220.127.116.11.0) and 10g(10.2.0.1.0). OS: Windows XP.
I wanted to upgrade my 9i to 10g as well without loosing any data as this is a business requirement now.
When I utilized ORACLE DATABASE UPGRADE ASSISTANT and provided the password for "SYS" user, I got the message:
"ORA-20000: VERSION 18.104.22.168.0 NOT SUPPORTED FOR UPGRADE TO RELEASE 10.2.0"
"ORA-06512: AT LINE 1523"
I looked the best resource "INTERNET" and "EXPERT EXCHANGE" of course. I found that I need to apply a patch.
One of the hurdle is that I am not a subscriber of METALINK (I think I have to be a subscriber if I want to find a right patch from the upgrade), but this is a minor one. The major one is that I have no experience in applying patches at all.
The most important thing for me is that I have 0 experience in applying patches. I am a little bit scared also when I see some of the suggestions how to apply patches. As a matter of fact I need a STEP BY STEP approach to apply the patches.
Can some of you THE EXPERTS provide me this?
Thanks in advance, as always!