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
Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the knowledge structure of computer science. I think, in some ways, Oracle databases even have some operating system capab
, memory, and external storage is quite
Complex, these factors must be considered. In addition, pl/sql packages, stored procedures, temporary table empty
, the table structure itself, all of these will become increasingly complex as they are used to ensure that the database
Structural optimization, no garbage, is definitely more complicated than regular vacuum running from cron.
Oracle DBA (DB adminstrator
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_ec394cc017d1815a8cce7cc
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 hig
necessary to adjust database performance(4). database performance AdjustmentAdjust the performance if necessary(5) propose the next space management planBased on weekly monitoring, this paper proposes an improvement method for space management.
Routine Oracle DBA managementObjective: This document provides detailed information about one or more ORACLE databases
Most of the time, after installing Oracle10g, you can log on to the Windows Authentication Window popped up by kcsqlbi: 5560isqlplusdba. Even if you enter any account, you cannot log on.
Most of the time, after installing Oracle10g, log on to the Windows Authentication Window popped up by http: // kcsqlbi: 5560/isqlplus/dba, even if any account is entered, you cannot log on.
The solution is as follows:
1-From the command prompt, stop isqlplus:C: \>
Oracle
Oracle DBA Day-to-day management
Modified: 2000/8/23
Author: Thomas B. cox,with Christine Choi
Objective: This document has very detailed information on one or more Oracle databases per day, monthly,
The results of the yearly running status and the results of the check, in the appendix of the document you will s
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
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
Mainly for Oracle DBA in the growth stage of the positioning, learning methods and other aspects of the classic discussion, the details please refer to the following.First, positioningOracle is divided into two chunks, one for development and one for management. Development is mainly about writing stored procedures, triggers and so on, and using Oracle's develop tool as a form. A bit similar to the programm
Recovery24.2 cold and recovery in non-archive modeSteps to 24.2.1 ColdRecovery of 24.2.2 Cold prepared24.2.3 Missing Redo log File recovery method24.3 Archive mode and non-archive mode24.3.1 Setting the archive mode of the database24.3.2 Setting the archive process parameters24.3.3 Managing archive files and archive directories24.4 steps to manually hot-standby a database24.5 How to deal with database crashes during hot standby24.6 Principle of hot preparation24.7 Backup Control files24.8 Princ
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 u
xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">rdf:about="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:identifier="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:title="DBA的职责和任务(转自oracle中文技术论坛)"trackback:ping="http://www.blogjava.net/cymao/services/trackbacks/38289.aspx" />-->
It is from the
One: Multitenant Architecture (12.1.0.1)Multi-tenant architecture is the new heavyweight feature of Oracle 12c (12.1), built-in multi-tenancy (multi-tenancy), a container database (container) that can hold multiple pluggable Databases, Each pluggable database is independent of the other pluggable database.For external applications and developers, pluggable databases looks like a single database before the normal 12.1 version. The
, the hope from the system construction and the professional quality of engineers to start, to prevent the DBA of this random dangerous operation.But, after all, the management system is "soft", the hope rests on the engineer consciously abide by the system and "self-cultivation" on, and can not guarantee foolproof.The security components provided by Oracle can be used to limit, block, and prevent such rand
Tags: Oracle Video Tutorials Oracle Tutorial Oracle Database teach Oracle Getting Started learning Oracle Learning GuideOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the
-level recovery with flashback. Things are destined to be together, in front of the unlucky egg rocky, the telephone rang. The phone is from the finance department, meaning that because of the mistake, he changed the financial software to the salary scale of a salary increase of a wrong number, you find that your monthly salary has become million (jokes). In fact, everyone is so expected! It needs you to save his mistakes! Using flashback can also help you solve problems quickly.8. Be a good hab
The following articles mainly introduce the example of Oracle Database DBA interview questions. This article describes the basic mode of Oracle Database DBA interview questions in a one-Answer manner, the following is an introduction to the related interview questions. I hope you will get some benefits.
1. Explain the
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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.