Blue growth note-chasing DBA (11): After going home, I woke up and went home.

Source: Internet
Author: User

Blue growth note-chasing DBA (11): After going home, I woke up and went home.

 

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/41480461

[Overview]

Personal Growth records on the oracle Road, expressed in blue, share the growing emotions, vision and technological changes and growth. Sensitive information is replaced by English and will not disclose any confidential information of the company. It is only used for technology sharing.

The creative inspiration comes from self-reflection and recording. I'm glad to have some help or resonance with the database friends who just started out.

Please leave a message or email (hyldba@163.com) indicating that the technical details are incorrect. Thank you very much.

-------------------------------------------------

[Preface]

This is an accumulation of personal records. As we enter the blue ocean of oracle, we can't go all the way and continue to test. Share the growth history of blue with database friends.

I don't know when I began to become obsessed with blue. I was obsessed with its wide range, its depth, and its close proximity.

But it cannot be clear from when, watching the oracle red dazzling, illuminating a light in front of the eyes, unknown and confused under their own feet began to reveal some of the enrichment of life and the feedback of youth.

Step by step on the path to pursue DBA's dream.

-------------------------------------------------

FuXi disaster, the blessing of the treasure. I am worried and happy.

-- Deep Blue

It was recorded in Harbin in 2014.

 

As the cloud gradually became clearer, it was lost and flew from Zhengzhou to Harbin.

When I got home, I found that Harbin was much colder than Beijing and Zhengzhou. I had a short time studying in Zhengzhou and now I feel the temperature I know. At that time, I was alone, it is still difficult to calm down, and of course it still seems to be calm. Just like arranging in the dark, it seems that I did not go back to my house during my regret on the 11th day yesterday. Today, I went back to this place on a business trip, like a gift from God, it's more like a break before a workout begins.

In the four months after joining Beijing, just after the final period, what I did not expect happened. Teacher Chen from the Group sent me back to the station, so I was arranged to take over the work of Teacher Chen. It may be that the lead has another arrangement, or it cannot be said that the lead is too idle (O (lead _ lead) O ~~). In short, a new project, a project that I initially feared. I once thought this was a "big pitfall" project, and it may not be able to be pulled out if it is stuck. To be honest, there was some resistance at the beginning, but some were not self-defeating. Fortunately, looking back, we often find that some "Opportunities" are "bad ".

Chapter 1: hardware and software sharing experience

An open growth environment should be the most important indicator for young people to choose their jobs. I am lucky. My thoughts when I joined the company were actually very simple-1. Come to Beijing; 2. Solve the problem. I did not expect to gain an unexpected growth space here. I have some feelings: In the past, it was often counterproductive to pursue something or someone, however, when you don't want to "stop" or do not "force", what you once pursued will naturally become a reality.

When the servers and storage of hardware are in front of us, we realized why we should "theory" and "practice ". In some cases, after being touched by a physical object, it may be mysterious to be covered by a veil. For specific hardware insights, We will summarize the technical context in the future. Here we will not mention the technical aspects.

At the software level, for oracle RAC and WAS cluster nodes, haha, under the supervision of the leaders, turned the theory into the sentiment after practice. In addition, the first attempt to use udev to add disks to the cluster avoids the tedious method of installing the asmlib package to create an asm disk. It will be summarized and explained later. It's just a sigh that the growth of actual work is indeed broad in terms of contact. But at the same time, it is becoming increasingly "silly" to install RAC. Indeed, DBAs cannot stay at the construction level, and management and maintenance require continuous learning.

Chapter 2: SQL skills for growth

The polishing of the project follows the idea of a project, which was expected to happen in real life. For a while, I don't think it's true. At that time, I was relatively resistant to this project because of my lack of SQL knowledge. In the past few months of transformation, I did not focus on SQL. In terms of capabilities, I may just be able to understand a few simple syntax additions, deletions, and modifications. And understand the syntax. In actual use, we still need to refer to it. This is indeed a bit explicit. For SQL and PL/SQL capabilities, it takes some time to polish them. It is not a day or two, because it requires a real environment. Only practice can understand and be proficient in this. Fortunately, the opportunity is coming. This time, an important goal is to migrate data. It is also cross-platform and cross-business system. Therefore, the knowledge of using ETL tools, using SQL statements, and interfering with data through SQL screening is all in front of us. From letting the super brother teach and then to R & D's brothers, the growth is like this, 1.1 drops. Recycling found that SQL is no longer so resistant, and began to have their own ideas to write some query statements and so on. In fact, this is not difficult, it is a process of understanding, proficiency, and integration. For SQL learning and PL/SQL Developer usage, I will summarize it later. The technical aspects here are not described in detail.

