Wednesday, November 3, 2010

Convert from Oracle Standard Edition to Enterprise Edition

The following steps need to be taken to convert your SE database to an EE

1- Take Offline Backup of your database.
2- De-install the Standard Edition software.
3- Install the Enterprise Edition software and check that the release version of your Standard Edition software is the same as the Enterprise Edition software.
4- Create a new database with the same name of your old database.
5- Restore the backup of your old database to the new one.
6- Startup the database
7- Run the "catalog.sql" and "catproc.sql" scripts.
Your database is now using the Enterprise Edition (EE) version of the software.

No comments: