Friday, August 2, 2013

OCM 11g Preparation

After being a dba for over 10 years, I have decided that I would attempt to give OCM exam for 11g.

Target period: Nov/Dec 2013.

I will register for the exam just a month before the exam date after looking at available schedule and having confidence. But I don't intend to postpone it in 2014.

I will create multiple posts for each task/scenario related to each of the topics.

This will be a MASTER post and I will put links for all the posts here. This will help me to keep track of the topics I covered and will also help others if they are looking for some help in preparation

OU links for exam details:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&get_params=p_track_id:Datab11g

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM&p_org_id=1001&lang=US

Additional information and resources in above link shows exam environment information:


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 Control Release 1 (11.1.0.1.0)  (32-bit)



Task: Create Practice Environment

1. My LAB – HW and SW

2. Install Oracle VM VirtualBox and Extension Pack

3. Create Virtual Machine “OCM” & Install Linux Guest OS

4. Clone Virtual Machine OCM to OCMSFSDB

 

Task: Create the Database

1. On ocmsfsdb: Install Oracle Database 11g Enterprise Edition Release 11.2.0.3.0(32-bit)

2. Create database on ocmsfsdb

From Oracle Database Administrator’s guide:

The specific methods for creating a database are:

So I will create three databases on ocmsfsdb:

a. Using dbca (Recommended)

        i. Interactive – db_name: idbcadb

        ii. Silent – db_name: sdbcadb

b. Manually - “create database …” - mandb
 

3. Determine and set sizing parameters for database structures

a. Physical storage structures

     i. Data files

     ii. Control files

     iii. Online redo log files

b. Logical storage structures

     i. Data blocks

     ii. Extents

     iii. Segments

     iv. Tablespaces
    



<More to come>

No comments:

Post a Comment