How to Move From the Standard Edition to the Enterprise Edition?

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, then you should upgrade to release 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.
You can verify it from the banner:

SQL> select banner from v$version;

Oracle Database 12c Enterprise Edition Release – 64bit Production
PL/SQL Release – Production
CORE Production
TNS for Linux: Version – Production
NLSRTL Version – Production


Leave a Reply

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

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

Facebook photo

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

Connecting to %s