Upgrading 11R2 database instance from Standard Edition to Enterprise License with Partitioning
We are about to upgrade a 11R2 database instance from Standard Edition to Enterprise License to add many users and to utilize the Partitioning Option. This is a very large dataset and I was wondering if it necessary to export/import the data or if I could use my usual procedure to upgrade just the Oracle binaries with a point release upgrade?
That is to say, I install the new binaries in the same Oracle base, but with a new HOME and shut down the instance, Listener, and emctl. The path changes from, say, /app/oracle/product/v112030s (for Std edition) to /app/oracle/product/v112030e (for Enterprise). Then I copy the appropriate config files, edit where needed, rerun the modified .bash_profile to reset my environment. After that I can usually just start up the instance, listener, and emctl and everything is fine -- at least for when I go from something like 10.2.0.3 to 10.2.0.4 or from 11.2.0.2. to 11.2.0.3.
That is to say, I install the new binaries in the same Oracle base, but with a new HOME and shut down the instance, Listener, and emctl. The path changes from, say, /app/oracle/product/v112030s (for Std edition) to /app/oracle/product/v112030e (for Enterprise). Then I copy the appropriate config files, edit where needed, rerun the modified .bash_profile to reset my environment. After that I can usually just start up the instance, listener, and emctl and everything is fine -- at least for when I go from something like 10.2.0.3 to 10.2.0.4 or from 11.2.0.2. to 11.2.0.3.
1