Shulou(Shulou.com)06/01 Report--

It has been nearly five years since Beijing drifters in 2012. In fact, it was two or three years since dba played with the database. The school did not have a deep understanding of sql server at that time and only learned some simple sql sentences. From 2012 to 2014, because it was relatively easy to do a job in operation and maintenance at the university, I decided to take the ocp. At that time, the reason for doing the database was very simple. Search the dba job on Zhaopin and the future. there is a great demand for employment, and at that time the salary is higher than the job I did. It's a simple idea, Beijing drifters? Floating out, after all, money is a living thing in Beijing, more is still useful!

Among other things, the idea of taking the ocm was started when I got the ocp in 14 years, but it was temporarily shelved due to high training and examination fees (more than 20, 000 at that time, less than 30, 000 now). After all, there is not much money left all year round except rent, electricity and living expenses, which is a lot of money for me. With the yearning for the title of master oracle, and the touting of various training courses on the Internet at that time, the master certification was really praised to the sky, just like today's iPhone7. I want to take it down, and I feel that the whole TM is a routine for marketers to play. The handout of the OCM certification course is clear, don't say it, at least the personal feeling is about 40%, at most, it will not give you a systematic and comprehensive introduction to the operation of oracle, the training course! After all, it is a for-profit organization. Don't believe the marketing department's course sales, they will give you the feeling of job-hopping after you get the certification, making you feel that money will fall on you at any time.

The ocm exam is divided into nine scenarios. The invigilator of oracle before the exam, that is, the teacher responsible for the opening of the examination room, will explain the location of the official website files, the system password, and the places where modification is prohibited. The root user is locked and the root permission is replaced by sudo. During the exam, the teacher will uniformly arrange the environment, and the real invigilator is said to be the 8 cameras overhead + remote Indian examiners, which doesn't seem to have much to do with me. I am not afraid to throw 10 children in front of me, hehe. I'm just kidding.

Scene introduction:

01.Server Configuration (11g OCM)

02.Managing Database Availability (11g OCM)

03.Data Management (11g OCM)

04.Data Warehouse Management (11g OCM)

05.Performance Management (11g OCM)

06. Grid Control Installation (11g OCM)

07.Data Guard (11g OCM)

08.Grid Infrastructure and ASM (11g OCM)

09.Real Application Clusters (11g OCM)

I think the first scene is very approachable, but not very technical. To build the library manually, specifically, I refer to the init.ora file to edit pfile, and then use the database-building statement create database. I am not sure what the examinees of other training courses are, but basically the database-building statements on the official website of cp are used to modify and then create the database, and then run the three scripts that the system needs to create views, indexes, and synonyms. Ok, monitor and configure them. It is OK to have remote access. The other things are listening configuration, undo parameter setting, session,process,object,dispatcher configuration and so on. It is worth noting that there is a test question mounted on the DNFS file system. I think this is very practical, but the examination questions have almost configured the environment. Under fatab, the directory has been mounted to the local host from the remote end. What you need to do is to edit the oratab file and modify the so question under make under the lib directory. I can't remember the name clearly. It seems to be on the official website. Scenario 1 is basically a game. I personally think the purpose of scenario 1 is that oracle wants to test your role in data composition, configuration information, monitoring and several key internal parameters. It takes 130 minutes.

The second scene is basically the backup of the previous scenario 1, and you need to register the catalog information on the even number machine. The function is to prevent controlfile from recording your backup too much, resulting in the continuous growth and expansion of files leading to failure damage, as well as the creation of database link, and the investigation of flashback flashback data. I feel that scenario 2 will be used in the flashback work. There are several options to add to this backup, and there is no quality in other questions.

