The growth of Blue-chase DBA (11): The ease of coming home, the dizzy wake up

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

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

Introduction

An individual's growth record on Oracle's path, with blue self-metaphor, to share growing emotions, horizons and technological changes and growth. Sensitive information is replaced in English, and will not disclose any corporate secrets, purely for technology sharing.

Creation is inspired by self-reflection and record. If you can have a little help or sympathy for the beginning of the library friends, gratified unceasingly.

Welcome to make bricks, such as the technical details of the error, please leave a message or e-mail ([email protected]) indicated, greatly appreciated.

—————————————————————————————————————————————————

Objective

This is a personal record of the growth of the notes, since the step into the blue Sea of Oracle, inevitably all the way to the rush and constant test. By this story and friends to share the blue growth process.

I do not know when the blue has a kind of said not out of the obsession, obsessed with its breadth, obsessed with its depth, obsessed with the near and far away.

And don't know from when, looking at Oracle Red dazzling, illuminating a light, the unknown and confused at their feet began to show a little bit of life's enrichment and youth feedback.

Step forward on the path to the DBA's dream.

—————————————————————————————————————————————————

Blessed is the XI of woe, and the fortune of woe. Born of Sorrow, died of mercy.

--Dark blue

2014 of the essays in Harbin.

When the cloud gradually clear, vaguely flew from Zhengzhou to Harbin.

Back home, found that Harbin than Beijing, Zhengzhou, a lot of cold, in Zhengzhou two days of short study, now feel familiar with their temperature, a time, alone, the heart is still some difficult calm, of course, still seems to pretend calm. Just like the arrangement, as if in yesterday regretted 11 did not come home a trip, and today, business trip back here, like a gift of God, more like a temper before the beginning of the breathing.

Four months after the entry into Beijing, just after a positive period, and did not think of things happened. From the group of Chen teacher sent back to the station, so the new I was arranged to take over Mr. Chen's work. may also be the leadership of other arrangements, also said not good is the leader to see me too Busy (O (∩_∩) o~~). In short, a new project, a project that made me very frightened at first. Once thought this is a "big pit" of the project, trapped in may not be able to pull out. To tell the truth, there was some resistance at first, but some things were not about themselves. And, fortunately, looking back, some "opportunities" come when we often feel that it is a bad thing.

Chapter One: Hardware software-to-all growth experience

An open environment for growth, this should be one of the most important metrics for young people when choosing a job. I was fortunate that once the idea of the company was actually very simple--1, to Beijing, 2, to solve food and clothing. Did not expect here to harvest the unexpected growth space, some sentiment: in the past always spend the mind to pursue something or someone's time, often backfired, and in their own not to "re-meaning" or not "forced" when, once chased, so naturally one piece to become a reality.

When the hardware of the server, storage in front of the moment, only to realize why learning to "theory" combined with "practice". Sometimes the theoretical blunt knowledge, may be in touch with the object, the original everything is covered by the veil of mystery. About the specific hardware sentiment, then will be specialized to summarize the technical context, here is not too much to mention the technical level.

At the software level, for Oracle's Rac,was cluster node, under the supervision of the leadership, Haha, the theory into a practice after the sentiment. And the first attempt to use the Udev method to add disks to the cluster, bypassing the cumbersome installation of the Asmlib package to create ASM disks. After that, we will summarize and explain. Just sigh, the actual work of growth, the level of contact is indeed a lot of broad. But at the same time, more and more that RAC installation more and more "fool". Indeed, DBAs cannot stay at the building level, and management maintenance needs to be constantly learning.

Chapter Two: SQL skills to start growing

In the project of grinding, following a project from the beginning to the end, the past expectations of this vision, in real life has happened. For a time, I don't think it's true. At the time, it was more resistant to this project than the short board that originated from his knowledge of SQL. In the transition months, did not focus on SQL, in terms of ability, may only stay in the understanding of a few simple additions and deletions to change the grammar. and read grammar. Actually use up, still want to refer to come, this is indeed some worrying. For the ability of SQL and PL/MS, this takes time to polish, really not a day or two days to digest, because this needs the real environment, only practice can understand, skilled these. Fortunately, the opportunity came. One important goal this time is to migrate data. And it is a cross-platform, cross-service system level. Therefore, the use of ETL tools, the use of SQL statements, through the SQL sieve to interfere with the data and so on knowledge, this is in front of the real reality to do the work. From let Super elder brother teaches to do, then to research and development of Brother Inculcation, grow like this, bit by bit of happening. Recovery 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, these are not difficult, is an understanding, proficiency, mastery of the process. About the SQL study, the use of PL/developer, after a special summary, where the technical aspects of the first not specifically elaborated.

