Jun 13

OCM 12c Preparation – Modify materialized views

So, for the OCM 12c Upgrade Exam, for this topic I recommend to first revise all the materialized view features studied for OCM 11g. However, as the topic here is named “Modify” and not “Create”, you must take special attention in 12c New Features, such as: Synchronous Refresh Out-of-Place Refresh And don’t forget to review all the other Materialized …

Continue reading

Jun 07

OCM 12c Preparation – Protect the database from loss of data due to any kind of failure

So, you need to know how to protect your database and how to resolve any kind of issue. How to protect is the easier part, you must ensure your environment will be prepared for a catastrophic event: Enable Archivelog Enable Flashback Add Supplemental Log Then perform a full backup of your CDB (including the PDBs) …

Continue reading

Jun 07

OCM 12c Preparation – Create and manage database configuration files

> This topic is pretty the same thing as we had in OCM 11g exam. But now as we have a container database scenario, we open more options. < So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and …

Continue reading

Jun 07

OCM 12c Preparation – Configure the network environment to allow connections to multiple databases

> This topic is pretty the same thing as we had in OCM 11g exam. But now as we have a container database scenario, we open more options. < You can run multiple listeners in the same server. Thus, it’s possible to: Have 1 listener pointing to multiple databases services. Have multiple listeners pointing to …

Continue reading

Jun 07

OCM 12c Preparation – Create and manage users, roles, and privileges

Creating users, roles and give them privileges are one of the most basic thing a DBA must know. If you need to create any in the exam, you need to memorialize the syntax because this type of task is so basic that you can’t lose time on it. As in 12c we have now common …

Continue reading