oracle 12c 标准版 企业版,【翻译自mos文章】将Oracle 12c数据库从标准版convert到企业版...

How to Convert Oracle Database 12c from Standard to Enterprise Edition ? (文档 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 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 Enterprise 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, where SID is the instance name.

4) Back up all database files under the current Oracle home that you must keep.

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

NOTE : This step deletes all existing database files that 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 an Oracle home on Windows, use the following syntax:

setup.exe –deinstall –home path_of_Oracle_home_to_be_deinstalled

To deinstall an 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 was used for the Standard Edition that you uninstalled, or select a new Oracle home. During the installation, be sure to select Enterprise Edition. When prompted, choose Software Only from the Database Configuration screen.

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

If your existing database is on Windows, 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 Edition 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

原文：http://blog.csdn.net/msdnchina/article/details/50644920