oracle dba handbook

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/

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

-server-11gr2-preinstall-1.0-7.el6.x86_64.rpm RPM Check and install: # Cat/etc/redhat-release # Uname-r # Rpm-qa | grep glibc # yum Install glibc # yum Install glibc.i686 Binutils-2.20.51.0.2-5.11.el6 (x86_64) Compat-libcap1-1.10-1 (x86_64) Compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 Gcc-4.4.4-13.el6 (x86_64) Gcc-c++-4.4.4-13.el6 (x86_64) Glibc-2.12-1.7.el6 (i686) Glibc-2.12-1.7.el6 (x86_64) Glibc-devel-2.12-1.7.el6 (x86_64) glibc-devel-2.1

: grant execute on dbms_rls to user1; Policy_name can be customized. ENABLE_POLICY () is used to enable or disable a vpd policy, but only one vpd policy on a table can be enabled or disabled at a time, to enable/disable the vpd policy for all tables at one time, you can follow the preceding procedure .) And set context: Then we query the vpdsample_clothing table, and only the clothing information with ID 10002 is returned. Similar to vpdsample_books, only the book information with ID 10005 is re

Tags: Wind brother Oracle Oracle Training Oracle Database tutorial Oracle video wind Brother Oracle TutorialsBecause it is a "top secret leaked" information, to prevent the investigation, the need for the small partners to quickly download the attached courseware document.Be

Oracle Oracle DAB two day crash course The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and include step-by-step instructions. To view the information for this course

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 th

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

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

to define how the extents are managed when you create a temporary table space. Modifying a temporary table space Modifying a temporary tablespace mainly has the following actions: Add temporary files To modify the size of a temporary file Modify the status of a temporary file Add temporary files Alter tablespace temp0304 Add ' F:\SQL\tempfile0306.dbf ' size 10m; Modify temporary file size Alter Database tempfile ' F:\SQL\tempfile0306.dbf ' resize 20m; You can also mo

Why is it so difficult to find a good Oracle DBA? This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from ORACLE training courses go? Tom is a database administrator with An OCP license and a certain understanding of the database architecture and operat

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

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 h

tuning rules that every Oracle DBA should follow Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most effective ways to do this is through

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

Oracle users have relatively large permissions. Therefore, you may need to use non-oracle users to manage related databases. In particular, it is necessary for multiple individuals to add different users to the system or database, and then add these users to the dba group. These users can also set different environment variables based on their preferences. This a

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 th

After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle. Two isqlplus websites are available. After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle, including two isqlplus websites. This is becaus

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