Convert Oracle SE to EE

Upgrading Oracle database from Standard Edition to Enterprise Edition is very simple.

For example, we have running Oracle SE in ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1

Let’s start converting it…

1. Install new home in /u01/app/oracle/product/12.1.0/dbhome_2 just indicate EE during installation(not SE).
   Response file entries(db_install.rsp):

   ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2
   oracle.install.db.InstallEdition=EE

2. Shutdown database and listener from old home.

   . oraenv
   ORACLE_SID = [ORCL] ?
   
   lsnrctl stop
   sqlplus / as sysdba
   shutdown immediate;

3. Change ORACLE_HOME in oratab and .bash_profile

   cat /etc/oratab
   ORCL:/u01/app/oracle/product/12.1.0/dbhome_2:Y

   cat ~/.bash_profile
   export ORACLE_BASE=/u01/app/oracle
   export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2
   export LD_LIBRARY_PATH=$ORACLE_HOME/lib
   export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
   export PATH=$PATH:$ORACLE_HOME/bin
   export ORACLE_SID=EYC
   export TNS_ADMIN=$ORACLE_HOME/network/admin
   export EDITOR=vi

4. Copy listener.ora, tnsnames.ora, sqlnet.ora, spfileORCL.ora, orapwORCL to new home

   cp /u01/app/oracle/product/12.1.0/dbhome_1/network/*.ora /u01/app/oracle/product/12.1.0/dbhome_2/network/
   cp /u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfileORCL.ora /u01/app/oracle/product/12.1.0/dbhome_2/dbs/
   cp /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwORCL /u01/app/oracle/product/12.1.0/dbhome_2/dbs/

   Please verify that you don’t have old ORACLE_HOME indicated anywhere in these files.

5. Renew environment variables

   . oraenv
   ORACLE_SID = [ORCL] ? 
   
   which sqlplus
   /u01/app/oracle/product/12.1.0/dbhome_2/bin/sqlplus
   
   sqlplus / as sysdba
   startup;

6. Check that you have EE

   SQL> select banner from v$version;
   
   BANNER
   --------------------------------------------------------------------------------
   Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
   PL/SQL Release 12.1.0.1.0 - Production
   CORE    12.1.0.1.0      Production
   TNS for Linux: Version 12.1.0.1.0 - Production
   NLSRTL Version 12.1.0.1.0 - Production