Pavan DBA's Blog

The DBA Knowledge Store

Moving From the Standard Edition to the Enterprise Edition

Posted by Pavan DBA on December 21, 2009


If you are using the Standard Edition of the Oracle Database and want to move to the Enterprise Edition, then complete the following steps:

  • Ensure that the release number of your Standard Edition server software is the same release as the Enterprise Edition server software.For example, if your Standard Edition server software is release 10.2.0, then you should upgrade to release 10.2.0 of the Enterprise Edition. 
  • Shut down your database. 
  • If your operating system is Windows, then stop all Oracle services, including the OracleServiceSID Oracle service, where SID is the instance name. 
  • Deinstall the Standard Edition server software.
  • Install the Enterprise Edition server software using the Oracle Universal Installer.Select the same Oracle home that was used for the de-installed Standard Edition. During the installation, be sure to select the Enterprise Edition. When prompted, choose Software Only from the Database Configuration screen. 
  • Start up your database.

Your database is now upgraded to the Enterprise Edition.

Note:
If you have a Standard Edition database at a release prior to Oracle Database 10g, you can change it to an Enterprise Edition database by first installing the Enterprise Edition and then following the normal upgrade procedures, as described in this manual.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: