Blog - comments

MOXX offers mobile internet access when you travel in France. Simply rent a Pocket WiFi device and s...
wifi france
Hello David,I think Oracle is behaving differently with 12.1.0.2.x. At least in my case I was able t...
David D'Acquisto

Bravo, il fallait y penser Mery Christmas

Eric

Great !! Thank you very much.

SEK

Great !! Thank you very much.

SEK
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 12.1.0.3.0 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 12.1.0.3, the 12c databases are seen up but when we try to access them via Cloud Control we have the following error message:

b1

 

Generally, this kind of message occurs because there is a plugin problem. So I decided to install Oracle Database Plugin 12.1.0.3.0. 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:       : 12.1.0.3.0        

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 12.1.0.3 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:

 

b2

 

The 12.1.0.3.0 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:

 

b3

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

b4

 

We can also access to the PDB:

 

b4

 

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

 

b6

 

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

 

b7

 

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

 

b8

 

We choose to schedule the job immediately:

 

b9

 

We submit the job:

 

b10

 

The job is successful:

 

b11

 

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

 

b12

 

We choose the "Create Database" Procedure:

 

b13

 

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

 

b14

 

We select the template in the software library:

 

b15

 

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

 

b16

 

We select the different options for the storage:

 

b17

 

We select the memory and character set parameters:

 

b18

 

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

 

b19

 

Finally we schedule the job immediately:

 

b20

 

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

 

b22

 

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

 

b21

 

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.

 

Conclusion

Despite the problem concerning the OMS crash during the Oracle Database 12.1.0.3 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:
1

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.

Comments

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

Leave your comment

Guest Monday, 22 December 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

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