Become the path to Oracle 10g DBA

With the rapid development of Oracle technology and the market, the number of people working in Oracle DBA is getting bigger and bigger. I can see from some posts that I often post on forums and communities, many people are eager to work in this field now or in the future, and the market demand is also very large, but it is not hard to see that each company has higher requirements for the position of DBA, of course, high salaries, high challenges, and sustainable career channels attract a large number of young people to try to work in this field.

　

For a newbie who has never been familiar with Oracle database before, how can he quickly become an Oracle DBA is what they are eager for now. many people get into the misunderstanding because of their incorrect learning methods. The more tired they learn, the more confused they learn. The more they learn, the less they understand...

　

The question of learning methods can be said to be benevolent and wise. everyone has a set of habits that they are used to learning models and receiving new things. oracle ace guobiao has provided many valuable comments and suggestions for later students.

　

The following is an excerpt from some classic suggestions that Mr. Gai Guoqiang has made to Oracle fans regarding their learning methods and ideas.

1) overcome psychological fear obstacles

2) Learn to read carefully. The basics are more important than everything.

3) from vertices and surfaces, from simple to deep

4) test the knowledge learned through practice

5) See the notes

　

　

　

　

　

 

Having these basic qualities, coupled with strong interests and hobbies, becoming an Oracle DBA is not so difficult as learning other skills, it is not difficult to get started, but it is better to go further in this industry. On the one hand, in addition to hard work, on the other hand, it also depends on some opportunities!

　

If you decide to create an Oracle DBA, complete the following basic exercises first, and then step by step!

　

In each of the following steps, there is a lot of knowledge. I just gave a Learning Outline. If you can surpass it, you can see your own creation!

Step 1: first understand Oracle
1) Understand Oracle Database
2) understand the architecture and working principles of Oracle Database
3) what tools are commonly used to manage Oracle databases?
4) understand the daily work of common DBAs

Step 2: Install your first Oracle
1) Select the Installation Platform and software
2) read the Installation Guide to learn more about installation requirements.
3) install Oracle software
4) use dbca to create and configure your first Oracle Database
5) Use dbua to upgrade your first database to a higher version.

Step 3: Get to know Em

Necessary tools for DBA 2.0

1) Create and configure your first dbcontrol
2) use em to manage your first Oracle Database

Step 4: configure the Oracle NETWORK SERVICE
1) Understand Oracle Network Principles
2) use netca to configure your first listener and service
3) start and stop a listener
　

Step 5: Know the instance
1) understand the memory structure of instnace
2) understand the Oracle background process
3) understand the role of Oracle initialization parameters and learn to manage these parameters
4) start and stop the database

-- Understand the process of database startup/Shutdown

Step 6: understand the physical and logical structure of Oracle
1) control file
2) data files
3) parameter file
4) log files
5) Password File
6) archive files
7) backup files
8) other files
9) Recognize tablespaces
10) learn about segment
11) create, manage, and delete your first tablespace and segment

12) create, manage, and delete your first PL/SQL object

Step 7: manage an oracle account
1) understand the Oracle database user categories
2) understand the concepts of Oracle permissions and Roles
3) understand the role of Profile
4) create and manage your first Oracle user
5) delete a user

Step 8: Be familiar with Oracle data dictionaries and common dynamic performance views
1) Understand Oracle Data Dictionary

2) familiar with common Oracle dynamic performance views

Step 9: understand the concept of Oracle backup/recovery
1) understand the basic principles of Oracle backup/recovery
2) understand common backup/recovery methods and tools
3) Complete your first backup
4) Complete your first recovery

Step 10: Learn to monitor Databases
1) understand the Monitored Objects and objectives
2) familiar with basic knowledge of routine Oracle diagnosis and Optimization
3) Configure your first monitoring
4) diagnose your first problem (idea-method)

5) Use em to view your monitoring and report

　

Each step above contains a lot of knowledge points (I just listed a rough one, because I just saw a puber asking a similar question, so I wrote a little at will ), if you can keep learning these things completely, you will basically have the basic knowledge of getting started. Next, you need to guard against arrogance and rashness, continue to deepen, continue to accumulate and improve, on the basis of further in-depth study, we will gradually learn and practice Oracle's change management, diagnosis and diagnosis, adjustment management, configuration management, and other programs one by one.

　

Then, after you have a comprehensive understanding of Oracle Database, You can slowly learn other options of oracle, for example, RAC, dataguard, partition, streams, xml db, TimesTen, OLAP, and security options, at the same time, you can make a comprehensive review of the technologies in the overall solution of Oracle locally (in fact, you have already covered various other options ).

　

Some taboos during Oracle Learning

1) incorrect text

I often see a lot of people taking 8i, 9i materials on 10g, 11g experiment, don't say, also said oracle is not good that is not good!

2) less detours

To learn about Oracle databases, you should carefully read Oracle Database concepts (if you have time, you can read it and practice it multiple times). If you don't want to come up, you should pick up a collection here, if the concept is not clear, are you sure that every entry you enter will lead to the system? Don't spare me for a long time. In the end, I ran back to chew books and asked for help because of a conceptual problem.

3) impatient

To learn, you must be able to withstand loneliness and temptation. If we see this trend today and learn it tomorrow, we will feel that the hot topic has learned it, and we will be able to stay at the level of understanding, and it is difficult to have insights. The ancients said: "Everything is learned ." To realize the world's well-known things, you must make painstaking efforts to study and study carefully to obtain the true meaning.

　　

Dear Oracle fans, when will they wait?

　

Finally, I hope that Oracle fans can learn about Oracle technologies to build their own future and change their fate! Good luck!