Database systems administration week 1
- 1. Introduction
- 2. Course Objectives ï‚´After completing this course, you should be able to do the following: ï‚´ Identify various components of the Oracle architecture ï‚´ Start up and shut down an Oracle database ï‚´ Create an operational database ï‚´ Manage Oracle control files, redo log files, datafiles, tablespaces, segments, extents, and blocks ï‚´ Manage users, privileges, and resources ï‚´ Use Globalization Support features
- 3. Oracle9i Enterprise Edition Partitioning Oracle Enterprise Manager Packs Advanced Security Real Application Clusters
- 4. Tasks of a Database Administrator ï‚´ To plan and create databases ï‚´ To manage database availability ï‚´ To manage physical and logical structures ï‚´ To manage storage based on design ï‚´ To manage security ï‚´ Network administration ï‚´ Backup and recovery ï‚´ Database tuning
Editor's Notes
- #3: Scope of the Course This course is the first in a series of courses that cover the core database administrator tasks. The tasks covered in this course are: Outlining the Oracle architecture Planning and creating databases Managing the memory, process, physical, and logical structures Managing database users by controlling and monitoring their actions Using the Globalization Support features
- #4: What is the Oracle9i Enterprise Edition? Oracle9i Enterprise Edition is an object-relational database that is scalable and easily manageable. The administration of the basic enterprise edition is discussed in this course. However, the following options provide additional functionality. Partitioning: Provides facilities for implementing large, scalable applications. Enables control over tables and indexes at a lower level of granularity than is possible with the basic enterprise edition Real Application Clusters: Improves the scalability and availability of a database by allowing multiple copies of the Oracle software to access a single database Oracle Enterprise Manager Packs: Built on top of the Oracle Enterprise Manager. Oracle Enterprise Manager Diagnostics, Tuning, and Change Management Packs are add-ons that provide DBAs with a set of tools for advanced diagnostics, monitoring, tuning, and change management of Oracle environments. Advanced Security: Provides client–server, server–server network security using encryption and data integrity checking, and supports enhanced user authentication services, using third-party security services. Note: Options do require a license to be purchased.
- #5: Tasks of a Database Administrator Database administrators are responsible for maintaining the Oracle server so that the server can process user requests. An understanding of the Oracle architecture is necessary to maintain it effectively. This course will be focusing on outlining the Oracle architecture, and other administrator tasks such as: planning and creating databases, managing database availability, managing memory, physical and logical structures, and managing users and privileges. Database administrator tasks covered in other courses: The following tasks are discussed in other courses: Backup and recovery in Oracle9i Database Administration Fundamentals II Network administration in Oracle9i Database Administration Fundamentals II Database tuning in Oracle9i Database Performance Tuning