SE2

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Posted on January 29, 2020 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant 0

When we announced the 3-PDB-Support with Oracle Database 19c onward at OpenWorld 2019, I was very excited. According to the license documentation, this applies to Standard Edition 2 (SE2) as well. But does it work? Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Photo by Şahin Yeşilyaprak on Unsplash

The license documentation is pretty clear about 3 user-created PDBs:

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Check with Oracle Database 19.5.0 SE2

It’s been a while since I installed SE2 instead of EE. But everything goes smoothly. You just need to select “Standard Edition 2” in the OUI. The image you …

Great License News: Spatial and Graph, Machine Learning

Posted on December 6, 2019 by Mike.Dietrich General 6

Just this week in Brighton at TechFest19 by UKOUG I’ve heard one of the common complaints about our license strategy. Something I can’t comment in my position. But even better that we are announcing some very good news now. Oracle is listening. It is a reaction to customer’s wishes.

Photo by pxoxo on Unsplash

Spatial and Graph

Effective December 5, 2019, Oracle Spatial and Graph (OSG) option will be included with Oracle Database. This will affect Enterprise Edition, SE2 and Database Cloud Service (DBCS) Standard Edition 2 and Enterprise Edition. This means, you can use Spatial and Graph in all …

Transportable Tablespaces – Does it work between SE2 and EE?

Posted on November 14, 2017 by Mike.Dietrich Transportable 2

Transportable Tablespaces - Does it work between SE2 and EE? I thought I had blogged about this topic already. But it seems to be that I stored this information somewhere else. Randomly I receive this question: Oracle Transportable Tablespaces – Does it work between SE2 and EE?

In addition often the question gets precised: Does it work in both directions or just one-way?

Transportable Tablespaces and Full Transportable Export/Import

Please find more information about these two very common Oracle database migration features:

Transportable Tablespases: Character Sets – Same same but different? (May 25, 2016)
Transportable Tablespaces and Read-Only in Oracle 12c (Dec 2, 2016)
Full Transportable Export/Import – Things

Can you simply switch from SE2 to EE with Oracle Multitenant

Posted on July 18, 2017 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant Uncategorized 8

This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”

Yes, you can!

First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:

Both database versions must be the same
Both databases must have the same character set (in Oracle Database 12.1)

That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.

In addition you may have to run several component …

Can you apply Bundle Patches to SE2 databases?

Posted on June 15, 2017 by Mike.Dietrich Patch Recommendation SE2 - Standard Edition 2 0

Can you apply Bundle Patches (BP) to Standard Edition (SE2) databases?

This question got raised by Adam (thanks!) via the comments section of the blog. But a few days later I read it on the internal mailing lists as well. Adam was referring to this sentence in the BP READMEs since October 2015:

“In this document Oracle Database Home refers to Enterprise Edition. Standard Edition Database software installs should install Database PSU.”

Why was this sentence added?

There were issues with enabling functionality on SE2 databases by accident with a Proactive Bundle Patch – something which got fixed and …

Adaptive Execution Plans – not available in Oracle SE2

Posted on June 12, 2017 by Mike.Dietrich Optimizer 0

I received an interesting question on the blog the other day:

“Are Adaptive Plans an Enterprise Edition only feature?”

What does the License Guide say?

The Oracle Database 12.2 License Guide says:

Adaptive Features: Enterprise Edition only – from the Oracle 12.2 License Guide

What does www.oracle.com say?

This is the link the customer came across – also saying that Adaptive Execution Plans are an Enterprise Edition only feature:

Adaptive Execution Plans – Enterprise Edition only – from www.oracle.com

What does this mean for SE2?

That is the question Adam had. Does this impact SE2? Will I get an error …

SE2 – Some questions, some answers …

Posted on September 17, 2015 by Mike.Dietrich SE2 - Standard Edition 2 54

Oracle Standard Edition SE2 12.1.0.2 *** Updated on Nov 6 to reflect 11.2.0.4 changes***

There were a lot of questions regarding Oracle Database Standard Edition 12.1.0.2 SE2 in the past days. See below for further blog posts on SE2.

And please find the official Oracle SE2 “brief” document here giving you a good overview on SE2:
[http://www.oracle.com/us/products/database/oracle-db-se2-brief-2680836.pdf]
Document has been removed – link is not valid anymore – sorry!

I’ll try to summarize some topics I’m able to answer by myself. And please don’t expect me to assist with license or license migration questions – that is far beyond my scope or knowledge or responsibility, …

MOS Download for Oracle Database 12.1.0.2 including SE2

Posted on September 8, 2015 by Mike.Dietrich SE2 - Standard Edition 2 13

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:

You have 3 options to download Oracle Database Enterprise Edition 12.1.0.2 and Oracle Database Standard Edition 12.1.0.2. SE2.

Regarding OTN and eDelivery nothing …

Oracle Database 12.1.0.2 SE2 – Support and Patches for Oracle Database 12.1.0.1 SE/SE1

Posted on September 7, 2015 by Mike.Dietrich SE2 - Standard Edition 2 6

Oracle SE2

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:

Some questions regarding support for Oracle Database Standard Edition 12.1.0.1 (SE/SE1) came up in the past days.

Most of those are answered already in MOS Note 2027072.1 (Oracle Database 12c Standard Edition 2
(12.1.0.2) )

How long will

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Posted on September 3, 2015 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant 3

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:

Can you have Oracle Multitenant in Oracle Standard Edition 12.1.0.2 SE2?

No, you can’t as Oracle Multitenant is a licensable option for Enterprise Edition (EE) databases only.

But wait a second …

You can do Oracle Single …

Oracle Database 12.1.0.2 Standard Edition (SE2) available for download

Posted on September 1, 2015 by Mike.Dietrich SE2 - Standard Edition 2 86

Oracle SE2 Finally …

Oracle Database 12.1.0.2 Standard Edition (SE2) is available for download.

Some information is already available in the Oracle Database Licensing Information. And you’ll find more here: https://www.oracle.com/database/standard-edition-two/index.html

Quoting from the pricing document:
http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf

“Oracle Database Standard Edition 2 may only be licensed on servers that have a maximum capacity of 2 sockets. When used with Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be licensed on a maximum of 2 one-socket servers. In addition, notwithstanding any provision in Your Oracle license agreement to the contrary, each Oracle Database Standard Edition 2 database may …

SE2

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Check with Oracle Database 19.5.0 SE2

Great License News: Spatial and Graph, Machine Learning

Spatial and Graph

Transportable Tablespaces – Does it work between SE2 and EE?

Transportable Tablespaces and Full Transportable Export/Import

Can you simply switch from SE2 to EE with Oracle Multitenant

Yes, you can!

Can you apply Bundle Patches to SE2 databases?

Can you apply Bundle Patches (BP) to Standard Edition (SE2) databases?

Why was this sentence added?

Adaptive Execution Plans – not available in Oracle SE2

What does the License Guide say?

What does www.oracle.com say?

What does this mean for SE2?

SE2 – Some questions, some answers …

MOS Download for Oracle Database 12.1.0.2 including SE2

Oracle Database 12.1.0.2 SE2 – Support and Patches for Oracle Database 12.1.0.1 SE/SE1

How long will

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Can you have Oracle Multitenant in Oracle Standard Edition 12.1.0.2 SE2?

But wait a second …

Oracle Database 12.1.0.2 Standard Edition (SE2) available for download

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter