Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


oracle downgrade from enterprise edition to standard edition


Hello,  my oracle version is 10.2.0.4 on windows 64 bit enterprise edition, if i wants to bring the database in windows 64 bit standard edition, so what is the process.  Thanks in advance.

See metalink note 139642.1  Regards, Prathmesh

Hi,  can you read my forum once again,  iam not downgrading the database, right now my database is on windows 2003 enterprise edition 64 bit, i want to start the database in windows 2003 standard edition 64 bit.  what iam thinking is. 1) take the cold backup  2) install new windows standard edition and then 3) restore  is it suffiecient?

well that depends. are you using any enterprise edition features which will compromise your application by running on standard edition.  regards  Alan

are you using any enterprise edition features which will compromise your application by running on standard edition.   can you please tell me in brief,

CKPT wrote: Hi,  can you read my forum once again,  iam not downgrading the database, right now my database is on windows 2003 enterprise edition 64 bit, i want to start the database in windows 2003 standard edition 64 bit.  what iam thinking is. 1) take the cold backup  2) install new windows standard edition and then 3) restore  is it suffiecient? No this is not correct.You can use exp/imp or transportable tablespace feature,please see below metalink note: 10G : Step by Step Procedure to Migrate from Enterprise Edition to Standard Edition [ID 465189.1]

hi, run this script  http://www.oracle-base.com/dba/Script.php?category=10g&file=feature_usage.sql  this will tell you all you need to know.  regards  Alan

Chinar,  iam not downgrading my database, my database will be in same version and release, iam asking about OS environment,  my present OS : win 2003 Enter prise edition 64 bit i want to run the database in : win 2003 standard edition 64 bit  Thanks.

CKPT wrote: Chinar,  iam not downgrading my database, my database will be in same version and release, iam asking about OS environment,   my present OS : win 2003 Enter prise edition 64 bit i want to run the database in : win 2003 standard edition 64 bit  Thanks.  Dear CKPT did you actually see metalink doc 465189.1? This is not downgrade,this is migrate.Please read this document

Hi Chinar, Thanks, but still my question unanswered, i checked metalink but it mentined how to migragte from enterprise edition to statndard edition of ORACLE, i am asking , about WINDOWS 2003 Enterprise edition to Standard edition.  can you tel me any information needed on this.

CKPT wrote: Hi Chinar, Thanks, but still my question unanswered, i checked metalink but it mentined how to migragte from enterprise edition to statndard edition of ORACLE, i am asking , about WINDOWS 2003 Enterprise edition to Standard edition.  can you tel me any information needed on this.  1.Take full export from EE database(enterprise edition). 2.Install SE software and create new database. 3.Import .dmp file into SE database. 4.Complile invalid objects as  sqlplus "/as sysdba" @$ORACLE_HOME/rdbms/admin/utlrp.sql 

good, here my question is, if i take complete cold backup, it will work or not.

CKPT wrote: good, here my question is, if i take complete cold backup, it will work or not.  That work in SE environment but there you will met  some problems if you used some feature of EE such as high availability(for example dataguard). high availability feature available only with Enterprise edition.(In SE available but do not automatically some tasks).

Chinar, 1) so if with out dataguard, will database run smoothly which oracle version 10.2.0.4 enterprise edition on windows 2003 standard edition 64bit. 2) if my database is in 10.2.0.4 EE and windows 2003 SE then can i implement data guard? here still oracle is running in EE Thanks.

CKPT wrote: Chinar, 1) so if with out dataguard, will database run smoothly which oracle version 10.2.0.4 enterprise edition on windows 2003 standard edition 64bit.  Also if you did not use partitioning, spatial,etc then there is no problem.  if my database is in 10.2.0.4 EE and windows 2003 SE then can i implement data guard? here still oracle is running in EE  To implementing data guard you need install both server(host) same Oracle software.In SE environment you can implement data guard but there archive log will not automatically apply to standby database.


Related Links

Using CASE insted of DECODE in Control File
How to tune Latches??
Oracle Client Version Question
Oracle Integration with active directory (AD)
Is COST a funtion of time
opinions on backing up my environment
Export of table data
KUP-04036: second enclosing delimiter not found
Getting the sequence that is used in a trigger of a table for generic inser
Forgot password of user system
Error TNS:No Listener
Oracle JDBC driver - Unsupported parameter
How to copy schemas ?
adstats.sql
SQL LOADER ;;; PLEASE HELP ME
TNS-12502: