Upgrade path – Oracle Standard to Oracle Enterprise

oracle

Could I start on Oracle Standard edition and easily upgrade to Oracle Enterprise?

Or do I need to rebuild the entire server? how does the upgrade path work?

Best Answer

It's easy because internal database structure almost identical:

  1. Backup all database files and /network/admin (just for sure);
  2. Uninstall Standard Edition;
  3. Install Enterprise Edition;
  4. Point ORACLE_SID to old database;
  5. Startup database and run catalog.sql and catproc.sql from new version;
  6. Recompile all invalid objects.

Note that software version, release number and patch level must be identical.