Downgrade From Enterprise Edition To Standard

Feb 10, 2011

I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.

How can we check and be sure that a downgrade to SE would not be any problem?

Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE

How can we complete this list, or is there some script to make this easy?

View 7 Replies


ADVERTISEMENT

Server Administration :: Convert Enterprise Edition DB To Standard Edition?

Nov 4, 2011

The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.

The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.

View 2 Replies View Related

Enterprise To Standard Edition

Sep 12, 2012

Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .

View 1 Replies View Related

RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle

Mar 18, 2013

In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?

They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?

View 6 Replies View Related

Install / Use Enterprise Manager Grid Control If Only Have Standard Edition Licenses?

Jul 27, 2011

can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.

View 2 Replies View Related

Downgrade From EE To SE Edition

Nov 30, 2012

I have started to migrate 11.2.0.3 database from Enterprise to Standard edition with expdp/impdp (RHEL box). I've managed to transfer database without any problem (ok i had little difficulties with bitmap indexes but never mind).

But now i do not have all public synonyms in place as i already knew. So i have to create sql script and i have found several good ones. My question is do i need to recreate all public synonyms or there is a exceptions in my case because i now have Standard Edition database (old one was Enterprise)?

View 1 Replies View Related

Using Oracle XDB In 10.2.0.3.0 Standard Edition

Feb 20, 2013

I am using Oracle 10.2.0.3.0 standard edition. Now i want to use Oracle XDB in the same.

Can i use this directly or does this require license.

View 2 Replies View Related

Enterprise Manager :: Oracle 9i Enterprise Edition Installation Error / End Header Not Found

Feb 18, 2011

My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:

Not a zip file(End header not found)

View 1 Replies View Related

Installation :: Uninstallation Of Standard Edition On Windows 7

Jun 26, 2012

When i am trying to uninstall Oracle 11g Standard Edition on Win 7 after sometimes it stopped.Checking for required files and bootstrapping..

14 File(s) copied
792 File(s) copied
1 file(s) copied.
1 file(s) copied.
Location of logs C:UsersinsajenAppDataLocalTempOraDeinstall2012-06-26_15-2
2-43logs
[code]....

After this message it stopped.

View 1 Replies View Related

Server Administration :: Getting NVARCHAR2 In Oracle Standard Edition?

Sep 13, 2011

I want to know, Is NVARCHAR2 available in Oracle standard edition?

View 5 Replies View Related

Scheduler :: Email Notification For Chain Job In Standard Edition One?

Jan 2, 2013

Oracle version :11.2.0.2 standard edition one

I'm trying to enable Email Notification for Chain Jobs, Jobs are running successfully, but i'm not getting email Notification.

i have done necessary SMPT setting in the Enterprise manager and i'm receiving test email from EM.

Below are steps followed:

1) i have created two Program
2)Add this program to a Chain
3)Created a Scheduler Job using this chain
4)Enable Email notification

Code for Email Nitrification:

