1 / 17

Chapter 1 Oracle Architecture Overview

Chapter 1 Oracle Architecture Overview. Objectives. Learn about Oracle9 i architecture and key Oracle9 i software components Look at the ORACLASS database Discover differences between Oracle9 i client and server installation options Learn how to use the Oracle Universal Installer

oleg-bowers
Download Presentation

Chapter 1 Oracle Architecture Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 1 Oracle Architecture Overview Oracle9i Database Administrator: Implementation and Administration

  2. Objectives • Learn about Oracle9i architecture and key Oracle9i software components • Look at the ORACLASS database • Discover differences between Oracle9i client and server installation options • Learn how to use the Oracle Universal Installer • Examine why to use OFA (Optimal Flexible Architecture) Oracle9i Database Administrator: Implementation and Administration

  3. Oracle9i Architecture: Key Components The core Oracle9i RDBMS software includes a suite of over 200 components. Key components are: • Oracle9i database & Oracle Net • Java/Web components • Oracle Enterprise Manager & Mgt. Packs • SQL*Plus • Utilities, Precompilers, and add-ons Oracle9i Database Administrator: Implementation and Administration

  4. Oracle9i Architecture: Running the Database The Oracle9i database server has 3 parts: • Database: data files, control files, and redo log files • Software: database executable files • Instance: background processes and memory Oracle9i Database Administrator: Implementation and Administration

  5. Oracle9i Architecture: A Typical Server Oracle9i Database Administrator: Implementation and Administration

  6. Oracle9i Architecture: Server Configurations Oracle9i Database Administrator: Implementation and Administration

  7. Oracle9i Architecture: Optional Additions Some important optional additions are: • Oracle Data Mining: queries on data warehouses • Oracle Advanced Security: industry standard security encryption and password validation • Enterprise Manager packs: additions for tuning, change management, and diagnostics Oracle9i Database Administrator: Implementation and Administration

  8. The ORACLASS Database Your workstation has: • Database instance named ORACLASS • Software: Oracle9i Enterprise Edition • Users: • SYSTEM: The default database administrator • SYS: The system manager with special capabilities • CLASSMATE: The future owner of tables you will create (this user is created at the end of Chapter 2) Oracle9i Database Administrator: Implementation and Administration

  9. Oracle9i Installation Options: N-tier Oracle9i Database Administrator: Implementation and Administration

  10. Oracle9i Installation Options: Server-side Choose from: • Enterprise Edition: best for many users and high-volume data • Standard Edition: best for small groups of users, smaller volume data • Personal Edition: best for individual use Oracle9i Database Administrator: Implementation and Administration

  11. Oracle9i Installation Options: Client-side Choose from: • Administrator: provides Enterprise Manager and other tools for remote database administration • Runtime: provides connectivity from local applications to a remote database Oracle9i Database Administrator: Implementation and Administration

  12. Oracle Universal Installer The user-friendly installation tool: • Installs any Oracle tool available to you • Capable of managing two releases of Oracle products on the same computer using Oracle Home • Able to run installations without human intervention with the Silent Install option Oracle9i Database Administrator: Implementation and Administration

  13. Optimal Flexible Architecture (OFA) Set of standards for directory structure and file names. Advantages include: • Spreading I/O across devices to reduce bottlenecks • Separating products into distinct directories and/or devices to improve performance • Providing standard names for file types to speed up administrative tasks Oracle9i Database Administrator: Implementation and Administration

  14. OFA: Directory Structure Standards ORACLE_BASE and ORACLE_HOME define the root directory structures Oracle9i Database Administrator: Implementation and Administration

  15. OFA: File Naming Standards Patterns for naming files are: • Control files: controlNN.ctl (example: control01.ctl) • Redo log files: redoNN.log (example: redo03.log) • Data files: XXXXNN.dbf (example: SYSTEM01.dbf) • NN = sequential numbers starting with 01. • XXXX = name of the tablespace Oracle9i Database Administrator: Implementation and Administration

  16. Chapter Summary • Oracle9i RDBMS software contains many basic components and even more optional add-ons • The database server contains the software, the database files, and the instance (made up of memory allocation and background processes) • Oracle Enterprise Edition is the most robust of the three installation options for the server • The ORACLASS database is installed on each student workstation Oracle9i Database Administrator: Implementation and Administration

  17. Chapter Summary • Multi-tier architecture provides greater flexibility and independence of software components • Oracle Universal Installer features an Oracle Home selector and Silent Install option • Optimal Flexible Architecture (OFA) defines standards for directory structure and file names Oracle9i Database Administrator: Implementation and Administration

More Related