Chapter 3: joint development with R & D

I would like to thank my R & D colleagues for meeting the growing partners. Fortunately, you need to start your own efforts. When a R & D team eats with you every day and goes to and from work, you will find that your body is changing slowly. The way you think about the problem, the way you learn it.

Does the work of "creating a database for a major security project in a ministry or ministry" sound a little tall. Haha, I thought it was mysterious, but I found out that hundreds of tables are actually "That Thing" at the technical level ". The difficulty lies not in the establishment, but in the maintenance and management after the establishment. That thing may make a DBA or destroy a DBA. It can be said that it is easy to build the country, and it is difficult to keep the country.

Of course, we have to mention "coordination ". At work, this proportion may be higher than that of technical work. This is often seen in a project team with dedicated personnel for coordination, and such people often become "a leader ". The reason is very simple. A large security system involves a lot of data extraction during the construction process. If there is no data, any application system is meaningless. When extracting data, many interfaces are not open. At the technical level, data is like a gun used for war. If it is easy to give it to others, it is certainly not acceptable. Therefore, coordination and competition are a technical task, there are various channels that can only be said or not. O (distinct _ distinct) O ~~

Chapter 4: Reflections on ease and the feeling of security, focusing on oracle Learning

When people are idle, they like to think about things. When people are comfortable, they forget the pain they once suffered. It's not too short. I have been at home for a month. Looking back at the gains of the past month, I felt very lucky when I was "pushed and pushed" at work, and I was sure that I had chosen to go out right at that time, A platform can really shape a person. Even if you get stuck, an environment will push you forward. But at the same time, I felt a little uneasy, because some of them were not at their own pace during this time, and they had less thoughts, and their learning strength was somewhat stagnant. So we should make a sort out and start learning the path of oracle again.

Tasks for the next month:

Serial number

Project point

Overview

1

SQL

Theory + practice = Application

2

Single-instance oracle Optimization

Index + Memory = optimized

3

RAC cluster management and optimization

Stable + efficient = production database

4

Backup Recovery

RAC + single instance = Cost of meal tickets in all aspects

5

LINUX

Command + command +... + command = Master

Task 1 outside of work:

SQL Basics

Lab project point

DML

DDL

Constraints

Table

View

Index

Permission

Declare Variables

Executable statement

Interaction

Control Structure

Composite data type

Cursor

Exception Handling

Management Process

Package

Function

Trigger

Stored Procedure

As a structured query language, SQL sorts out the various knowledge points above:

SQL Basics

1. Oracle Database basics;

2. SQL basics.

Data Definition Language (DDL)

1. Create a table;

2. Create an index;

3. Create a view.

Data Query Language (DQL)

1. Basic query;

2. Use functions in the query;

3. Multi-Table query;

4. subquery.

Data Operation Language (DML)

1. Data insertion (addition );

2. delete data );

3. Update (modify) the data ).

Data Control Language (DCL)

1. Security (grant, revoke );

2. set role ).

Other language projects

1. Stored Procedures;

2. Trigger;

3. cursor.

Reflection is a reflection. Of course, our life will continue, and we will continue on the good side.

-- Deep Blue is recorded in Sunday, Harbin, November 23, 2014

 

Series links:

Blue growth note-chasing DBA (1): traveling on the road to Shandong 

Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.

Blue growth note-chasing DBA (3): importing and exporting data on antiques becomes a problem 

Blue growth note-chasing DBA (4): recalling the sorrow of teenagers, and exploring oracle Installation (10g and 11g in Linux) 

Blue growth note-chasing DBA (5): Not talking about technology or business, annoying Application Systems

Blue growth note-chasing DBA (6): doing things and being human: Small technology, great human

Blue growth note-Chase DBA (7): Basic commands, foundation stone

Blue growth notes-chasing DBA (8): repicking SP reports and recalling oracle's STATSPACK Experiment

Blue growth-chasing DBA (9): Chasing DBA, new planning, new departure

Blue growth note-chasing DBA (10): Flying knife defense, familiarity rather than expertise: Playing with middleware Websphere

 

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/41480461

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.