Oracle upgrade - Best approach ?
I have rarely upgraded the existing installation. In most cases I have simply installed the latest version and moved the data across. Because I have also moved around frequently I have not needed to perform many upgrades. There are several methods for upgrading that I am aware of.
What is considered to be the best practice when upgrading the Oracle Database and perhaps even Oracle Applications?
Thanks
Re: Oracle upgrade - Best approach ?
Quote:
Originally posted by roadwarriorDBA
I have rarely upgraded the existing installation. In most cases I have simply installed the latest version and moved the data across. Because I have also moved around frequently I have not needed to perform many upgrades. There are several methods for upgrading that I am aware of.
What is considered to be the best practice when upgrading the Oracle Database and perhaps even Oracle Applications?
Thanks
If you are able to build a new database with the new version, eport from the old and import into the new, then IMHO, that would be the best way. But if you can't get the down time, then you need to upgrade in place. Install Oracle into a new home, shutdown the database, startup the database from the new home and run the upgrade scripts.
But you should have already read the migration documentation from Oracle, upgraded you test database, and done a full round of regression testing. Are there any features of Oracle that contradict features that you are using? Like if you want to go to an automatic undo tablespace and you use set transaction to aquire a rollback you code needs to be changed before you go to automatic undo.