I installed the 126.96.36.199 patch to 188.8.131.52 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 184.108.40.206?
12-20-2000, 12:11 PM
I think all you need to do is install 220.127.116.11 in a seperate $ORACLE_HOME. Then, you shutdown the database using the 18.104.22.168 executables and open the database using the 22.214.171.124 executables.
12-20-2000, 01: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, 01:19 PM
You may want to consider an upgrade to 126.96.36.199...
12-20-2000, 03:39 PM
If I install 188.8.131.52 on another node and then export the DB from 184.108.40.206, 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, 03:55 PM
I would do like marist89 suggested.
Don't forget to run catalog,catproc, catrep,...
12-21-2000, 11:33 AM
I would like to upgrade to 220.127.116.11 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.