Migrate Oracle Database Standard Edition to Enterprise Edition - Convert SE to EE Step by Step Demo!
You are using a Standard Edition (SE) database and want to convert it to the Enterprise Edition (EE) because functionality you require is not part of the SE. Since the same "SQL.BSQ" script is used to create the database for each version, the databases are internally almost identical. The conversion process is therefore not much complicated.
Backup the database and Oracle Home.
/u01/app/oracle/product/12.2.0.1/se_1
Back up all database files under the current Oracle home that you need to keep.
- On Unix, backup $ORACLE_HOME/dbs/.
- On Windows, backup $ORACLE_HOME/database/.
- $ORACLE_HOME/network/admin
Install the EE software in a new ORACLE_HOME.
/u01/app/oracle/product/12.2.0.1/ee_1
Copy the Listener files and parameter files in new oracle home.
Startup the database from new home of Enterprise Edition.
Run the “catalog.sql” and “catproc.sql” scripts. (the execution of these two scripts may be not mandatory in all the cases but better to run them because of complexity of data dictionary and to be sure that all EE objects are created)
Recompile all invalid objects in the database by executing utlrp.sql script. You can execute this script 2-3 times to validate the dependencies.
Note: Please ensure that the release number (and patch level) of your Enterprise Edition server software is the same release as the original Standard Edition server software.
For example, if your Standard Edition server software is release 12.2.0.1, then you must use release 12.2.0.1 of the Enterprise Edition
You can verify current edition of the oracle database by connecting to the database or by querying the v$banner view.
Hope this helps!
Cheers!
Ramesh.
Post a Comment: