Oracle Standard edition to Enterprise edition with same version / higher version

Hello All,

Recently I had changed one of our test DB from Standard edition to enterprise edition,

Prerequisite:

Oracle version: Same version

OS: Same  ( I tested on Linux)


Note: SQL.BSQ script is used to create database of any version ( SE/EE) hence SE /EE database will be almost same with some higher features in EE,  hence version migration (SE to EE) is not complicated.


Refer following steps:

1. Backup the database. (As per your regular full backup policy).

2. If space available, take  cold backup. (Oracle home ,Repository etc)

3. Install Enterprise edition (Software only) in different mount point called as different ORACLE_HOME.

4. In linux you can export new ORACLE_HOME  & existing ORACLE_SID.

5. Startup database;

6. At this stage database will still have SE catalogs. hence to update it to EE run following commands

"catalog.sql"
 "catproc.sql"


7.Restart the database and check DB version.


For Higher version upgradation like 11.2.0.1 of SE to 11.2.0.4 of EE

1 to 4 steps will be the same.

5. startup upgrade;

6. use catupgrd.sql or DBUA utility.

7.Restart the db and check of registry components 

We dont need to run catalog.sql or catproc.sql, because  catupgrd.sql will call these files internally as part of upgradation.