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:
With Database Configuration Assistant (DBCA), a graphical tool.
With the
CREATEDATABASESQL statement.See "Creating a Database with the CREATE DATABASE Statement"
So I will create three databases on ocmsfsdb:
a. Using dbca (Recommended)
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