The third scenario focuses on data failure recovery, VM (refresh of materialized views), creation of external tables, data import by sqlldr tools (it feels that ocm does not show the power of sqlldr at all), transmission tablespaces, and parallel parallel settings. The data on your odd-numbered machine is lost, and you need to use the backup of scenario 2 to restore. The three common tricks of rman are that both of your libraries have been archived and backed up. If you directly listfailure,advise failure,repair failure, the failure can basically be repaired, which rman is still very powerful. Materialized view, I never messed with myself when I learned ocm before, but it seems that I have worked for such a long time, and there seem to be few businesses that use materialized view. As for the external watch, I didn't understand the truth of the goods at all. I just buried myself in the practice and got familiar with it. After that, I will take a closer look at it and understand it. After all, I have to live up to the master certificate. In addition, the transfer of tablespaces is often used in this work, and the depth of this investigation feels good. A tablespace given by convert is converted to the platform of the current library, and then online. By the way, it seems that I also examined the question of a starstar query, which is not well understood, so I ignored it. To mention, this is the data query after the creation of the index on the primary key or foreign key column. You can see the direction of the index when you execute the plan and query. After the parallel do not say, work seems to seldom use this thing, I am in operation and maintenance, development buddies, please ignore this.

Scenario 4 examines several partitioned tables, the creation and data insertion of tables containing lob fields, the data of flashback flashback delete, and the flashback tables from recyclebin

There is also the creation of a flashback archive object, which indicates a lack of understanding of the flashback archive problem. After that, I will study in depth.

Scenario 5, tuning, as early as scenario 1 has been configured with oem, scenario 5 is forbidden to start and stop the database, if you stop the library and restart, I'm sorry, I have to congratulate you, you got 0 points. In this game, I think if I pull it out to learn, I personally think it is worth going deep, because it also includes synonym creation, parameter setting of resource group, composite index, global index, and execution plan, imp/impdpexp/expdp tool guide data and transportablespace things. This representation is dba, which has been used in our work. But the most impressive thing is SQL PerformanceAnalyze, because I have never encountered or used this product before. The solution explained in this practical and realistic training course seems to be through baseline load and baseline capture, which has not been thoroughly understood so far. Then I will eat it, and then if someone pays more attention, I am revising this article.

Scenario 6, grid control- > GC installation and use, this can also be said to be used as the groundwork for using GC to build DG in scenario 7. You may often use database control--- > DC, which is rough, just like this centrally controlled software, which can manage multiple database instances at the same time, which is the way of web web pages. Do you feel that oracle may be like windows in the future, and you can also click a mouse to solve the problem. OMS---- > Agent agent---- > agent Registration-> collect OMS Repository-> oms summarize the web page-> URL is the URL. The gc unified management database is fine, but agent consumption and oms response may be a little bit, but utility is what we care about.

Scene 7, dataguard DG building, sorry I went home for National Day, the following is a brief description. If your company has done dg, you have no steps, online search bar, the power of netizens is quite powerful, DG is also a commonly used way of HA, at least with this product, oracle will not ask for extra money, if you encounter goldengate, you have to pay some money to buy, but ogg supports cross-platform features, if there is no shortage of money, it is still worth spending some money.

Scenario 8, scenario 9, these two scenarios are to configure rac, with a time of 50 minutes and a short time of 60, but it is absolutely enough, because they have all been done with things like messy system patches, asm associated packages, and even asm disks, not to mention the adjustment of system kernel parameters. Alas, it is really untechnical, but there are several questions after installation, which require you to create volumes and mount shared directories on asm. And asm file system snapshot creation, backup ocr registration information file OLR to the local. In Farm 9, you need to create a sequence, plus an additional service service that specifies the use of the resource POOL.

This is the end of the introduction to the exam scenario.

Finally, if you really take the OCM, I personally feel that this product seems to be a bit of a gimmick, a little water, master, who dares to say that taking this is a master, he can guarantee that he will know everything, and the real master can be so good as to eat the official documents, how much courage and courage it takes to point out where to hit and where to achieve this library like what he has developed, coupled with the fact that he continues to deal with failures and accumulate experience at work. You will arrive in the western sky and get the true sutra. You can't eat a fat man in one mouthful, don't expect to change jobs and get a lot of money if you take a certificate. If you take too much, how can we live honestly?

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.