"Translated from MOS article" Convert Oracle 12c Database from Standard Edition to Enterprise Edition

Source: Internet
Author: User


Convert Oracle 12c Database from Standard Edition to Enterprise Edition
From:


How to Convert the Oracle Database 12c from standard to Enterprise Edition? (Document ID 2046103.1)





Applies To:Oracle database-enterprise edition-version 12.1.0.1 and later
information in this document applies to any platform.
GOAL





How to Convert the Oracle Database 12c from standard to Enterprise Edition?


Solution


Follow the steps below to convert the Oracle 12c database from standard Edition to Enterprise Edition:



1) Ensure that the release number of your Oracle standard Edition Server software is the same release as your Oracle Enter Prise Edition Server Software.

2) Shut down your database.

3) If your operating system is Windows, then stop all Oracle services, including the Oracleservicesid Oracle service, wher E SID is the instance name.

4) Back to all database files under the current Oracle home this must keep.

5) Deinstall the standard Edition server software. (It is optional-deinstall the standard Edition software)



Note:this step Deletes all existing database files, reside under the Oracle home.

Run the Deinstallation tool from the Oracle home. The Deinstallation tool is available as a separate command (deinstall) under the Oracle home directory after installation. It is located under Oracle_home\deinstall.

To deinstall a Oracle home on Windows with the following syntax:


Setup.exe–deinstall–home path_of_oracle_home_to_be_deinstalled



To deinstall a Oracle home on Linux and UNIX, use the following syntax:


$./runinstaller–deinstall–home path_of_oracle_home_to_be_deinstalled




Note:
Starting with Oracle Database 12c, the deinstallation tool is integrated with the database installation media. 
You can run the deinstallation tool using runInstaller on Linux and UNIX or setup.exe on Windows with the -deinstall and -home options from the base directory of the Oracle Database, Oracle Database Client, or Oracle Grid Infrastructure installation media.



6) Install Oracle Enterprise Edition Server Software Using Oracle Universal Installer (OUI).

   Select the same Oracle home that is used for the standard Edition so you uninstalled, or Select a New Oracle home. During the installation, being sure to select Enterprise Edition. When prompted, choose software is only from the Database Configuration screen.

7) If you have a existing database, then point your oracle_sid to this pre-existing database.

    If Your existing database is on Windows and then you must re-create the DB service using oradim.
8) Start up your database.

NOTE:  there is  NO need to run the Catalog.sql and Catproc.sql scripts to convert standard Edi tion to  Enterprise Edition.

Your database is now converted to Oracle database Enterprise Edition.



You can verify the same from the banner:


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





"Translated from MOS article" Convert Oracle 12c Database from Standard Edition to Enterprise Edition


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.