May 2015 archive

OCM 11g Preparation - Create and monitor alerts

In this chapter you must know how to configure Metric Thresholds. Each target has a screen to configure all of them in one place. It's a menu item called "Metric and Policy Settings". However, you can also define in metrics in other places. E.g: If you need to define the Used% for tablespace USERS, you …

Continue reading

OCM 11g Preparation - Create and manage jobs

Do not confuse this topic with the "Create Scheduler jobs" (DBMS_SCHEDULER). And off course, jobs here is not the old legacy DBMS_JOBS. Jobs here is the EM Grid Control jobs that you can configure, like running an OS script in any monitored hosts. Jobs are great when you want to do the same tasks on …

Continue reading

OCM 11g Preparation - Use Enterprise Manager Configuration Assistant(EMCA) utility

So this topic is very very important. Why? Because EM DB Control can help you in many of the exam tasks if there is no constraint. And remember, time here is better than money, time is passing. If the exam requests you to create an EM DB Control and you fail, you won't score in this item, …

Continue reading

OCM 11g Preparation - Use Grid Infrastructure to manage oracle databases and other resources

In this topic we are not talking about grid or Oracle RAC yet, but this item is here. So, having proficiency in using the GI to manage a database (and we are still talking about standalone server) means to me "Oracle Restart". When installing grid infrastructure for a standalone, we get some utilities to set up and manage the …

Continue reading

OCM 11g Preparation - Use OPatch to install a patch

Every patch is different from another, so there is no rule for applying a patch. You need to read the doc before! Don't simply do an "apply patch" w/o reading it before (I just underline it because I know some people that like to read it after, when things are already messed up)! So for this …

Continue reading