Re: Downgrading to Standard Edition

From: Karl Arao <karlarao_at_gmail.com>
Date: Mon, 27 Jul 2009 21:02:18 +0800
Message-ID: <12ee65600907270602h25227270ybcb650c418f80d8c_at_mail.gmail.com>

I think you should use the SE software. Just follow the Metalink note below.

Converting from Enterprise Edition to Standard Edition

          Doc ID: Note:139642.1

See the snippet from the note..

Actions:

---

    The only way to properly convert from an Enterprise Edition back to a     Standard Edition is through an Export/Import operation. This way you will     get rid of all Enterprise Edition specific Data Dictionary objects, as the     SYS schema objects are not exported. The Standard Edition EXP utility is     preferred to be used to export the data.

    After the Import in the Standard Edition database, you only need to drop     all user schemas related to Enterprise Edition features, such as the MDSYS     account (used with Oracle Spatial).

Then to convert from SE to EE. Here are the steps:

To convert and switch the "10.2.0.1 SE database" to be run from "10.2.0.3 EE + CPU"
Following are the steps (this assumes they're on the same box):

1. Shutdown the database
2. Take complete cold backup of the database
3. Copy pfile/spfile (that used to start the database) to <10.2.0.3 EE>/dbs , Also you may have to edit the /etc/oratab to point to the 10.2.0.3 EE home
4. Refer 10.2.0.3 Patchset README and Complete the '10.2.0.3 patchset Post installation steps' i.e executing catupgrd.sql in upgrade mode
5. Refer CPU Patch README, and complete 'CPU Patch Post Installation steps' i.e executing catcpu.sql
6. Now database conversion from '10.2.0.1 SE' to '10.2.0.3 EE + CPU' is completed

do you have to run catalog and catproc?
catupgrd.sql automatically calls catalog and catproc scripts. There is no need to execute them manually

• Karl Arao http://karlarao.wordpress.com -- http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 27 2009 - 08:02:18 CDT