Convert Database from Standard Version to Enterprise Version. 12.2

Steps to convert the Standard Database to Enterprise Edition… in a real world…

How to Convert Oracle Database 12c from Standard to Enterprise Edition ? (Doc ID 2046103.1)

1.) Take a FULL backup of the database, if possible OFFLINE;
2.) Install the new binary in the different ORACLE_HOME;
3.) Check the PATCHES, the new ORACLE_HOME should be at least on the same level of PATCHES. So , if needed apply the PSUs / One-OFFs …
4.) If you are using the GRID Infrastructure, the ORACLE_HOME must be changed with srvctl;
5.) create pfile from spfile in order to keep the current INIT of the database;
6.) Shut immediate the database;
7.) Copy the INIT created based on spfile to the NEW ORACLE HOME;
8.) Copy the Password File to the NEW ORACLE HOME;
9.) If needed do some changes into INIT file;
10.) Change the /etc/oratab to the new ORACLE_HOME
11.) . oraenv to the database, whith this all ENV variables will bet set accordingly;

12.) Check the current configuration;

[oracle@vddl-ocm-odg-01 dbs]$ srvctl config database -d db02
Database unique name: db02
Database name: db02
Oracle home: /opt/oracle/product/12.2.0.1/dbhome_2
Oracle user: oracle
Spfile: /opt/oracle/product/12.2.0.1/dbhome_2/dbs/spfiledb02.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups:
Services:
OSDBA group:
OSOPER group:
Database instance: db02

13.) Create spfile from pfile, in order to create the new spfile on the new ORACLE_HOME;

sqlplus / as sysdba

create spfile from pfile;

14.) Change the HAS:
srvctl modify database -d db02 -oraclehome /opt/oracle/product/12.2.0.1/dbhome_1 -spfile /opt/oracle/product/12.2.0.1/dbhome_1/dbs/spfiledb02.ora

15.) Check: 
[oracle@vddl-ocm-odg-01 dbs]$ srvctl config database -d db02
Database unique name: db02
Database name: db02
Oracle home: /opt/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: /opt/oracle/product/12.2.0.1/dbhome_1/dbs/spfiledb02.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups:
Services:
OSDBA group: dba
OSOPER group:
Database instance: db02

16.) Start the database:

srvctl start database -d db02

17.) Check HAS

[oracle@vddl-ocm-odg-01 dbs]$ crsctl stat res -t
---------------------------------------------------------------------------
Name Target State Server State details
---------------------------------------------------------------------------
Local Resources
---------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.ons
OFFLINE OFFLINE vddl-ocm-odg-01 STABLE
---------------------------------------------------------------------------
Cluster Resources
---------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.db02.db
1 ONLINE ONLINE vddl-ocm-odg-01 Open,HOME=/opt/oracl
e/product/12.2.0.1/d
bhome_1,STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.orcl.db
1 ONLINE ONLINE vddl-ocm-odg-01 Open,HOME=/opt/oracl
e/product/12.2.0.1/d
bhome_1,STABLE
---------------------------------------------------------------------------

18.) Check DB

1* select * from v$version
SQL> /

BANNER CON_ID
----------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 -64bit Production
PL/SQL Release 12.2.0.1.0 - Production 0
CORE 12.2.0.1.0 Production 0
TNS for Linux: Version 12.2.0.1.0 - Production 0
NLSRTL Version 12.2.0.1.0 - Production 0

19.) Check the components:

set lin 400
set pages 10000
col comp_name format a60
col status format a20

1* select comp_name, status, version, namespace, startup
from dba_registry

SQL> /

COMP_NAME STATUS VERSION NAMESPACE STARTUP
————————————————————– ——–
Oracle Database Catalog Views VALID 12.2.0.1.0 SERVER
Oracle Database Packages and Types VALID 12.2.0.1.0 SERVER
JServer JAVA Virtual Machine VALID 12.2.0.1.0 SERVER
Oracle XDK VALID 12.2.0.1.0 SERVER
Oracle Database Java Packages VALID 12.2.0.1.0 SERVER
OLAP Analytic Workspace OPTION OFF 12.2.0.1.0 SERVER
Oracle Real Application Clusters OPTION OFF 12.2.0.1.0 SERVER
Oracle XML Database VALID 12.2.0.1.0 SERVER
Oracle Workspace Manager VALID 12.2.0.1.0 SERVER
Oracle Text VALID 12.2.0.1.0 SERVER
Oracle Multimedia VALID 12.2.0.1.0 SERVER
Spatial OPTION OFF 12.2.0.1.0 SERVER
Oracle OLAP API OPTION OFF 12.2.0.1.0 SERVER
Oracle Label Security VALID 12.2.0.1.0 SERVER
Oracle Database Vault VALID 12.2.0.1.0 SERVER

20.) execute some tests to validate the database;

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