Friday, September 20, 2013

Multi-tenant Database notes

We are in the ACE Director briefing on Friday morning with Penny Avril and people from her team.  Good to see her again!

There are some VERY interesting things coming up - look for the announcements in Larry's keynote on Sunday, and various presentations throughout the week.

---

We did discuss the Multi-tenant database.  One thing was clarified about the licensing, and this is actually written in the Licensing document at http://www.oracle.com/pls/db121/homepage

As of 12cR1, you have 3 modes to install the database:

- Pre-12c mode - 1 (or more) instance for one database;
- Single tenant - available for SE1, SE, EE and PE at no additional charge*
- Multi-tenant - available as an extra-cost option for EE only

* First entry in the table at http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htm states:

"Extra cost option for up to 252 pluggable databases. The multitenant architecture with one pluggable database (single tenant) is available in all editions."

While somewhat ambiguous, we did get confirmation that "available in all editions" means no additional fee for 1 tenant.  

(As always - final word is only from Oracle ... "I read it on the internet" is never a good legal defense.)

--------

Update:  APEX is installed by default into the Seed PDB, and the Root PDB.  That can be changed - it can be removed from the Seed, and it can be removed from the Root.  This gives several potential configurations.
 




(Note to self: check on the impact of removing, specifically re: EM Express.)

If installing a PDB, especially importing from an 11gR2, there could be a challenge. 

2 comments:

Anonymous said...

I have heard that in 13c ( :) ) the Multi-Tenant implementation will be the recommended one for even Single DB's. Was there any mention of this ?

Fuzzy GreyBeard said...

No mention. But 13c is still several years away.