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 to…

Can you simply switch from SE2 to EE with Oracle Multitenant

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?

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 corrected…

Adaptive Execution Plans – not available in Oracle SE2

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: 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: What does this mean for SE2? That is the question Adam had. Does this impact SE2? Will I get an error or – even worse – a license violation if I have optimizer_adaptive_plans=TRUE – which is the default? No, none of it will…

SE2 – Some questions, some answers …

*** 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 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, and you may please contact your Oracle sales person regarding these topics…

MOS Download for Oracle Database 12.1.0.2 including SE2

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015: SE2 – Some questions, some answers Sept 8, 2015: MOS Download for Oracle SE2 Sept 7, 2015: Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015: Can you have Multitenant with Oracle SE2? Sept 1, 2015: Oracle Standard Edition SE2 available for download   You have 3 options to download Oracle Database Enterprise Edition 12.1.0.2 and Oracle Database Standard Edition 12.1.0.2. SE2. OTN – Oracle Technology Network eDelivery – Oracle Software Delivery Cloud MOS – MyOracle Support https://updates.oracle.com/download/21419221.html Regarding OTN and eDelivery nothing has been…

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

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2: Sept 17, 2015: SE2 – Some questions, some answers Sept 8, 2015: MOS Download for Oracle SE2 Sept 7, 2015: Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015: Can you have Multitenant with Oracle SE2? Sept 1, 2015: Oracle Standard Edition SE2 available for download   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 Oracle Database 12.1.0.1…

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:   Sept 17, 2015: SE2 – Some questions, some answers Sept 8, 2015: MOS Download for Oracle SE2 Sept 7, 2015: Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015: Can you have Multitenant with Oracle SE2? Sept 1, 2015: Oracle Standard Edition SE2 available for download     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 Tenant with…

Oracle Database 12.1.0.2 Standard Edition (SE2) available for download

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 use a maximum of…