Oracle Database System Structure and Management
Course main line
Oracle9i database architecture Oracle9i instance, database, physical storage structure management Oracle9i security, user resource restriction, user and auditing management
Course features
Easy to learn. The course content clearly gives the main line of Oracle system management. Do it. All parts of the course are equipped with experiments. practical. The curriculum reflects the content of the actual management of Oracle databases, and the students can use the course content in the actual database management work. It is equipped with first-class textbooks that reflect the latest technology and management ideas of Oracle.
Course Target: Make students become a real Oracle database administrator
Course textbook (five)
Oracle Database Arrange Oracle Database Management Oracle User, User Resource Limit, Audit Management Oracle9i Features, Installation Configuration and New Features Oracle9i System Management Practice Manual
Part 1: Oracle architecture
Oracle Relationship Database Management System
1. What is the relational database (RDBMS) 3. Database Subtocate in size and use 4. The core task of the relational database management system 5. Architecture of Database Database 6.Oracle Disk Resource Structure 7. Oracle Using Memory and CPU: Oracle Server Example Structure System Global Region SGA (SYSTEM GLOBAL AREA) Program Hide area (PGA) Oracle Background Process User How to Connect to Server Process Oracle Process Oracle Process Oracle Process Oracle Synthics Oracle Submit Transaction (Commits) Working Process 8 Database Object Type and Some Basic Concepts 9. Tools Tools for Oracle Databases End User User Tools SQL * Plus SQL * Plus in the Window Environment SQL * Plus Performs Standard SQL Command Perform PL / SQL Block executes the SQL * Plus command to get information about the execution command to get information about the definition, get error information Using Oracle Management Oracle Server Manager Row Mode Oracle Enterprise Manager Management Tool Using Oracle OEM Performance Monitoring (TUNING) other tools package Performance Manager TopSessions Oracle Expert configuration tool and the like using an Oracle database using Oracle database configuration Assistant network configuration tool Net8 Assistant software installation tools using Oracle data Universal Installer Oracle SQL * Loader Oracle tool load data into the tool unloading and re-IMP and EXP Organizational data 10. Main work of database operators
1 Install and Configure Oracle Database Software - 1: Basic Installation and Match
1. Install Oracle3 with Oracle INSTALLER 2. Install Oracle Server 4. Install Oracle Net85. Install Oracle Client Software Customer / Server Structure 6. Oracle Server How to Work Oracle Services Oracle Database Software and Data on Windows
1 Install and configure Oracle Database Software-2: Oracle Network Solution
1. Development direction of the network and problem host computing mode The growth of the Internet Calculation of the Internet Calculation Oracle Network Solution 2. The basic NET8 structure NET8 establishes the components of the server connection and the interaction between them. 3. Basic NET8 server-side configuration NET8 Assistant Configuring Listener Configuration Listening Location Configuring Database Services Configuring Other Services to Listener Naming Lstener Control Utility Lsnrctl Start Net8 Listener LsnrctL Turn off Net8 Listener Start / Turn Net8 Listener Sets multiple Listener processes in the same node Configuring the second listening process Starting the second monitor process server-side configuration file 4. Basic NET8 client configuration Host Nightnation Method to establish a NET8 client file and use local Name Method Establishing Connection with NET8 Assistant Defines the Configuration File 1 Oracle Distributed Database Configuration 1 Configure Oracle Management Server: Oracle Management Server 1 exercise
Upload test: View Oracle System Important Disk File Structure (Observation and Discussion) Positively: Connecting Database and Administrative Tools Used in Oracle Server NEW * PLUS Tool Connect to Database Entering Server Manager Tools in Oracle Server The end enters the DBA Stduio tool (optional): Install the database server software with Oracle Installer (optional): Install Oracle Client Software Press: Customer / Server Configuration Trial: Observer Oracle's service on the Window NT system: Observe the TNSNAMES.ORA file and listner.ora file test: Net8 network monitoring with Net8 Assistant
Part II: Oracle instance, database, physical storage structure management 1 Create a new database
1. Create a new database with tools Database Configuration Assistant 2. Tool Database Configuration Assistant Batch File Content 3. Manually Create an Instance and Database Prepare Operating System Prepare System Parameter File Creating Database Creating an Instance Create Database Installation Data Dictionary 4.racle with Windows Registry
1 Oracle instance management
1. Set the operating system and password verification Operation System Verification Password Verification 2. Generate Initialization Parameter File 3. Start instance and open Database 4. Turn off the database and instance 5. Get and set system parameter values 6. Management session 7. Monitoring tracking File and warning file
1 management of tablespace and data files
1. Database logic Structure 2. Creating a table space 3. Changing a variety of methods for changing tablespace Size adds new data files to increase or decrease the size of data files to allow or disable data files to automatically extend the availability of data files 4. Changing the Status of the Table Space and Storage Settings Table Space Online Table Space Offline Read Read Table Space Management Make Read Table Space Creating a Space Manage Space Manage Space Manage Space Manage Space Table Space Storage Settings Combined Free Space Delete Table space 5. Reling table space 6. Planning data files 7. Prepare the necessary tablespace
1 return segment management (8i)
1. Role and Working Mechanism of Refill Section 2. The quantity of returning segments and the size of the size of the work mechanism of the returning segment returns the number of rollback segments. The decision of the slot size is created with the appropriate storage parameters. . Maintain the rollback section Modify the rollback segment allows the returning segment to change the split segment to change the return segment storage parameters to reduce the rollback segments to remove the rollback segment offline and delete the rollback segment. The problem of problems in the paragraph is not enough, and the snapshot is too old block session that cannot make the table space containing the returning segment offline 1 management
1. Type and management of temporary sections
1 Relationship between Oracle storage structure
1. Extremely useful purpose table segments, index segments, and their useback segments, temporary sections, and their use of LOB, Cluster, and IoT (organizational index table). Location 2. Segment use panel to control 3. Block space Use free space line chain and row migration in the data block 4. Positioning according to the segment of the debris and life
1 data concurrency and consistency
1. Concurrency 2. Read the consistency read consistency, return to the segment, and the relationship between the transaction is read-only transaction 3. Lock mechanism automatically locks artificial locks 4. Set the transaction
1 Maintenance redo log file
1. On the use of online redo log files and roll back (rear) 2. Control checkpoints and log switches Set the time interval for database checkpoints to force log switch to enforce the quick checkpoint for no log switching 3. Redo The log files are multi-and maintenance Create online heavy log groups and members renamed or locate online redo log members to remove online redo log groups and members 4. Plan online redo log files 5. Frequent online redo log files exclude
1 Maintenance control file
1. Control file application 2. Configuring content 3. Get control file information 4. Using multiple control files 5. Create control files
1 exercise
Upload test: Create a database with the Database Configuration Assistant tool: Manually create database XTDB test: WINDOWS NT operating system Verification Plead test: Start and close the listener (Listener) Trial: Start with server manager Instance and open database board test: Manually create new tablespace / modification tablespace properties to top the machine test: Create and modify the tablespace attribute in the OEM environment: check the table space usage, manually created new Rollback segment / modified returning segment attribute is on the machine test: Create and modify the split segment attribute in the OEM environment: Create a user and assign a temporal table space test: Data storage in the OEM environment Method is on the machine test: manually created multiple-way log groups to test: multiple control files
Part III Oracle Security, User Resource Limit, Management of User Auditing 1 Database Safety Management
1.Oracle Database Security Model Initial Database User Database User's General Division User Authentication Database Verification External Validation Enterprise Verification 2. Create a new Database User 3. Modify and delete an existing database user Modify User Information Delete Users View User Information 4. Role Creating a Role Creating Role Modify Role Deleting Role Role Grants with Return Roles Role Roles Roal Roles Use Predefined Role Roles and User Relationships View Role Information 5. Permission Management System Privilege Object Privilege Grant and Reclaim Permission System The privilege is awarded the retrieval of the target privilege to the target privilege. 6. Safety management with Security Manager
1 Database Resource (Profile)
1. Create and assign Profile to assign Profile to create profile2. Sets Composite_LIMIT and Resource Cost3. Allow and disable resource limit 4. Modify and delete Profile5. Use profile management password 6. View users and resources related information
1 audit
