dba for dummies

The solution is as follows:1-From the command prompt, stop isqlplus:C: \> isqlplusctl stop2-Assuming that you install oracle under C drive, run the following comands: C: \> set oracle_home = c: \ oracle \ product \ 10.2.0 \ db_1C: \> set java_home = % ORACLE_HOME % \ jdk3-Change directory: Cd % ORACLE_HOME % \ Solaris \ j2ee \ isqlplus \ application-deployments \ isqlplus4-Suppose you need to create a new user with user name 'yoyo 'and password 'ch51 *****', run the following command: % JAVA_HOM

Oracle DBA manual-database diagnosis cases and performance optimization practices (planned by guobiao) Pricing: ￥59.80 Member price: ￥44.85 (off) Example of this book free trial: http://www.china-pub.com/196286 [Basic Information]Author: Editorial Board of Oracle DBA ManualPress: Electronic Industry PressISBN: 9787121101397Mounting time:Published on: February 1, January 2010Start: 16Page number: 407Version:

DBA work summary For more than a year, I have respected and respected the leaders to unite my colleagues, obey the rules and observe the discipline, learn professional knowledge, and work diligently. Summary of the past, in the knowledge structure, can complete the EBS-DBA of the work; in the daily work XX, can complete the EBS-DBA of the work tasks, adapt to th

First introduce the next Jane Chaoyang. is now working in Alibaba (China) Network Technology Co., Ltd. DBA Team Operation Department, Jenzhiang is the MySQL Technology essay contest third winner (winning article: the implementation of MySQL replication principle). He believes that his work experience will certainly be helpful to those who are now entering the DBA industry or are learning about MySQL technol

1. Database availability, DBA says "not counted"-materialized view, faster query speedAt some point, the availability of the database is not set by the DBA. Because even if the DBA has absolute control over the database, users may feel differently from their own work and application perspective than the DBA.What they want is speed! Very simple truth, maybe you ha

Label:Original URL Link: http://wangwei007.blog.51cto.com/68019/1718311 MySQL is a cross-platform open source relational database management system, currently MySQL is widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database. As MySQL is widely used on the Internet,

The daily work and responsibilities of DBAs in Oracle --- [1] The following summary is a summary written in "Deep Oracle", which corresponds to the amount of funds learned. 1. Let's take a look at Oracle's learning route: 2. learning basics: I have learned basic Oracle knowledge and have a general understanding of Oracle. 3. Objective: To give students who have learned the basics of Oracle a better understanding of the Oracle mechanism. Understand the work and capability requirements of OracleDB

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, o

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all oracle data dictionaries in sys are stored in sys users. These base tables and views are crucial for oracle operation and are maintained by the database, no user can change it manually. Sys users have the role or permissions such as dba, sysdba, and sysoper, and are the users with the highest oracle

The vast majority of databases run on Linux and UNIX platforms, and as the X86 platform's computing power nears or exceeds minicomputer, and in the tide of the IoE, more and more database environments run on Linux platforms.The Linux system is large and complex, summarized as a DBA, some basic management, network management, advanced applications, performance diagnostics, pipeline complex applications, hardware-related sensing commands need to master,

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find the RMAN catalog if a particular archive log has been backed-up?3. How can I tell how much it's left in a given file system and how much

SYS and SYSTEM user differences 1 The most important difference, the importance of storing data is different SYS the base tables and views of all Oracle's data dictionaries are stored in the SYS user, which is critical to the operation of Oracle and is maintained by the database itself and cannot be manually changed by any user. The SYS user has roles or permissions such as Dba,sysdba,sysoper and is the highest user of Oracle permissions. The system

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find the RMAN catalog if a particular archive log has been backed-up?3. How can I tell how much it's left in a given file system and how much

Today we have a guest Steve travels in the UKWell, I know a simple answer is that the DBA is a database administrator, but what role does it play? If you had to describe it to a non-technical person, what would you say? The DBA plays many different roles and functions. I have seen or used some roles or features: Install SQL Server, manage server performance including disk space usage, backup management, acc

Label:Becoming a qualified DBA is not enough to understand how to encoding some SQL statements and simple database management, so a qualified DBA needs to understand every aspect of it, and can have the ability to debug performance, hardware, and software problems. This article will cover a few things that a DBA needs to understand, and the individual feels that

I. DBA's current adjustments to system performance and stability Currently, the DBA's efforts to adjust the system performance are roughly as follows:1. Optimizing On the hardware layer. This usually means spending money directly, buying equipment, and resizing.2. Optimize the database, such as adjusting initialization parameters and the physical structure of the database.3. Optimize the SQL of the application, such as analyzing statspack in the database and adjusting top SQL.4. There are only

After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA -- Linux general technology-Linux technology and application information. For more information, see the following. After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA. Why? To log on to isqlplus as a DBA, you must configure the Solaris User first. To use the xm

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 a

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 have read documents and other books. If not, you ar

how to find out which users have DBA authority We sometimes need to find out which users in the database server have DBA authority for security and Rights management.You can usually use the following simple methods to get the answer: Select the current database, execute SQL: Select the current database, execute SQL: SELECT * from Dba_role_privs where granted_role= '