Upgrade (Move) Database 12.1.0.2 from Standard Edition to Enterprise Edition.

In this Document we will Move/Upgrade Licensing version from Standard Edition to Enterprise Edition for 12.1.0.2 Standalone database.

Prerequisites

We need to download exact version of database Binary as it is on existing system. i.e 12.1.0.2.
We will download Opatch and latest Patch version from E-delivery for the same. Links are as below.
Once all software downloaded sent this to target hosts.

A-> Download 12.1.0.2 as below



Download OPatch & Latest Patch from below link.




B->Post that we will collect below information from existing database using below Query.

 -> Component Status
SQL> col COMP_NAME format a50;
set linesize 300
set pagesize 100
select COMP_NAME, version, status from dba_registry;

-> SQL Patch status
set lines 1234
col ACTION_TIME for a40
col status for a10
col BUNDLE_SERIES for a20
col DESCRIPTION for a50
select action_time, patch_id, patch_uid, status, description from dba_registry_sqlpatch;

-> Invalid Object Status
SQL> select count(*) from dba_objects where status='INVALID' and owner in ('SYS','SYSTEM');

-> DB FILE paths -to confirm no DBFILE should be in DBS location.
SQL > select file_name from dba_data_files;

-> Username and account  status
SQL> select username,account_status from dba_users where account_status in ('EXPIRED','LOCKED');

-> INVALID OBJECTS Count Owner wise
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;

-> SPFILE and CONTROLFILE path
SQL> show parameter pfile

-> Version Details
SQL> select * from v$version

-> Tablespace Details
SQL> select * from v$tablespace

-> Backup of current controlfile
SQL> alter database backup controlfile to trace as '/backup/controlfile.txt';

Setup Steps

A-> Post Download of Software we need to create NEW ORACLE_HOME on target server as below

oracle@DBN1PRE:/backup/12c_Binary_EE$ cd /u02/app/oracle/product/12.1.0
oracle@DBN1PRE:/backup/12c_Binary_EE$ mkdir dbhmome_2
oracle@DBN1PRE:/backup/12c_Binary_EE$ cd -

B-> Unzip Downloaded Binary of 12.1.0.2

oracle@DBN1PRE:/backup/12c_Binary_EE$ ls -lrt
total 19879260
-rw-r--r--   1 oracle   oinstall 84582164 May 10 13:08 p6880880_210000_SOLARIS64.zip
-rw-r--r--   1 oracle   oinstall 1147043852 May 10 13:13 V46108-01_2of2.zip
-rw-r--r--   1 oracle   oinstall 1765484858 May 10 13:18 V46108-01_1of2.zip
-rw-r--r--   1 oracle   oinstall 7173089948 May 10 13:39 p33711081_121020_SOLARIS64.zip

oracle@DBN1PRE:/backup/12c_Binary_EE$
oracle@DBN1PRE:/backup/12c_Binary_EE$ unzip V46108-01_1of2.zip
oracle@DBN1PRE:/backup/12c_Binary_EE$ unzip V46108-01_1of2.zip

C-> Now we will install Binary to new Oracle_Home and we will use silent installation method
oracle@DBN1PRE:/backup/12c_Binary_EE$ cat ora.rsp |grep -v "#"
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=DBN1PRE
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u02/app/oracle/product/12.1.0/dbhome_2
ORACLE_BASE=/u02/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=oinstall
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

Now we need to move to unzipped location and execute runInstaller as below.

oracle@DBN1PRE:/backup/12c_Binary_EE$ cd /backup/12c_Binary_EE

./runInstaller -silent -responseFile -executePrereqs /backup/12c_Binary_EE/ora.rsp

Post installation execute root.sh as below

oracle@DBN1PRE:~# /u02/app/oracle/product/12.1.0/dbhome_2/root.sh

Now setup for new 12.1.0.2 is completed on New Oracle_Home.

D-> Now copy all listener.ora,sqlnet.ora ,tnsnames.ora from OLD ORACLE_HOME to NEW ORACLE_HOME

E-> Copy password file ,init$ORACLE_SID.ora file from OLD ORACLE_HOME to NEW ORACLE_HOME.

Migration Steps

As setup completed, we will proceed to Migration steps as below

A-> Shutdown DB from OLD ORACLE_HOME
SQL> Shut immediate

B-> Change value of ORACLE_HOME in .profile to NEW ORACLE_HOME and source that file

C-> Start DB from NEW ORACLE_HOME
SQL> Startup

Post Installation Steps

Post migration we need to collect below information.
-> Component Status
SQL> col COMP_NAME format a50;
set linesize 300
set pagesize 100
select COMP_NAME, version, status from dba_registry;
-> SQL Patch status
set lines 1234
col ACTION_TIME for a40
col status for a10
col BUNDLE_SERIES for a20
col DESCRIPTION for a50

select action_time, patch_id, patch_uid, status, description from dba_registry_sqlpatch;
-> Invalid Object Status
SQL> select count(*) from dba_objects where status='INVALID' and owner in ('SYS','SYSTEM');
-> DB FILE paths -to confirm no DBFILE should be in DBS location.
SQL > select file_name from dba_data_files;
-> Username and account  status
SQL> select username,account_status from dba_users where account_status in ('EXPIRED','LOCKED');
-> INVALID OBJECTS Count Owner wise
SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner
-> SPFILE and CONTROLFILE path
SQL> show parameter pfile
-> Version Details
SQL> select * from v$version
-> Tablespace Details
SQL> select * from v$tablespace

Please verify that Now new oracle database is migrated to ENTERPRISE EDITION.
Post verification proceed to apply PSU patches on NEW ORACLE_HOME.
Optionally we can De-install OLD ORACLE_HOME .