Oracle 11g OCM Exam Summary

After 3.5 months of fighting, finally on May 5, 6th completed the final exam preparation journey, finally can be released (May 31 only received Oracle's exam by notice)!

The whole process, filled with personal sweat and hard work, but also the family's silent pay. Every night to learn to 12 points, to ensure that the scheduled completion of the daily learning tasks. Son's study, the size of the family, all wrapped in the wife's body. So I sincerely thank them, thank them for my care, but also thank them for my patience!

Although the learning process is full of hard work, the whole learning route is very clear. One is to follow the Spanish Oracle Master Raulibaper Learning to share, to learn by directory. I will post the master's post-editing for your reference. Another is that, according to the online collection of predecessors to contribute to the simulation questions, do not stop doing exercises. The two, none of it.

On the network also has many predecessors wrote many OCM examination summary, mainly is the examination content aspect, everybody may refer to, I this side to repeat. I mainly want to meet some of the questions before the test, to introduce you, I hope to help you!

First, the examination environment question

1. Test location

Three places in China can take exams: Beijing, Shanghai, Guangzhou. Guangzhou in previous years, the frequency of the test is particularly low, so I went to Beijing to take the exam. Can behold this year, Guangzhou Anomaly, more than in previous years to increase the number of games, such as May there are 3, June there are 1, so if you have friends from Guangzhou closer, you can consider and so on to find a Guangzhou test time.

You can go to the following website every day to choose where to take the exam:

Http://education.oracle.co.uk/html/oracle/28US/SCHED_SP_OCM.htm

In addition, the Beijing Examination Room Machine memory is 4G, other friends to introduce the Shanghai Examination Room Machine memory is 8G, much faster. We can also refer to it.

2, odd machine, even machine

This problem, in fact, the network has been a lot of introductions, but also introduced quite clear. However, I was a little worried before the exam, so I want to tell you, really do not worry, is actually two independent pc in front of you, machine name is the same, only the last one different, used to judge the odd machine and even machine. Here is a quote from their introduction:

Odd Machines (EDSIR5P1) and even Machines (EDSIR5P2): In a real exam, there will be two machines in front of each person, an odd machine (ODD), an even-numbered machine (even), what to do on the ODD machine, or what to do on the even machine, The even or odd number depends on the hostname last or two digits of the machine.

3, is em installed?

Verify that there is no EM environment in the test environment and can only be installed on your own. In the Resource planning management, spa, need too many commands, but also very error-prone, my side is the manual installation of EM to complete. In fact, it will not take much extra time, you just need to publish a command to run it alone, you continue to do other topics, and then after it is finished, then use EM to complete the relevant topics.

4. is DNS installed?

Well, this stuff is already installed, you can check it with Nslookup. The DNS server in the test environment is a separate machine, not the same machine as the two RAC machines. Before the exam, I did not prepare for DNS, ready to use the Hosts file to install the RAC environment.

5. Do I need additional installation packages, such as various RPM?

The answer is no, the exam environment is 32-bit Oracle Linux, the database requires the package has been installed, no longer need candidates to worry about. I didn't have this problem at all during the exam.

6. Database Crash Scenario

The crash scene is also two games, respectively in Sec3-data Management and sec5-performance management part, just did not explicitly want you to restore the database, only when you do start the database to find this database is broken need you to recover. These two scenarios are: 1) the Redo log and the users tablespace file are deleted; 2) the System tablespace files and control files are deleted.

7, test questions are on the odd machine, in the form of Web pages to provide to everyone. At the same time it provides you with a button "End state" to check whether the test environment is normal, if not normal, require candidates to adjust the relevant parts to ensure that the results are normal. At the end of each skillset, do this action. In fact, it is to check whether the relevant database can be successfully connected. There may be traps, as described below.

Second, the difficulty of examination questions

1, skillset server configuration

1) requires all error, warning information output files to be located in the $oracle_home directory.

This question, remember to set the Diagnostic_dest parameter.

2) Patch, patch number seems to start with 128

The title is online patching, but I do opatch apply post error: $ORACLE The ORACLE file status in the _home/bin directory is active. I had to close all the instances before I hit the patch successfully.

3) End state found PROD4 instance status is incorrect

However, under the operating system to check the monitoring and instances are normal. At this point need to modify the correct prod4 tnsname connection string, this is a small trap.

2, skillset 3--data management

1) Materialized view tuning: gives a materialized view, but only sh.products a table. After executing the Dbms_advisor.tune_mview statement, the execution of the Dbms_mview.explain_rewrite statement finds that the result is always rewrite and unknown.

This topic, I did not take care of, everybody notice.

2) When transferring the table space, be sure to remember the dump file of the Solaris system mentioned in the topic. Remember to check which Solaris, encoding, 32-bit, or 64-bit support is specifically supported in V$transportable_platform, and then remember to follow the syntax strictly when using Rman conversion.

Convert datafile ' ****** '

From platform ' ****** '

To platform ' ******* '

Format ' ******* ';

Otherwise, the conversion statement is prone to unrecognized file errors.

3) External table: Generate external tables based on the provided gzip files, control files, and then import the data. Be sure to use the Uncompress file to extract, uncompress file exists in the control file. This place should be noted that the gzip file cannot be decompressed and then executed.

3, skillset 4--Data Warehouse Management

1) Insert a table some data (by executing a script), and then restore the data to the state before Updata.

The Flashback database statement should not be used, and the Dbms_flashback.transaction_backout statement should be used.

Select Versions_xid

From Test_employees

Versions between SCN MinValue and MaxValue

where versions_operation= ' U '

Order BY VERSIONS_STARTSCN;

EXEC dbms_flashback.transaction_backout (2,xid_array (' * * * * * *, ' ****** '));

4, skillset 5--performance tuning

1) When using spa tuning, when using SQL TUNE Advisor for SQL statements, and SQL ACCESS Advisor optimization, the 10g and 11g comparison of two scenarios found that the optimization was not achieved.

All I use is em to complete, and then not to achieve the goal of optimization, but everyone must take all the steps to complete the operation. Because it could be a trap for exams.

5. Skillset 7--data Guard

I use all the commands to complete the copy of the database through the duplicate command. Note that the two machines oracle_home the actual directory is inconsistent, you configure Tnsname connection string must be configured correctly, otherwise it can not be copied successfully.

In addition, the main practice of the service name with a domain name format, such as prod1.us.oracle.com, check whether it is feasible. When configuring the DGMGRL service name, remember to prod1_DGMGRL.us.oracle.com.

Iii. Summary of Examination Review

1, before the test must make a detailed plan, every day must be completed. Otherwise, it's hard to stick it down.

2, each test time is very tight, it is necessary to test in strict accordance with the exam time more than a few times, must be through a variety of ways to control the time. For example, a complex command should not be entered manually, using the EM bar.

3, each topic must complete, regardless of whether the result is achieved. When Oracle scored, I thought it was mostly about looking at your steps, and sometimes it could be a trap.

4, test if you find the test machine has problems, must be in time to communicate with the supervisor, it is likely to give you an extension of the test time. I was in the exam, a friend's computer automatically restarted, extended for nearly one hours, we have been waiting for one hours.

Above is my personal experience of a summary, I hope to help you!

Oracle 11g OCM Exam Summary