Oracle站點上OCM的資料�。。。�！

wxx

Oracle9i Database Administrator Certified Master
Oracle9i DBA Certified Master
To earn the Oracle9i DBA Certified Master credential, you must meet the prerequisites below and pass the Oracle9i DBA Certified Master practicum. Prior to registering review the practicum content that can be accessed from the following links.
Oracle9i Certified Master Practicum Description
Practicum Objectives and Content
Minimum Participant Skills
Practicum Environment
Practicum Preparation
Scoring
Registration Prerequisites
Prior to registering for the Oracle Certified Master practicum, a candidate must complete two requirements
They must have completed their Oracle9i Database Administrator Certified Professional (OCP)
A candidate must have taken two advanced DBA courses from Oracle University. Advanced courses are taught by top Oracle University instructors and offer hands-on experience for topics that may be addressed during the practicum. Few advanced courses are offered in an online format, however if available, the equivalent online class is acceptable for candidacy to the OCM.
Register for the practicum
Have a Question about OCM?
Once you have reviewed all the information within the links contained on this page and you still have a question, view the OCM Frequently Asked Questions.
Do you require further assistance? Submit your contact information and an Oracle University representative will contact you shortly.
Click here for more information on performance tests and the Oracle Certified Master practicum.
1 Oracle9i DBA Certified Master Practicum

The practicum is targeted toward Oracle9i DBA OCPs with 3 - 4 years of professional Oracle experience. To become an Oracle9i DBA Certified Master a candidate must complete two required advanced DBA courses from Oracle University and pass the Oracle9i DBA Certified Master practicum.
The practicum will be conducted at an Oracle University facility in each global region. View the scheduled practicum events and details on how to register.
Participants in the Oracle9i DBA Certified Master practicum are subject to the rules and guidelines as specified in the Oracle Certification Program Candidate Agreement. All participants must display valid identification to the proctor. Divulging practicum content is a violation of the Candidate Guidelines and may potentially result in the revocation of an individual's OCP and OCM credentials.
The practicum is an exam and as such it is administered accordingly to ensure fairness and security.
Participating in the Practicum
The practicum starts promptly at 9:00 AM on the first day. Plan on finishing no sooner than 6:00 PM the first day. The second day of the practicum is scheduled from 8:30 AM to 5:00 PM. Plan your travel schedule accordingly to ensure you do not jeopardize your opportunity to work through each scenario. Participants are not permitted to enter the classroom once a scenario has started and they must wait until the next scenario.

2 Oracle9i DBA Certified Master Practicum Objectives
Review the objectives below to gain insight as to what skills are required before completing the Oracle9i DBA Master Practicum.
Overall Practicum Objectives
Configure an Oracle9i database environment by creating the logical and physical structures required to support optimal performance.
Configure an Oracle9i network environment to support a variety of connection scenarios.
Install, configure, and use Oracle database management, tuning, and diagnostic tools.
Use Oracle9i enhanced data management features to support advanced replication, partitioning, and parallel operations.
Use Oracle9i tools to backup data while providing uninterrupted database availability.
Use Oracle9i tools to perform restore and complete recovery operations from any failure scenario.
Perform troubleshooting, analysis, and problem resolution to enhance database and instance performance.
Practicum Areas of Focus and Objectives
Database Configuration
Determine and set sizing parameters for database segments.
Create and manage temporary, permanent and undo tablespaces.
Stripe data files across multiple physical devices and locations.
Configure the database environment to support optimal data access performance.
Protect the database from loss of data from any failure scenario.
Create and manage database configuration files.
Oracle Network Configuration
Create and manage multiple network configuration files.
Configure the database instance to support shared server connections.
Setup network tracing.
Configure the network environment to efficiently manage user connections.
Manage Oracle network processes.
Configure the network environment to allow connections to multiple databases.
Oracle Enterprise Manager Setup and Configuration
Configure Oracle Enterprise Manager.
Create an OEM Repository
Use OEM to modify a database configuration.
Configure OEM to manage database availability.
Database Availability
Create a recovery catalog using Recovery Manager.
Use Recovery Manager to perform database backups.
Use Recovery Manager to perform a complete database restore and recovery.
Configure the TNSNAMES.ORA file to support remote connections to a catalog database using TCP.
Perform a complete recovery from any database or instance failure scenario.
Data Management
Create and manage tablespaces to support database access activities.
Manage partitioning within a database environment.
Configure auditing within the database.
Provide users with access to data.
Provide access to data using flashback.
Database Management
Implement fine-grained security.
Generate table, index, column, and system statistics.
Manage the SGA.
Manage new users.
Implement Replication.
Performance Management
Collect instance and database statistics using STATSPACK, USTAT/UTLESTAT, and OEM Packs.
Analyze statistics and modify parameters to enhance performance.
Configure Resource Manager and use it to manage queries.
Create and manage objects to accommodate different data access methods.
Analyze and tune query performance.
Standby Databases and Data Guard
Create and utilize a standby database.
Add data to the primary database in preparation for transfer to a standby database.
Setup the standby database to use the log writer process to transfer the log stream to the standby database.
Configure the network environment to allow communication between the standby database and the primary database.
Open the standby database in a "Read-Only" state.
3 Minimum Participant Skills
Proficient with Oracle9i SQL
Working knowledge of LINUX command language that includes:
a. Formatting and executing basic OS commands
b. Creating and navigation through directory structures
c. File management using copy, move, and delete
d. Linux environment text editors
e. Setting environment variables
The ability to locate and launch Oracle executables that include:
a. RMAN utility
b. Oracle Net Manager
c. Oracle Net Configuration Assistant
d. OEM
e. Listener Utility
f. OMS
g. Oracle Password Utility
h. Database Creation Assistant
Proficient with using Oracle Enterprise Manager
Proficient in using Oracle Net Manager and the Oracle Net Configuration Assistant to configure networking
Advanced knowledge and use of Oracle9.2.0.2 Enterprise Server technology and features
Familiarity with navigating through online Oracle documentation
Proficient with using Konqueror 2.2 browser software

