We are discussing the management of Oracle Database 12c via Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at how easy it was to set up Oracle Data Redaction for a 12c database using Enterprise Manager - this capability being used to hide confidential data on the fly as it is being displayed.
We will now look at the Database Resource Manager
and its new capabilities to handle PDBs (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we started to look at Data Redaction, and created a Policy on the HR user and Salary column. We specified Full Redaction as seen below, to hide all the Salary column figures (a zero will be displayed).
Click on “Show SQL
”, this displays the PL/SQL code that is generated to (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at how user administration is performed for a 12c Database using Enterprise Manager, such as the creation of a common user for the CDB$ROOT.
Let us talk now about the capability of Oracle Data Redaction
. This is a new Oracle Database 12c feature, which camouflages data on the fly when being (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at setting up Data Guard standbys in Enterprise Manager 12c.
Let us look into the Administration of Database Users in Enterprise Manager, and specifically the changes for Database 12c.
Selecting Administration..Security..Users from the 12c Database Target menu of Enterprise Manager, this is now Database 12c aware, and allows you to (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we looked at provisioning 12c Pluggable Databases (PDBs) in a Container Database (CDB) using Enterprise Manager.
As many DBAs are coming to realize, Oracle RMAN backups can be easily set up and scheduled for multiple Oracle databases in Enterprise Manager, it’s all about saving time and effort. Well, now the RMAN wizards in (more...)
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 (more...)
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 (more...)
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 (more...)
Enterprise Manager 188.8.131.52 was released in June 2014, and the 184.108.40.206 OMS Bundle patches have also been released in July 2014. If you have recently upgraded your Enterprise Manager OMS to 220.127.116.11, it is recommended to apply the latest available bundle patch to your 18.104.22.168 OMS.
For the list of the available Bundle patches or System patches, please refer to the My (more...)
What are the enhancements to the Enterprise Monitoring Framework in EM12c Release 4? This is the framework that controls the monitoring of enterprise targets.
Improvement - The “Target Down” status is detected by Enterprise Manager within seconds of its occurrence. This applies to the Database, Weblogic Server, Host, Agent as well as deployed applications. This kind of ability is very important for enterprise-level monitoring.
The Host level monitoring has also been improved. (more...)
There are a number of great improvements to the Database-as-a-Service (DBaaS) capability in Enterprise Manager 12c Release 4.
As a recap, in earlier releases it was possible to set up a private database cloud very easily, so that developers, testers or project managers/business users could self-service the creation of new databases, schemas or pluggable databases (PDBs) as per a pre-defined quota, and then have those databases, schemas or PDBs metered and used for dollar chargeback, (more...)
This is a list of the many great new features in EM12c Release 4, from the official Oracle technical documentation. Check out the BI Publisher Integration
, and the new Cloud Management features, such as being able to create Data Guard Standby databases via self-service
· Framework and Infrastructure