I installed the 220.127.116.11 patch to 18.104.22.168 release on a production and development node on AIX machine. Now my director wants me to go back to 8.1.6 release.
First, how do I accomplish this since the patch is permanent?
Second, how do I preserve the current database?
Third, will this database open if I import it to 8.1.6 from 22.214.171.124?
12-20-2000, 01:11 PM
I think all you need to do is install 126.96.36.199 in a seperate $ORACLE_HOME. Then, you shutdown the database using the 188.8.131.52 executables and open the database using the 184.108.40.206 executables.
12-20-2000, 02:02 PM
Thats work around, if can't afford to have down time/transaction loss, and the database is up and runing. If you can, restore it from cold back up and apply redo log... still you should be okay if your transaction rate is not that much and redolgs are of sufficient size.
Not sure whats your situation. Solution is based on your situation.
I don't see any work around as binaries got upgraded. If you are looking for specific oracle product option which is not working say like replication or whatever... see the scripts comments for those options in $O_H/rdbms/admin directory...
and try to rerun prv version script for that option. Just trial.
12-20-2000, 02:19 PM
You may want to consider an upgrade to 220.127.116.11...
12-20-2000, 04:39 PM
If I install 18.104.22.168 on another node and then export the DB from 22.214.171.124, do you think there will be a problem importing it on the new node? What do I have to do to make sure it will open up without corruption?
12-20-2000, 04:55 PM
I would do like marist89 suggested.
Don't forget to run catalog,catproc, catrep,...
12-21-2000, 12:33 PM
I would like to upgrade to 126.96.36.199 but I have been told that that will not happen since all the release nationwide is 8.1.6. If there is any thing to be concerned about on export let me know. Thanks.