4 Oracle9i Database Administrator Certified Master
Oracle9i DBA OCM
Practicum Environment
The practicum is conducted in a dedicated Oracle University classroom environment. An Oracle proctor facilitates the event by administering scenarios and adhering to specific scenario time frames. The proctor does not score the exam and does not have access to scoring information.
Participants are randomly assigned a dedicated server that is their workstation for each day of the event. Servers are isolated from the Internet and Intranet in an effort to maintain security. It is the responsibility of the participant to effectively manage the database and instance environment on their server to ensure performance and be able to recover from failure scenarios. The inability to recover from a failure scenario may impact a participant's completion of subsequent scenarios.
All scenarios have time limitations that require participants to employ best practices in order to successfully complete assigned tasks. Each scenario explicitly describes the required end state that participants must achieve.
Participants are not allowed to use personal documentation or notes during the practicum nor will they be permitted to collaborate with other participants. Cellular phones, pages, and PDA's will not be allowed in the practicum classroom. Participants can use the notepad on their desktop to keep notes during the practicum. Participants must agree to the same guidelines that apply to all Oracle9i DBA Certified Professional exams and can be found in the Oracle Certification Program Candidate Agreement at:
http://www.oracle.com//education/certification/index.html?canagreemt.html
The software environment for each server consists of the United Linux 1.0 operating system using the KDE interface. Oracle9.2.0.2 is installed on each server along with a complete Oracle documentation set.
Participants can choose to work in either Linux and Oracle CLI or GUI environment when available during the practicum.

5 Oracle9i Database Administrator Certified Master
Oracle9i DBA OCM
Preparing for the Practicum
The best way to prepare for the practicum is to practice in a representative Linux and Oracle environment. United Linux 1.0 operating system with KDE and Oracle9.2.0.2 are used during the practicum.
Since fundamental Linux knowledge is necessary, you can practice on either a United Linux 1.0 or RedHat Linux Advanced Server 2.1 operating systems. Both support KDE.
Trial versions of RedHat Linux can be downloaded from http://www.redhat.com
Review the Minimum Prerequisite Skills section for more detail about specific skills.
Oracle9.2.0.2 can be downloaded from the Oracle Technology Network at http://otn.oracle.com.
Successful practicum candidates are those individuals who have actually worked through each of the objectives that are listed for the practicum and have extensively practiced backup, restore, and recovery operations.

6 Oracle9i Database Administrator Certified Master
Oracle9i DBA OCM
Scoring
Participants are scored on their ability to complete assigned tasks and to recover from various database failure scenarios. Data from each participant's environment is collected at the end of each scenario and this data is used to determine the final score. In some scenarios, participants may receive partial credit, however the inability to recover from a failure scenario results in zero credit for an entire scneario. The proctor is not responsible for scoring the practicum and will not have scoring information during the event. Participants will be notified of the final score 2 -3 weeks following the practicum.
Participants must achieve a minimum of score of 70% to pass the practicum.
Upon attaining a successful score, a participant is awarded the Oracle9i DBA OCM credential. If a participant does not achieve a passing score then they are required to retake the entire practicum at a later date.

horse

全英的，看的很費時。