Thursday, May 21, 2015

Managing Oracle Database 12c with Enterprise Manager – Part XIII - Database Express 12c

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we briefly looked at the changes for Metering and Chargeback. We will now look at the new Database Express 12c.
Oracle Database 12c introduces “Enterprise Manager Database Express 12c” instead of Enterprise Manager Database Control that was available with previous versions of the database, such as 11g and 10g. The important thing to remember is that both Database control, and Database Express, can only be used to manage a single database as opposed to Enterprise Manager 12c Cloud Control.
As we can see, Enterprise Manager Database Express 12c provides basic administrator support for storage management(tablespaces, archive logs, control files, redo logs, undo tablespaces), security management (users, roles profiles),configuration management (initialization parameters, memory, database properties, feature usage), and performance diagnostics and tuning (Performance Hub and SQL Tuning Advisor).
For licensing purposes, the performance components require the Diagnostics and Tuning pack for Database 12c Enterprise Edition (EE). However the basic administration pieces can be used for free and also are accessible in Database 12c Standard Edition (SE).
Database Express 12c supports single instance or RAC databases, and Standard Edition (SE) or Enterprise Edition (EE). Since the administration activities supported are basic, the DBA will need to use a centralized Enterprise Manager Cloud Control installation for more advanced DBA activities on the database – such as setting up RMAN backups, Data Guard standbys, Database Resource Manager, Data Redaction and so on. These tasks obviously cannot be performed in Database Express 12c.
Database Express 12c can be installed along with the database (such as when the database is created using the Database Configuration Assistant (dbca)), in the same manner as Database Control 11g/10g. However, the difference between Database Control and Database Express, is that the latter runs inside the database and there are no extra Middleware components installed on the database server. The XDB server inside the database is used for web services. This itself is a welcome change.
Due to the improved and streamlined architecture, the disk space used is approximately only 20MB or so, and the CPU and memory overhead is also greatly reduced. 100% of the UI rendering for the screens is performed in the browser, and the database server only runs SQL - in contrast to the previous version of Database Control.
In the next blog post, we will take a closer look at the Database Performance Hub component of Database Express 12c.
This blog spot was originally published at this link.

No comments:


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