dba for dummies

Tags: style blog http color os io ar strong for REVOKE DBA Authority be carefulReprint: http://blog.csdn.net/lwei_998/article/details/6133557When certain users are found to have DBA authority, in order to be secure, we usually think of recovering DBA authority for these users.You must be careful when doing this in a production environment.Because when you take b

Tags: blog http using os strong data AR ArtAs a MySQL DBA, you must have the following qualities:First, physical fitnessThe DBA must receive and process various alarms, whether at noon or at three o'clock in the morning, into deep sleep. Received the alarm need to immediately enter the emergency state, find the computer, connected network, quickly locate the cause of the failure, and solve it. Poor sleep st

Why does the SQL Server DBA learn PowerShell? From: http://www.simple-talk.com/ SQL /database-administration/why-this-sql-server-dba-is-learning-powershell/ Joe. TJ is used only for the purpose of disseminating information. SMO is an object set that allows you to automate any Microsoft SQL Server-related management tasks. Similarly, for DBAs who are not familiar with object-oriented programming, the biggest

Many developers want to become a database training, and many people first position themselves as a DBA. What knowledge and skills does DBA need to master? Below are myDuring DBA work and interviews, there were thirty questions about DBAs and many minor questions about the thirty major questions, it covers many technical knowledge points of SQL Server 2008 R2 trai

is in SYS mode, and sysoper is in public Mode) DBA authentication method There are two authentication methods: 1. operating system authentication. 2. Password File Authentication Which authentication method is selected depends on two factors: 1. Whether the user's operations are performed locally or through the network. 2. Whether or not a reliable network connection is used through the network. Operating system authentication method 1. Create a n

Many developers want to be a DBA, and many people first position themselves as a DBA. What knowledge and skills do DBAs need to master? Below are my During DBA work and interviews with DBAs, there were thirty questions about DBAs. Among the thirty questions, there were many minor questions, covering the skills of SQL Server DBAs. TIPS: 1. Differences between char

IMP-00013 only DBA can import files exported by other DBAs IMP-00013 only DBA can import files exported by other DBAs -- Instance demo--- System user ExportC: \ Users \ ZML> exp system/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml. log' tables = (zml) Export: Release 11.2.0.1.0-Production on Monday April 21 21:39:12 2014 Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved. Connect

I finally completed all the OCP DBA courses. Tired! In general, Oracle certification is worth the test. I have a ccnp and MCSE certificate, but after passing the DBA examination, I feel that I have not only deepened my understanding of modern databases, but also enriched the knowledge structure of computer science. In my opinion, Oracle databases even have some operating system functions. There are quite

The following articles mainly describe the Common commands of Oracle DBA through the code of the actual application. If you are a beginner in Oracle DBA, you can use the following articles to understand the specific operations or related functions. The following is an introduction to the text. Create temporary tablespace createtemporarytablespacezfmi_temp tempfile'D:\oracle\oradata\zfmi\zfmi_temp.d

If you want to succeed as an Oracle database DBA, you must have some questions about the relevant Oracle Database DBA. The following are some practical questions and answers, the Oracle Database DBA exam brings you some gains. 1. Explain the differences between cold backup and hot backup and their respective advantages Answer: Hot Backup is applicable to database

DBA, be careful what you do. Spring is coming, sitting in front of the computer for a few hours before continuing to work is more easy to head dizzy, as I have said, the last two weeks in the preparation of the Cape is always missing a semicolon or misspelled keywords; Yesterday before someone wanted me to ask for advice, because he used toad Delete all the tables, this is not intentional, but open a number of tabs or multiple windows, and

The level of DBA is not very strict. According to the database mastery, I simply divided into three levels: primary primary, Intermediate intermediate and advanced senior. The Junior DBA, also known as Dbbs, is the abbreviation for the English database Baby sitter. Junior DBAs are often part-time, and they are often programmers or other jobs. Junior DBAs tend to write personal resumes well and participate

: Network Disk DownloadIntroduction DB2 database is the core product of IBM's relational database, and it is widely used both domestically and globally. For DB2 beginners, the "Step DB2:DBA system Management, operation and application case" gradually introduced the many concepts and knowledge DB2 involved to everyone. Client connectivity, instances, databases, tablespace and buffer pools, data movement, backup recovery, SQL basics, DB2 Basic monitorin

before discussing your salary and position. If you can avoid it, never talk about salary until you confirm that you have proved your value. Because the interviewer wants to keep the negotiation after the offer. 　　10 sentences to avoid Which of the following are examples of true candidates: 1. "I cannot start my work within five weeks because I have a vacation plan ." 2. "I don't really need this job. I just want to see if there is a better job out there ." 3. "Can we summarize it now? I have to

space at the university and share them with you to prevent me from happening in the past, it takes a lot of time. The following are all recorded at that time: Today, I logged on to Oracle with SCOTT. When I edited the table, I found that I didn't have the corresponding permissions. So I wanted to log on to sys and grant the DBA role SCOTT as a DBA, however, I couldn't remember the password. The Oracle data

synchronization Configuration2. Mysql dual master Configuration3. Configure high-availability databases for Mysql dual master + cluster database + keepalivedClientAs a DBA, do not use various GUI tools. mysql comes with the command line client, which is your best weapon.Optional1. mysql partition configuration, because there are too many restrictions, the actual table sharding is performed by the program.2. High-Performance mysqlA). drizzleB). MariaD

Before the business system stress test, Oracle dba must complete the work in advance. oracledba This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661 Before the business system stress test, the Oracle dba must complete the following work in advance: 1. If Oracle database software is not installed by

; Conn Test/test as Sysoper; is connected. Sql> Show User USER is "public" Sql> Conn Test/test as Sysdba is connected. Sql> Show User USER is "SYS" Sql> 3, the difference between DBA and SYSDBA DBA, Sysdba What's the difference between the two system roles, before I explain this, I need to talk about the Oracle service creation process • Create an instance • Startup instance • Create a database

ORACLE11G is a more generic version, trying to install Oracle 12c unfortunately failed, there is no wayThe following is the collation of information 1. Attached to the installation file Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip? authparam=1407205871_4259949f8bacf912168631692563a693Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip? Authparam=1407205876_ec394cc017d1815a8cce7cc31e0f0bb9 2. The concrete steps are as follo

Tags: adding to Oinstall and DBA user groupsUsermod-g oinstall-g dba-d/home/oracle Oracle-G is the Oinstall group for the specified user's primary group-G is the DBA group for the specified user's secondary group-D for the specified user's home directorystatement is defined in detail to designate the primary group of Oracle users as OinstallSecondary group specif