OCA Oracle Database 11g Database Administration I A Real-World Certification Guide
Developed as a practical book, ""Oracle Database 11g Administration I Certification Guide"" will show you all you need to know to effectively excel at being an Oracle DBA, for both examinations and the real world. This book is for anyone who needs the essential skills to become a...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing
2013.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627964806719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; Foreword; About the Author; About the Reviewer; www.packtpub.com; Table of Contents; Preface; Chapter 1: Introducing the Oracle Relational Database System; Understanding the RDBMS; The importance of databases; Flat file databases; Limitations of the flat file paradigm; A new paradigm; Introducing the Oracle product family; Exploring the history of Oracle; Understanding the Oracle Database product; Understanding the different editions of Oracle Database; Understanding Oracle Database options; Examining the Oracle product family
- Understanding Oracle's hardware solutionsExamining Oracle virtualization solutions; Exploring Oracle operating systems; Examining Oracle Application Servers; Interpreting Oracle Database versioning; Understanding the role of the DBA; Examining the tools of the Oracle DBA; SQL*Plus; Oracle Enterprise Manager; TOAD; DBArtisan; Oracle SQL Developer; Introducing the Companylink database; Summary; Test your knowledge; Chapter 2: Installing the Oracle Database Software; Planning an Oracle installation; Understanding Oracle installation concepts; Acquiring the Oracle software
- Reviewing the installation prerequisitesReviewing hardware prerequisites for an installation; Meeting the minimum hardware requirements for an installation; Reviewing software prerequisites for an installation; Using the Oracle Universal Installer; Understanding how OUI works; Completing final preparations to install the Oracle software; Creating Oracle user accounts and groups; Establishing Oracle directory structures; Understanding the Optimal Flexible Architecture; Using environment variables in Oracle; Installing the Oracle Database software; Running the Oracle Universal Installer
- Examining the installationUnderstanding the de-installation process - advanced topic; Summary; Test your knowledge; Chapter 3: Creating the Oracle Database; Planning for a database creation; Understanding the memory requirements of a database; Understanding the disk requirements of a database; Running the Network Configuration Assistant; Creating an Oracle database using DBCA; Introducing the Database Configuration Assistant; Examining a manual database creation; Examining Windows Services in Oracle; Certification objectives covered; Summary; Test your knowledge
- Chapter 4: Examining the Oracle ArchitectureUnderstanding the Oracle RDBMS; Distinguishing between an instance and a database; Examining the Oracle instance; Recognizing the primary Oracle processes; PMON - the Process Monitor; SMON - the System Monitor; DBWn - the Database Writer process; CKPT - the Checkpoint process; LGWR - the Log Writer process; ARCn - the Archiver process; Recognizing the secondary Oracle processes; MMON - the Manageability Monitor; MMAN - Memory Manager; RECO - the Recoverer process; Recognizing other database processes; Identifying Oracle's memory caches
- Understanding the SGA
