dba for beginners

Here's the solution: 1-from the command prompt, stop isqlplus:C:\>isqlplusctl stop 2-assuming that you install Oracle under C Drive, run the following comands: C:\>set oracle_home=c:\oracle\product\10.2.0\db_1 C:\>set JAVA_HOME=%ORACLE_HOME%\JDK 3-change directory to: CD%oracle_home%\oc4j\j2ee\isqlplus\application-deployments\isqlplus 4-suppose You need to create a new user with user name ' Yoyo ' and password ' ch51***** ', run the following command: %java_home%\bin\java-djava.security

Master Eygle's seven tips for DBAs What is the job responsibility of the DBA? What should the DBA do every day? How can a DBA in a stable environment grow and work? This is a question that a lot of people have raised, I scribble, the arbitrary record of my views and suggestions for reference: 1. Real-time Monitoring database alarm log This is a must work, and

Original: 2-year summary of SQL Server DBA tuning2 years SQL Server DBA Summary of tuningWhen I was 2 DBA I felt that there was something that needed to be shared with everyone to discuss the book first.Book List1. "In-depth analysis of SQL Server 2008 series" This is the MSSQL 2005 Technology Insider series. Version 2012 also out of interest can see, Technical I

Programmers who write large terminals often have the illusion that the SQL language is simple and the DBA works easily, especially for Android programmers who are accustomed to SQLite and its extended framework Ormlite and Greendao. Especially when an Android programmer sees himself in college and hangs up and repeats his lost friend after working as a DBA: "If you don't study hard, you can only use SQL add

Label:The differences between Oracle DBA and SYSDBA are as follows:1. A DBA is a role that corresponds to the set of operations permissions on an object in an Oracle instance, and SYSDBA is a conceptual role that is a sign-in authentication identity. Moreover, the DBA is an object in Oracle, and the Role, like user, is a real physical object in Oracle, and SYSDBA

triggered or any other method is required. Once this function is triggered, the user can be successfully promoted to DBA permissions. Example: www.2cto.com First, we create a user birdarmy who has the permission to create tables and functions. To facilitate the test, I directly grant them the connect and resource permissions. SQL> create user birdarmy identified by 123456; User created. SQL> grant connect, resource to birdarmy; Grant succeeded. Use t

Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data. Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data. Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tabl

As a DBA, you must learn the following 11 basic Linux commands that will not die: dbalinux Most databases run on Linux and UNIX platforms. As the computing power of the X86 platform approaches or even exceeds that of minicomputers, and with the tide of IOE removal, more and more databases run on the Linux platform. The Linux system is huge and complex. As a DBA, some basic management, network management, ad

I have not visited the blog Park for about half a year. It seems that I have been busy for the last six months. I don't know what to do. Recently, I accidentally thought about the value and development direction of DBA? There should also be a lot of DBAs in the circle, or they are interested in DBA work. I am also trying to figure out the value and development direction of DBAs. I have read a post a few

Authorization for CONNECT, RESOURCE, and DBA in ORACLE CONNECT, RESOURCE, and DBA are the three built-in roles of the ORACLE system. The role permissions are as follows: CONNECT: users with the Connect permission can only log on to ORACLE, create entities, and create database structures. RESOURCE: users with Resource permissions can only create entities, but cannot create database structures.

During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible. Oracle Warning log file monitoring Oracle will log some of the database operations in the warning log file (alert_sid.log) during the run: The database is started, shut down, not default parameter when starting; Database redo log switching, recording the time of each switch,

teacher, tested PMP dry project management bar. For a person with no management experience, a bunch of big theories, which company will bring you the project ... Worked years in a company? ... SQL SERVER DBA finally embarked on this road .... DBA This road is still not a good way to go, want to be a DBA just rely on the development will write the point

Tags: Oracle video tutorialOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employment, high-paying employment. The course focuses on Oracle company profile, Oracle Database Introduction, why do you want to learn Oracle database? , what is the job outlook for Oracle? , how do you learn about Oracle database treatment? Who is th

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