OCA Oracle Database 11g Database Administration I [[electronic resource] ] : A Real-World Certification Guide

• Record Nr.: UNINA9910792068503321
• Autore: Ries Steve
• Pubbl/distr/stampa: Birmingham, : Packt Publishing, 2013
• ISBN: 1-299-26152-3; 1-84968-731-5
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (582 p.)
• Disciplina: 005.7565; 005.7575
• Soggetti: Electronic data processing personnel -- Certification -- Study guides; Oracle (Computer file) -- Examinations -- Study guides; Engineering & Applied Sciences; Computer Science
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Description based upon print version of record.
• Nota di contenuto: 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
• Sommario/riassunto: 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 an Oracle DBA, pass the Oracle Database Administration I exam, and use those skills in the real world to manage secure, high performance, and highly available Oracle databases.