Vycházel jsem z oficiální dokumentace, ale několik informací tam chybělo, tak jsem své poznámky doplnil přímo do textu.
Moving From Standard Edition to Enterprise Edition of Oracle Database
Z dokumentace důležitá poznámka:
Deinstallation of the Oracle home in the earlier release of Oracle Database may result in the deletion of the old Oracle base that was associated with it
Cause: After upgrading from Oracle Database release 11.2.0.1 or 11.2.0.2 to release 11.2.0.4, deinstallation of the Oracle home in the earlier release of Oracle Database may result in the deletion of the old Oracle base that was associated with it. This may also result in the deletion of data files, audit files, etc., which are stored under the old Oracle base. Important Note: This issue is applicable for upgrades from release 11.2.0.1 or 11.2.0.2 to 11.2.0.4, but is not applicable for upgrading from release 11.2.0.3 to 11.2.0.4.
Action: Before deinstalling the Oracle home in the earlier release, edit the orabase_cleanup.lst file found in the $Oracle_Home/utl directory and remove the „oradata“ and „admin“ entries. Then proceed with the deinstallation.
Současná edice
c:\Oracle\app\11.2.0.3\db_home1\OPatch>sqlplus ****
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 6 11:22:31 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production <---- Standard edice SQL>
1) To change your existing Standard Edition database to an Enterprise Edition database
Ensure that the release number of your Standard Edition server software is the same release as Enterprise Edition server software.
For example, if your Standard Edition server software is release 11.1.0.6, then you must upgrade to release 11.1.0.6 of Enterprise Edition.
= Nejlepší použít opatch c:\Oracle\app\11.2.0.3\db_home1\OPatch>opatch lsinventory Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : c:\Oracle\app\11.2.0.3\db_home1 Central Inventory : C:\Program Files\Oracle\Inventory from : n/a OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : c:\Oracle\app\11.2.0.3\db_home1\cfgtoollogs\opatch\opatch2014-06-06_10-58-35AM.log
Lsinventory Output file location : c:\Oracle\app\11.2.0.3\db_home1\cfgtoollogs\opatch\lsinv\lsinventory2014-06-06_10-58-35AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0 There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
2) Shut down your database.
= Zastavte všechny services, které souvosí s Oracle (většinou mají slovo oracle v názvu)
3) If your operating system is Windows, then stop all Oracle services, including the OracleServiceSID Oracle service, where SID is the instance name.
4) Make a backup copy of files under $Oracle_Home/network/admin. This ensures that the listener is configured after you complete the steps in this procedure.
= Odkopírujte si oba dva adresáře do záloh
On Linux, back up $Oracle_Home/dbs/.
On Windows, back up $Oracle_Home/database/.
5) Edit the orabase_cleanup.lst file found in the Oracle_Home/utl directory and remove the „oradata“ and „admin“ entries. Refer to „Deinstallation of the Oracle home in the earlier release of Oracle Database may result in the deletion of the old Oracle base that was associated with it“.
Deinstall Standard Edition server software. (This step deletes all existing database files that reside under Oracle home.)
= U verze 11.2.0.4 tam dané adresáře již nejsou defaultně obsaženy.
6)Run the deinstall tool from the Oracle home.
– viz článek ODSTRANĚNÍ ORACLE_HOME NA OS WINDOWS
7) Install Enterprise Edition server software using Oracle Universal Installer (OUI).
= v mém případě p10404530_112030_MSWIN-x86-64 –> setup.exe – software only
8) Select the same Oracle home that was used for the Standard Edition that you uninstalled. During the installation, be sure to select Enterprise Edition. When prompted, choose Software Only from the Database Configuration screen.
Start up your database. –> to není jen tak
– copy admin and network directory back to Oracle_HOME
– start listener (Service will be created)
= lsnrctl start LISTENER
– create database service
= použiji utilitu oradim
D:\Source\deinstall>oradim -new -sid ORCL11R2 -startmode A -maxusers 100 -pfile c:\Oracle\app\11.2.0.3\db_home1\database\initorcl11r2.ORA -timeout 60 Instance created.
– create directories [záleží co máte v init souboru]
c:\Oracle\fast_recovery_area\
– copy control file CONTROL02.CTL
– copy redo logs do FRA
9) Your database is now upgraded to Enterprise Edition.
Požadovaná edice
D:\Source\deinstall>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 6 18:09:12 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production <---- Enterprise edice
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>