BEGIN
DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (
job_name => 'ChainJob',
recipients => 's.sankar@test.com',
sender => 'sankars@test.com',
subject => 'Scheduler Job Notification-%job_owner%.%job_name%-%event_type%',

[code]....

View 3 Replies View Related

Streams :: Oracle 11gR2 RAC And Streaming For Standard Edition

Oct 8, 2013

I have requirement where replication should be done between two 11gR2 RAC on Standard edition.I have following queries,1. Does Standard edition support DDL capture?

Im asking this because on

[URL]......

it says "SE1/SE: no capture from redo" what that really mean ??2. Can it be possible to configure capture at schema level and skip only some of the tables / triggers ?

View 2 Replies View Related

Backup & Recovery :: Advantage Of Using RMAN In Oracle 11g Standard Edition

Apr 15, 2013

We are upgrading from oracle 9.2.0.8 to 11g r2, and both are Standard Edition database. The database is part of a product that runs on a customer site, and won't get bigger than 50 GB. It runs in archive mode, and our backup script does a hot backup every night, plus copying the archive logs, redos, controlfiles, etc. We save 2 entire backups - from the last night plus the night before last. Then there's a tape backup that saves the backed-up files to an off-server location.

This architecture has allowed us to recover our customer's data from many odd occurrences at customer sites (power loss during a hot backup, corrupt controlfiles/datafiles/archivelogs). My question is, given that we are running the Standard Edition database, which doesn't have most of the useful RMAN features, is it worth it to switch to RMAN?

I took an Oracle Backup and Recovery class and posed this question to the instructor, and the response was, it would be better to use RMAN over a manual user backup script. Our backup script is pretty battle-hardened - is that the best reason?

View 6 Replies View Related

Performance Tuning :: Oracle10g Standard Edition On Linux Machine

Jan 16, 2012

In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.

SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K

Our Database size is 700GB approx.

The above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is almost 99%.

View 5 Replies View Related

Possible To Have Oracle RAC Standard Edition With 3 Nodes Of Intel Quad Core

Feb 5, 2013

I read that Oracle RAC which is bundled in Standard Edition can support at max 4 sockets. One of my client has a proposal of using RAC but for 3 nodes each using single 1 quad core Intel processor. As far as i understood, an Intel quad core is a multi chip module and actually is a combination of 2 modules dual core, so each Intel quad core may be counted as 2 sockets. Which yield to the proposal of my client will be failed, as the total number of sockets in it will be: 2*3=6 that exceed the max 4 support.

View 4 Replies View Related

Moving From 32 Bit Linux To 64 Bit Windows Version On Database Standard Edition

Aug 16, 2013

when migrating from  32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of? 

View 2 Replies View Related

Data Guard :: Standby Database With Oracle Standard Edition?

Nov 6, 2012

my customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.

View 4 Replies View Related

Move From Standard To Enterprise 11g

Mar 9, 2012

i want to move from 11g Standard to 11g Enterprise (same Version) on Windows.

View 2 Replies View Related

RMAN Restore In Standard From Enterprise

Jul 30, 2012

i can do a rman restore from 9i Enterprise to 9i Standard?

View 2 Replies View Related

Server Administration :: Oracle Rac Standard / Enterprise

Jul 15, 2011

10g Oracle Standard Edition RAC feature and how it is charged. I mean: is it free option for Standard Edition or payable?

I read something about Baby Rac on wiki and there was information that only with Engerprise Edition RAC is an extra-charge option for Standard Edition RAC is included.

[URL]......

Quote:Oracle Corporation includes RAC with the Standard Edition of Oracle Database (aka Baby RAC), but makes it an extra-charge option for the Enterprise Edition

We do have corporate licencing model in our firm, so we can evaluate what version of Oracle we need to install (One, Standard or Enterprise) bu there is no matter what version we chosed, because our licensing model give us possibility to install the highest version. So usually we were choosing the Enterprise Editions.

But only limitation for us is an options. We can't have additional option like partitioning, RAC, Oracle Tuning Pack, etc... in order to have additional option we need approval from our financial management.

I have idea to change one of our installation from Enterprise Edition to Standard Edition in order to have RAC option for free. Like i said. If we want to have RAC in our Enterprise Edition we need additional approval of money expense - but this is not easy. But our licensing model give us possibility to install Standard Edition of Oracle instead or Enterprise Edition and have RAC option include without additional expenses.

View 2 Replies View Related

Performance Tuning :: Performance Standard Edition Without Partitioning?

Jun 16, 2011

How many records could I have in a single table without performance degradation with Standard Edition without partitioning with cutting-edge server (8 or 12 cores, 72 GB RAM, FC 4 Gbit, etc...) and good storage?

300 Millions in only one table with 500K transactions / day is too much?

Simple database with simple schema.

How many records begin to be too many?

View 2 Replies View Related

Cursor Pin S Wait For X In 11g Enterprise Edition Release 11.2.0.2.0

Sep 4, 2013

Ours is Oracle 11.2.0.2.0 Db 4 instances RAC on Unix AIX OS.Since long we are facing problem that CPU utilization reached 100% and reboot is required alteast once or twice a month.On seeing the Events Logs we find that the Event "CURSOR PIN S WAIT FOR X" is consuming a lot of waits.

On analyzing i came to know that we are firing same query from Application 15 to 20 lack times for which a lot of Mutex keeps spining for getting Shared Mode and consumes a large amount of CPU.

View 3 Replies View Related

Import - Moving Data From 10g Enterprise Edition To 11g?

Sep 23, 2013

Am moving data from 10g enterprise edition to 11g standard edition using normal import commandafter completing i just go through the Log.i found a thing which makes me confusing

in some tables alone a row is not inserted stating the ORA-12899 while checking with the database it shows the column is varchar(100)in the log the error showing it tries to insert 101 character. how it happening to a single row

how can i solve it

View 3 Replies View Related

ALL Scripts Which Automatically Get Run By DBCA In ORACLE 11G Enterprise Edition

Jan 19, 2013

which are ALL the scripts which automatically get run by DBCA in ORACLE 11G Enterprise Edition.

View 2 Replies View Related

Performance Tuning :: Oracle Database 10g Enterprise Edition 10.2.0.4.0 - 64bi

Sep 2, 2011

I am querying v$sga and getting variable size : 211337216 bytes.when querying v$sgastat then getting

java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392

But as per my knowledge following condition should satisfy,but not getting

[code]

Variable sga = java pool + large pool + shared pool
select pool,name,sum(bytes)
from v$sgastat
where pool in ('shared pool','java pool','large pool')
group by pool,name;

Here variable size using v$sga : 211337216 bytes

and java pool + large pool + shared pool : 211302536 bytes.

[/code]
but it should match?

View 5 Replies View Related

Upgrade :: Upgrade Patch For Enterprise Versus Standard 11.2.0.1

Sep 22, 2012

is the upgrade patch the same for standard edition and enterprise edition or there are two separate patches?

View 5 Replies View Related

Downgrade From SE To SE1

Jul 2, 2012

I am running a 10gR2 rac database on 11gR2 grid.

I like to switch from a rac to a standalone database including downgrading the license to standard edition one. Actually SE1 is not an install option for 10g.

Would it be enough to reconfigure the 2nd rac node ?

View 8 Replies View Related

Any Way To Downgrade 11.2.0.2 Database

Apr 14, 2011

I am running oracle 11.2.0.2 on AIX 5.3 and when I issue the rman command below to a target DB running 10.2.0.4 I get this error.

$ rman catalog=rman/rman@prod target=sys/sys@prod
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Apr 14 17:38:24 2011
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 10.2.0.4 required
RMAN-00571: ========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN

What I was trying to do is duplicate my 10.2.0.4 DB and overwrite my 11.2.0.2 DB. Is there a way to downgrade my 11.2.0.2 DB. my 11Gr2 DB I have already set the compatibility parameter to *compatible='11.2.0.2' My 11gr2 is a test DB I don't have a valid backup..

View 2 Replies View Related

Server Utilities :: Downgrade From Oracle11g To 9i Via Exp / Imp?

Dec 28, 2010

I want to downgrade my database from Oracle 11g (11.2.0.1.0) to Oracle 9i (9.2.0.1.0).

I've done trial of taking export of higher version(Oracle11g) through lower version(Oracle9i) exp utility and trying to import same exp.dmp files into lower version(Oracle9i), but not succeeded and getting some parameter related error.

On Oracle9i database client- Here i'm connecting to Oracle11g via use of 'wbdata.wbh-db1' service

[oracle1@WBDevelop smbshare]$ exp lab/lab@wbdata.wbh-db1
Export: Release 9.2.0.1.0 - Production on Tue Dec 28 15:45:32 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

[code].....

On Oracle9i database client - Here i'm importing the lab.dmp

(Export taken from Oracle11g via use of 'wbdata.wbh-db1' service)
[oracle1@WBDevelop smbshare]$ imp lab/lab
Import: Release 9.2.0.1.0 - Production on Tue Dec 28 15:49:51 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

[code].....

View 13 Replies View Related

Downgrade Oracle Database 10g Release 10.2.0.2.0 To 10.2.0.1.0?

Nov 29, 2011

am trying to downgrade my oracle database 10g release 10.2.0.2.0 to 10.2.0.1.0the reason for this is that i had to copy /oracle_home/bin utilities from 10.2.0.1 to 10.2.0.2 because of this most utilities like rman,dbca were not working.

i think i need to downgrade my oracle database 10g release to 10.2.0.1.0 right?i read some oracle documentations of database downgrade instruciting me to

>take full backup of oracle DB
>ORACLE_HOME/bin/emctl stop dbconsole
SQL> STARTUP DOWNGRADE
DROP USER sysman CASCADE;
>SQL> SPOOL downgrade.log

[code]....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved