Blog - comments

Yeah.! You did a great article and we need some descriptive on this presentation to understand clear...
SharePoint 2013 Online Training

hi i am also facing the same issue please tell me how u resolved this.

sandeep singh

How you resolved this

sandeep singh
Hi Nag,Thanks for your comment. Do you have a problem when creating the procedure or when executing ...

Yes it is not line with that statement but I didn't write the first quote ;)

Anton Ivanovitch
Blog Pierre Sicot Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the Oracle database plugin was made available, I decided to test the Cloud 12c behavior with the Oracle 12c database and also CDB and PDB (Container Database and Pluggable Database).

Before installing the Oracle Database Plugin, the 12c databases are seen up but when we try to access them via Cloud Control we have the following error message:



Generally, this kind of message occurs because there is a plugin problem. So I decided to install Oracle Database Plugin via the classical method: Setup / Extensibility. We download the plugin and then choose to deploy it to the OMS server. Surprisingly, the Oracle Management Server crashes:


vmtestoraem12c:/u01/app/oracle/MiddleWare_2/oms/ [oms12c] emctl status oms

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.

WebTier is Down

Oracle Management Server is Down

This may be due to the following plug-ins being deployed on the management server or undeployed from it:

Plugin name:   : Oracle Database    

Version:       :        

ID:             : oracle.sysman.db  

Use 'emctl status oms -details' for details.


I tried to stop / start the OMS and I got the following message:


vmtestoraem12c:/u01/app/oracle/MiddleWare_2/oms/ [oms12c] emctl start oms

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.

Starting Oracle Management Server...

Starting WebTier...

WebTier Successfully Started

Oracle Management Server is not functioning because of the following reason:

Plug-in deployment is in progress. Enterprise Manager will be started automatically after plug-in deployment is complete. Try 'emctl status oms -details' to see current status of plug-in deployment


As we can see the plugin deployment to the OMS has a deep impact on the OMS, but the plugin deployment is still in progress, we just have to wait for the successful restart of the Oracle Management Server :=)

After a few minutes, Enterprise Manager Cloud 12c is up and the database plugin is correctly deployed to the OMS. Now we have to deploy the plugin to the agent on the remote host where we need to administer the 12c databases. After a successfully deployment, we can access to the 12c target databases without the ADFC error message:




The Oracle database plugin allows for Oracle 12c database administration. What about Oracle 12c new features such as Container Database and Pluggable Database?

As we try to discover database targets from the Cloud 12c Console, the CDB and PDB are correctly identified:



The Container Database is accessible from the EM Cloud 12c console:



We can also access to the PDB:




As a consequence, the CDB and PDB administration is available from EM Cloud 12c console, you can realize your DBA tasks such as create tablespaces, create or visualize users, or monitor performances as usual.

Let’s see now if the provisioning feature in the Oracle Cloud Control 12c feature is also available for the CDB and PDB. The provisioning feature allows via a procedure library to realize a lot of activities such as cloning, creating, and patching Oracle databases.

For example, we can create a template for the Container Database TEST12c, from the database menu:Provisioning / Create Database Template




Let's choose to create a template which only contains structural data and fill in the host credentials:




We choose to generate the template in the software library and to maintain the file location:




We choose to schedule the job immediately:




We submit the job:




The job is successful:




Once the template is created in the software library, we can use it to create a new database using the "provisioning create database" procedure:




We choose the "Create Database" Procedure:




We fill in the credentials, we select a host and we define ORACLE_HOME:




We select the template in the software library:




We fill in the Global Database Name and password, and select Next:




We select the different options for the storage:




We select the memory and character set parameters:




We enable the listener configuration and also can choose the database features:




Finally we schedule the job immediately:




The last review screen allows us to check the operations we are going to submit:




Unfortunately, the job fails because the +ASM disk procedure does not detect the ADM disk.




The Create Database Procedure in the deployment procedure of Enterprise Manager Cloud 12c is working fine for single or RAC instances, but does not function for Container or Pluggable databases.



Despite the problem concerning the OMS crash during the Oracle Database plugin deployment, Enterprise Manager Cloud 12c correctly identifies the 12c target database as well as the CDB and PDB. This feature will allow the Oracle DBA to correctly administer and monitor these targets. Let's hope the CDB and PDB deployment procedures will work fine in the near future.

Rate this blog entry:

Pierre Sicot is Senior Consultant at dbi services. He has more than fifteen years of experience in Oracle database administration, engineering, and optimization. His specialty is the installation, migration, optimization, and security of Oracle databases in production environments. Prior to joining dbi services, Pierre was consultant at Trivadis in Lausanne. He also worked at ilem Group as a database administrator and also as a Consultant for different customers. Pierre holds a engineering diploma of ESME Sudria in France. His branch-related experience covers Energy, Banking, Public Administration, etc.


  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Sunday, 05 July 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter