dba for beginners

　　Although this is a foreign translation article at the beginning of 99, many contents are also suitable for today's DBA.In recent years, I have been dealing with database administrators and have directly interviewed many DBA jobs. This article will summarize the requirements of the IT industry for DBAs and the new status of domestic DBAs. Certainly, it is a good job to be a senior DBA. If you want to becom

Blue Growth Kee-Chase DBA (2): Install! Installation! A long-lost memory that caused me to re-perceive the DBAStatement ***************************************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

Http://www.itpub.net/519295.html * Introduction Over the years, I have spent a lot of time in different news groups talking to people who want to know how to get a database administrator (DBA) or how to grow into a DBA, now they have a job. Over the years, many people have raised different opinions on how to achieve this goal. This article provides good suggestions on how to effectively complete DBA's work.

. Step #4: Read, read, and read again-Since you have just started your DBA career, you are starting to lay the foundation for your skills. This takes a long time to form, absorb and understand all the knowledge you will learn. There is no doubt that you have to do a lot of work than your senior dBA, so they may not always free up a lot of time to help you learn. You have to learn many things by yourself. Th

the Oracle 9i backup and recovery guide) are from Oracle documents. Step #4: Read, read, and read again-as you have just started your DBA career, you are starting to lay the foundation for your skills. This takes a long time to form, absorb and understand all the knowledge you will learn. There is no doubt that you have to do a lot of work than your senior dBA, so they may not always free up a lot of tim

I should be oneDBA? One of the questions I have asked is whether a person should be engaged in a profession like DBA. This question is not easy to answer because it varies from person to person. Some people have the talent they need to become a good DBA. Others do not think it is easy to master the secret of becoming a DBA. The

Tags: logical schema Process failure recovery View Engineering document setting up thingsIt's July 5, 2017, 23:11. I am now working in an internet company in Shenzhen, working as a database engineer. Recently a little disoriented, overwhelmed. What is the reason? Although I have been to this company for more than a year of work experience, is engaged in database-related work, but I did not study in-depth, and even the most basic things are not mastered well. So that now, do everything to re-lear

How can I get the first copy?DBAWork? You have read the previous sections and think that it is a good job to become a DBA. Congratulations! I hope your career will become so exciting and meaningful as you think. So how do you find the first DBA job? I have heard this question many times. In the early 1990s S, the Internet was booming. It makes the company like grass sprout. Companies flock and begin to cre

What is the job responsibility of the DBA? What your DBA should do every day. How to grow and optimize DBAs in a stable environment. This is a lot of people have raised the question, below is my point of view and suggestions for reference. 1. Real-time Monitoring database alarm log As a DBA, or even just a technician dealing with an Oracle database, you must know

Test environment: win2003 + oracle10gr2 Set environment variables:Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1Set java_home = % ORACLE_HOME % \ JDKSet Path = % java_home % \ bin; % PATH % Go to the ISQLPLUS directory:Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS Enter the jazn command environment:Java-djava. security. properties = % ORACLE_HOME %/sqlplus/admin/iplus/provider-jar % ORACLE_HOME %/Solaris/J2EE/home/jazn. jar-user "iSQL * Plus

Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches", dba hardware manufacturers 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/d

DBA Note: a dba diagnostic tool-Event 10046 and 10053 friend from an optimization tool manufacturer sent a case request to assist in diagnosis, it is unacceptable that a friend's optimization tool can produce results in 10 minutes when executing an SQL query in the customer's environment, the same query can quickly obtain the output results in other environments. The database environment is 9.2.0.8. First,

Blue growth note-chasing DBA (5): Not talking about technology, business, annoying application systems, not talking about dba ************************************ Statement *************************************** 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 d

Zero-basic learning cloud computing and Big Data DBA cluster architect [Foundation December 14, 2015 Monday], dba 2015 1. On the first day, you can easily enter a form in the morning, record fingerprints, take photos, and introduce yourself. 2. In the afternoon, the instructor briefly introduced PC, switch, router, Tower server, rack server (1U \ 2U), Blade Server, and tape drive. 3. Teacher Chen, Tea

After reading the manuscript "Oracle DBA manual" sent by eygle, I felt that the writing idea of this book was quite new. With the improvement of Database Technology automation, DBA's work value has begun to expand to a greater level. Therefore, sharing the experiences of some Pathfinder has become particularly valuable. Exposing its thinking process is a major feature of the technology circle in the web era. In some previous times, some engineers used

How can IDBAA beginner becomes an intermediateDBA? You have been a dBA for a while. Do you want to improve your technical level to the first level? What should I do next? First, go back to the previous section and check that you have completed all the steps. It is very important to thoroughly understand the SQL language. It is also important to understand the relational database theory and master basic database management tasks. Up to now, you should

SQL Server uses cursors to deal with the extremely competitive performance of Tempdb-DBA issues-required by programmers, tempdb-dba Competition in SQL Server tempdb allocation is a common issue for DBAs. Almost all DBAs now know how to create several more files to solve/alleviate the problem. however, deep competition is inevitable. this section analyzes the features of the cursor in tempdb so that it can r

Open SQL Plus Enter user name : sys as SYSDBA Enter password: can be directly enter Connect to : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Productionwith the partitioning, OLAP, Data Mining and Real application testing options ALTER user SYS identified by admin; The user has changed. Conn Sys/admin as SYSDBA; is connected. Alter user system identified by manager; The user has changed. Forget the

Blue growth note-Chase DBA (17): whether to share or consume, learn to grow in the Post-IOE Era [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, wa

establishment, and design of required indexes and objects. This is the foundation for future technological development. There are too many examples of this. Here I recommend a book for beginners. I can read this book: Liang jingbin's harvest, more than oracle. this was the first oracle-related book I purchased at the time, from which I benefited a lot from both knowledge and thinking. Next, let's talk about my knowledge of