Oct 30

OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces

Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace to use as a template. …

Continue reading

Oct 28

OCM 11g Preparation - Determine and set sizing parameters for database structures

In this topic, you must be able to: Alter all the DB parameters that define any kind of memory or disk sizing. I would recommend you to run "show parameters size" and play with all of them. Create datafiles with different block sizes and check the usage of the db_NK_cache_size areas. Path to Documentation: Administrator's …

Continue reading

Oct 24

OCM 11g Preparation - Deploy Enterprise Manager Grid Control agents

For OCM Preparation, in this topic you must be able to easily deploy an EM Grid Control agent. Although the term "deploy" let us think that we need to do it using the DB Console, I recommend also practicing the manual agent deployment. So, do the following scenarios: Install and deploy EM Agent in a new server …

Continue reading

Oct 23

OCM 11g Preparation - Install and Patch Enterprise Manager Grid Control software

Oracle 11g EM installation is divided in WebLogic and OMS. I gave the link to both files here. There is no mysterious in installing the WebLogic. As it is a binary file, all you can do is call the user interface and go through the steps. Do not try Oracle WebLogic Server 10.3.6 with the Enterprise …

Continue reading

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