Oct 22

OCM 11g Preparation – Create the database

Creating the database is one of the most elementary tasks a DBA must do. For OCM exam, you must create the DB easily in all the ways imaginable. Like Gavin wisely said, “It’s not about what you know – it’s about how fast you can do stuff as time is the essence in this exam. Working …

Continue reading

Oct 22

OCM 11g Preparation – Prepare your Environment

As we have many situations to deal with in the topics, my recommendation is creating 6 VMs using Virtualbox: Oracle Single Instance Oracle Enterprise Manager Oracle RAC Node 1 Oracle RAC Node 2 Oracle DG RAC Node 1 Oracle DG RAC Node 2 I won’t show here how to create an VirtualBox and install Oracle Linux …

Continue reading

Oct 22

OCM 11g Preparation – Download the Exam Environment

The exam environment keep changing over the time and I believe that Oracle will soon update the Linux and Database release to the latest. As Oct/2014, the exam environment in official OCM website is the following: Exam Environment Oracle Linux Release 5.4 (32-bit) Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit) Oracle Enterprise Manager 11g Grid …

Continue reading

Oct 22

OCM 11g Preparation – Recommended Hardware

As we will need to create RAC, Dataguard, Single Instance and Oracle EM machines scenarios, let’s consider a scenario where we will need to simulate 4 VMs running at the same time. To this work in your system, you will need at least: 16 GB RAM Quad core fast CPU (Something similar or better than a Core i5) …

Continue reading

Oct 07

Retrieve oracle sysdba audit from table

Oracle will always generate audit files for some SYSDBA operations in audit_file_dest, no matter what you do. As Doc ID 1528170.1, “Some auditing of SYSDBA is mandatory and cannot be disabled (STARTUP, SHUTDOWN, and CONNECT).” If audit_sys_operations is currently set to TRUE, many files will be created in audit_file_dest by SYSDBA user activity. In this …

Continue reading