Re: Downgrading to Standard Edition
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Mon, 27 Jul 2009 21:02:18 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
