We patched Oracle from 22.214.171.124 to 126.96.36.199 successfully. Third party app had issue and blamed it on the patch, so I downgraded back to 188.8.131.52 successfully.
Turns out the problem was not with Oracle, and I want to get back to 184.108.40.206.
For the downgrade, I did (just listing the major steps)
Point ORACLE_HOME / oratab / oraInst to the old, renamed ORACLE_HOME (220.127.116.11)
apply patch 11811073 (new catrelod.sql)
bounce DB and @utlrep, and everything looks peachy on 18.104.22.168.
My question now is - what is the most painless way to get back to 22.214.171.124 ?
Can I just re-point to the new ORACLE_HOME and run a catupgrd / catrelod out of the 126.96.36.199 dirs ?
Edited by: allgoodnamesaretaken on 31-Jul-2012 13:57
The most painless way to get from 188.8.131.52 to 184.108.40.206 in order is:
1. Fire your developers ... these people cost you time, your organization money, and gave you an opinion without a single shred of fact to support it: These are dangerous people. Next time they might make a more serious mistake.
2. Upgrade the way you successfully upgraded the first time.
All that said ... run this past Oracle by opening an SR just to "Cover Your ...."
Just wonder, Dont you get any information your 3th party tool certified or not certified wiht that version? Secondly You already mention you made upgrade wihtout any issue so why you are looking different path:) Journey? :)
Anyway check below note :
Different Upgrade Methods For Upgrading Your Database [ID 419550.1] PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding