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

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 12.1.0.2, then you should upgrade to release 12.1.0.2 of the Enterprise Edition.

• Backup the database.

 Make a backup copy of files under $Oracle_Home/network/admin. This ensures that the listener is  configured after you complete the steps in this procedure.

 Back up all database files under the current Oracle home that you need to keep.

 On Linux, back up $Oracle_Home/dbs/.

 On Windows, back up $Oracle_Home/database/.

• 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;

BANNER

——————————————————————————–

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

PL/SQL Release 12.1.0.2.0 – Production

CORE 12.1.0.2.0 Production

TNS for Linux: Version 12.1.0.2.0 – Production

NLSRTL Version 12.1.0.2.0 – Production