Chapter Three: Co-growth with research and development

Thanks to the development of colleagues, met the urge to grow up partners. Fortunately, more need to start their own efforts. When you have a research and development every day with you to go to work together, you will find the body slowly change. Think about the way the problem is, learn the way.

For "a Ministry of a major security project to build a database" work, it sounds there is no point on the tall. Haha, originally thought this is quite mysterious, and the actual participation in which only found that hundreds of tables in the technical level in fact, "that something." The difficulty is not the establishment, but the establishment of post-maintenance management. Just "that thing." The possibility of a DBA can also ruin a DBA. It is easy to play Jiangshan, to keep the Jiangshan difficult.

Of course, the "coordination" must be mentioned. At work, the proportion of this occupation may be higher than the technical work. This is often seen in a group of people who are dedicated to co-ordination, and such people tend to be "a leader". The reason is simple, a large security system in the building process, which will involve a lot of data extraction work, if there is no data any application system is meaningless. When extracting data, many interfaces are not open. At the technical level, the data is like war with guns, if easily handed over to others this of course not, so one of the coordination, dealing is a technical work, there can only be understood can not be told the various doorways. O (∩_∩) o~~

Chapter Four: After the ease of reflection, the feeling of the world, the journey of Oracle Learning

People idle down like cranky, people ease down on the forgotten once pain. Said short is not short, at home one months. And recall this one months of harvest, is in the work "abruptly was pushed away", I feel extremely lucky, and certainly at that time chose to go out of the right, a platform can really shape a person, even if you stagnant breathing, an environment will push you forward. But at the same time the heart of some uneasy, because this period some not in their own rhythm, their ideas are less, learning the momentum of some stagnation. So you should do a comb and start learning the Oracle path again.

Tasks for the next one months:

Serial number	Project Point	Overview
1	Sql	Theory + practice = Application of knowledge
2	Single-Instance Oracle optimization	Index + memory = optimization
3	RAC Cluster Management, optimization	Stable + efficient = Production Library
4	Backup recovery	rac+ Single Instance = Meal ticket in all aspects
5	Linux	instruction + instruction + instruction +...+ instruction + instruction + instruction = Master

Task one outside of work:

SQL Basics

Experimental Project Point

Dml

Ddl

Constraints

Table

View

Index

Permissions

declaring variables

Executable statements

Interaction

Control structure

Composite data types

Cursor

Exception handling

Management process

Package

Function

Trigger

Stored Procedures

SQL as a structured query language, the above a myriad of knowledge points to do a comb:

SQL Basics	1. Oracle Database Foundation; 2. SQL Foundation.
Data definition language (DDL)	1. Creation of tables; 2. Creation of the index; 3. Creation of the view.
Data Query Language (DQL)	1. Basic Enquiry; 2. function usage in query; 3. Multi-table query; 4. Sub-query.
Data manipulation Language (DML)	1. Data insertion (increase); 2. Data deletion (deletion); 3. Data Update (change).
Data Control Language (DCL)	1. Security (grant, REVOKE); 2. Unity (set role).
Other language programs	1. Stored procedures; 2. Trigger; 3. Cursors.

Reflect on the reflection, of course, life will continue to go on, and will continue to the good side.

--dark blue in Harbin November 23, 2014 Sunday

Series Links:

the growth of Blue-chase DBA (1): Rushing to the road and into Shandong  

Blue Growth Kee-Chase DBA (2): Install! Installation! A long-lost memory that caused me to re-perceive the DBA

the growth of Blue-Chase DBA (3): antique operation, data import and export become a problem  

the growth of Blue-Chase DBA (4): Recalling the youth, and then explore Oracle installation (Linux 10g, 11g)  

The growth of Blue-Chase DBA (5): No talking about business, annoying application system

The growth of Blue-Chase DBA (6): Work and life: small skills, great people

The growth of Blue-Chase DBA (7): Basic Command, foundation stone

The growth of Blue-chase DBA (8): Regain SP report, recall Oracle's Statspack experiment

The growth of Blue -Chase DBA (9): National Day, chasing DBA, new plan, new departure

the growth of the Blue-Chase DBA (10): flying knives to defend themselves, not expertise: fiddling with middleware WebSphere

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

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

The growth of Blue-chase DBA (11): The ease of coming home, the dizzy wake up