Tuesday, December 16, 2014

Managing Oracle Database 12c with Enterprise Manager – Part III

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we came to the Provision Pluggable Databases page as seen below. This is accessible via the Container Database Home Page in Enterprise Manager 12c, from the Oracle Database menu.
When it comes to licensing for this page, it needs to be clearly understood. The licensing requirements for the Enterprise Manager Database Lifecycle Management Pack (DBLM) are explained in the Enterprise Manager Licensing information guide here.  This mentions that “On the Provision Pluggable Databases page, all operations are licensed except for those explicitly mentioned in the Base Database Management Features section.” Section 2.3.1 of the same licensing guide mentions that the following PDB provisioning features require the DBLM license:

  • Pluggable Database (PDB) Create/Plug/Unplug:   
  • Create PDB from seed, plug PDB from unplugged PDB, and unplug PDB (multiple targets operations or performed using a customized deployment procedure).
  • PDB Clone:        Create a clone of an existing PDB.
  • PDB Migrate:     Migrate Non-Container Databases (CDB) database to a PDB.
  • Pluggable Database (PDB) Create/Plug/Unplug     
  • Create PDB from seed, plug PDB from unplugged PDB and unplug PDB (single target operations only using non-customized deployment procedure).

The Base Database Management Features section specifies that the following PDB operations are included in the base database management functionality of Enterprise Manager (i.e. these operations do not require the EM DBLM license):
So in plain words, PDB cloning and migration definitely require the DBLM license. For PDB Create/Plug/Unplug, if you specify more than 1 PDB, then you need the DBLM license, or if you change (customize) the EM-supplied OOTB (out-of-the-box) deployment procedure, then you need the license.
On the other hand, if you use the standard OOTB procedure, and if you specify only 1 PDB in your operation, then the DBLM license is not needed.  
Note that these are general guidelines to give you an idea of your licensing requirements for PDB provisioning via Enterprise Manager.  For specific needs and details of Oracle software licensing for your situation and company, please be sure to verify with your local Oracle Sales contact.


This blog post was originally posted at this link.

Managing Oracle Database 12c with Enterprise Manager – Part II

In the last post, we saw what the discovery of an Oracle 12.1 Container Database (CDB) would look like in Oracle Enterprise Manager 12c, with the CDB and component PDBs all being discovered by the EM Agent that has been installed on the target database server.
Drilling down to a CDB, the following screenshot illustrates how the CDB Home page would appear. The Home Page shows the list of Pluggable Databases in this Container Database.
Enterprise Manager 12c allows you to easily open/close component Pluggable Databases from the Container Database Menu.
Pluggable Databases can be opened “Read Only” or for “Read Write”. The “Open” in the menu below indicates a normal open, i.e. for Read Write.
It is also possible to provision new Pluggable Databases directly from Enterprise Manager, from the Container Database menu as seen below.
This brings up the Provision Pluggable Databases page. On this page, you can migrate an existing non-CDB database to be a new pluggable database. You can create a new pluggable database either from a seed database, or by cloning an existing pluggable database,  or from an unplugged database.  You can also unplug a pluggable database, or delete it totally along with the datafiles.
In the next blog post, we will talk more about the Enterprise Manager licensing requirements for this page. These aspects need to be clearly understood.
This blog post was originally posted at this link.

Managing Oracle Database 12c with Enterprise Manager – Part I

A friend from a lovely country in South America wrote to me :
“Hi My Friend!! My colleague has installed an Oracle Database 12c Container database (CDB) and he has created 2 Pluggable databases (PDBs) on it. He is keen to manage the CDB and PDBs in Enterprise Manager.
“But, when he adds the database to Enterprise Manager 12c, he sees it like a non-CDB and there is no way to work with PDB’s (in fact, he can’t see the arrow left of the database for drilldown to the PDB’s)
“Do you know if he must follow some steps after adding the database to EM, in order to work with PDB's?”
My reply to my friend:
This may happen if he has not downloaded the latest database plug-in for Oracle Database. He needs to download the latest Database plug-in using Self-Update. The latest Oracle Database Plug-in version, as of August 2014, is
A bit of EM history: Plug-in “Enterprise Manager for Oracle Database (DB)” was released by Enterprise Manager Self-Update in early 2013. This Plug-in supported the Database as soon as it was released. So support for the new database 12c has been there even before the database was released!!
 This means that Enterprise Manager Cloud Control 12c was immediately able to discover, monitor and manage the newly released Oracle Database 12c, including the new feature of Pluggable databases (PDBs) and Container databases (CDBs).  
The screenshot below shows how Database 12c targets can be discovered. Enterprise Manager discovers Container databases (CDBs) as well as Pluggable databases (PDBs).
Once discovered, the Database 12c Targets appear in the Database Target List.
This blog post was originally posted at this link.


Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive