I am considering upgrading the database from version 18.104.22.168.0 to version 8.1.6. However, I saw an alert in Oracle metalink mentioning that the upgrade from 815 to 816 is not stable and there is error. May i know has anyone done this before? any errors? Thank u! :)
I was using 22.214.171.124 on hp and had to upgrade to 126.96.36.199 to get a fix for a bug with global temporary tables. In certain specific situations the database would crash. It only happened once though and we were on 188.8.131.52 for several months.
1.Install it in new ORACLE_HOME
2.When its doing installation it will detect the existing instances and will migrate one instance at that time of installation if you want with migration utility,u can do it with migration utility later.U can do the migration of other instances(if u have more than one) using migration utility.
Ensure u have full back up of the database both logical and physical.