Managing Pluggable Databases in Oracle Database 12c with Oracle Enterprise Manager 12c

Version 5

    Managing PDBs In Oracle Database 12c Using Oracle Enterprise Manager
    Cloud Control 12c

       

    By Edward Whalen – Chief Technologist, Performance Tuning Corporation

     

    About Oracle Enterprise Manager Cloud Control 12c (OEM 12c)

     

    Oracle Enterprise Manager Cloud Control 12c (OEM 12c) is the latest in the Oracle Enterprise Manager Products designed to monitor and manage Oracle and non-Oracle systems, databases and applications/middleware.  OEM 12c has been further enhanced in order to be much more extensible than previous versions of OEM by allowing components and plugins to be upgraded and enhanced without requiring a new release.  It is this extensibility that has enhanced OEM’s ability to manage and monitor Oracle 12c databases.

     

    OEM 12c is a management framework made up of the Management Console, the Management Service (including the repository) and the Management Agents.  The Management Console is browser based and allows an easy way to manage and monitor large installations.  The Oracle Management Service (OMS) is the middleware and database that maintains the monitoring and management information.  The OMS utilizes the Oracle Weblogic Server and an Oracle database.  The management agent is an extensible agent that resides on the target host and monitors targets and uploads this information to the repository (database).

     

    Both the OMS and agents are extensible and include plug-ins that are independent of the core OMS.  This allows for the plug-ins to be upgraded as new ones are available.  This is especially important as new releases of the Oracle database server, applications, etc. are released, allowing OEM 12c to keep up with those changes.

    Note:  When new releases of the Oracle Database plug-ins are released, capabilities and the UI are improved.  This provides a much better monitoring experience.  At the time of this paper, the Oracle Database Plug-In 12.1.0.5.0 was used.

     

    OEM 12c allows for monitoring and managing of various Operating Systems (OS) and applications.  Currently OEM 12c has agents available for a dozen OS versions.  The Enterprise Summary screen in Figure 1 shows an example of monitoring 10g, 11g and 12c databases including both container databases and pluggable databases.

     

    OEM_figure1.jpg

    Figure 1:  Enterprise Summary

     

    In recent Oracle Database Plug-Ins, support has been added not only to allow for easy access to RAC nodes, but to pluggable databases as well.  This was not available in the earliest releases of OEM 12c, which were released before the Oracle Database 12c.  This new feature is shown in Figure 2.

     

    OEM_figure2.jpg

    Figure 2:  Databases Screen Showing Pluggable Databases

     

    The flexibility of OEM 12c to enhance and maintain itself makes it an outstanding tool to manage and monitor Oracle databases.

     

    About Oracle Database 12c Pluggable Databases

     

    Oracle Database 12c is the latest and greatest database product from Oracle.  There are many new and exciting features, including the pluggable database.  This paper will focus on the topic of the pluggable database.

     

    The Pluggable Database, or PDB, is a feature designed to allow for a new way to support Oracle in a multitenant environment.  A pluggable database is a database that resides inside an Oracle container database.  This allows for many enhancements including:

    • Fast provisioning of a new database.
    • Fast copy of an existing database.
    • Migration of a pluggable database to a new platform.
    • The ability to support more tenants in a single container database.

     

    In order to manage the PDBs, OEM 12c has been enhanced to provide support for the pluggable database as described in the next section.

     

    Managing 12c Databases with OEM 12c

     

    OEM 12c with the latest Oracle Database Plug-In provides enhanced support for managing an Oracle 12c database, including PDBs.  From the databases screen, expand the container database and both the database container instances. The container database is then visible for direct connection as shown in Figure 3.

     

    OEM_figure3.jpg

    Figure 3:  The Databases Screen Showing Container Databases

     

    From this screen you can click on the Container Cluster Database or the Cluster Database Instances and the Database Home screen will be opened.  This provides the starting point for the database as shown in Figure 4.  

    OEM_figure4.jpg

    Figure 4:  The Cluster Container Home Screen

     

    From here the instance(s) and database can be monitored and managed as well a link to the pluggable databases.  This interface also provides access to opening and closing the pluggable databases on the various nodes in the RAC cluster.

     

    Creating a Pluggable Database Using OEM 12c

     

    With OEM 12c it is easy to create, clone or migrate a pluggable database.  From the Cluster page of the container database select Provisioning|Provision Container Database from the Cluster Database drop-down menu.  This invokes the Provision Pluggable Databases page as shown in Figure 5.

    OEM_figure5.jpg

    Figure 5: Provision Pluggable Databases

     

    The menu allows for migrating, creating, unplugging and deleting pluggable databases.  The wizards are easy to use and take advantage of the OEM 12c jobs subsystem.

     

    Managing Pluggable Databases Using OEM 12c

     

    Once the pluggable databases have been created it is easy to manage them via OEM 12c.  From the Cluster page of the container database select Control|Open/Close Container Database from the Cluster Database drop-down menu.  This invokes the Provision Pluggable Databases page as shown in Figure 6.

    OEM_figure6.jpg

    Figure 6:  Open/Close Pluggable Database Screen

     

    From the Pluggable Databases section, highlight a pluggable database.  Then select the Instances from the Instances section and select the Action dropdown menu.  Here you can Open, Open Read Only or close a pluggable database, depending on its current state.

     

    Note: In order to Open or Close a pluggable database you must be logged into the container in OEM as a user with SYSDBA privileges.  If you are not, you will get an error when trying to change the state of the pluggable database.  An error is reported, but no explanation given.

     

    Conclusion

     

    OEM 12c provides a powerful and easy way to monitor and administer Oracle 12c databases.  When using the latest database plug-in, it is now possible to fully take advantage of pluggable databases within OEM 12c.  This is made possible by the extensibility features of Oracle Enterprise Manager Cloud Control 12c.

     


    About the Author

     

    Edward Whalen is an Oracle ACE and the Chief Technologist at Performance Tuning Corporation (www.perftuning.com), a consulting company specializing in the Oracle technology stack from hardware through applications. Ed has more than 20 years of in-depth experience with hardware, operating systems, and virtualization but his primary focus is on high performance, high availability, and replication with RAC, Data Guard, and GoldenGate.