We are Converting Oracle Database Standard Edition 19c to Oracle Database Enterprise Edition within same server.
Existing DB Name:-SEORCL (19c Standard Edition 2) and Server Name:- pathindia
Migrated DB Name:-SEORCL (19c Enterprise Edition) on same Server Name:- pathindia
Step-1 We have running Oracle Database Standard Edition in ORACLE_HOME=/Data01/app/oracle/product/19.0.0/dbhome_1
Database is running with the version 19.22.0.0.0
Step-2 Install new home in /MyPost/app/oracle/product/19.0.0/dbhome_1 just indicate EE during installation.
Create directory as shown below snapshot
Step-3 Download Oracle DB Enterprise edition software and transfer it to created directory.
Now unzip binary on this location.
Command:- unzip -o /Data01/app/V982063-01.zip -d /MyPost/app/oracle/product/19.0.0/dbhome_1
Step-4 Download/Transfer the patch (which applied on SE database) and apply on the new binary.
First, we need to update latest Opatch utility and check version
Step-5 Execute the runinstaller with apply (same patch on Source SE database) as shown below snap
Note: - export CV_ASSUME_DISTID=OL7 -- If software is installed on RHEL 8/OL8
Choose the Enterprise Edition on next screen as shown below
Runinstaller ask you to executes below scripts as below snap
Once script executed successfully, Installation done.
Step-6 Shutdown the existing listener and database from SE ORACLE_HOME
Change new ORACLE_HOME in oratab and .bash_profile
cat /etc/oratab
Step-7 Copy listener.ora, tnsnames.ora, sqlnet.ora, initORCL.ora, orapwORCL to new home
Go to the New ORACLE_HOME and Change the ORACLE_HOME location in these copied files
Step-8 Create pfile from spfile in existing Standard Edition Database and change the location of ORACLE_HOME.
Copy this pfile to the new location and we can start database using this parameter file later.
Changing the location in parameter file as below
Set the new environment (Setting new ORACLE_HOME)
Note:- On this step, we need to disable the old ORACLE_HOME
Step-9 Now we are ready to set the environment as below
Connect to the database using sqlplus
Step-10 Once we ensure that we are at the right place, start the database
Check the database details as below.
Now create spfile from pfile
Start the listener as well.
Check the listener and DB process
This activity is successfully completed. ……………………..Thank you and Enjoy...............stay connected.
Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
A. Rawat
Email: 88arawat@gmail.com