Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Jul 6 '13 at 14:03

This question came from our site for professional and enthusiast programmers.

    
From my research, It seems like you have to uninstall standard edition, then reinstall enterprise edition in order to upgrade? –  001 Jul 6 '13 at 4:31

1 Answer 1

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.

share|improve this answer
    
0. Shutdown the standard edition instance cleanly? –  David Aldridge Jul 9 '13 at 16:17
    
@DavidAldridge Yes, this step is necessary too. But answer provided to demonstrate level of complexity rather than give detailed instructions. For more detailed instruction you must look to oracle documentation, e.g. "How to Convert Database from Standard to Enterprise Edition ? [ID 117048.1]" article on MyOracleSupport (former Metalink). –  ThinkJet Jul 10 '13 at 5:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.