Posted by: Colin Smith
Database, Database Administration, Oracle
I did my Oracle upgraded yesterday and overall I think that it went pretty well. We are still testing but so far so good. The process was not too bad. First you need to create a new $ORACLE_HOME as two Oracle installations can not be in the same $ORACLE_HOME. Then install the media. I did run into one snag here, it did not want to install on the Solaris 10 OS 64 Bit. After some looking we found this to be a bug and we found a resolution. Then I installed items from the companion CD. This is was tricky as well. I selected the companion cd products and I could not install them into the same $ORACLE_HOME. I kept fooling around with it and found that if you choose Oracle 10g products then it installs just fine and does install the items from the companion cd. All I wanted from the companion cd was JAccelerator but it forces you to install all 20 products. LAME. After that I did all my patching and I did not install a new Database. This is because I want to upgrade an existing DB. After that I ran the Database Upgrade Assistant and that is really all there was to it. So if anyone is upgrading and has any questions please let me know by going to http://sysadminsmith.com and clicking the Submit A Question link on the right.