OCA Oracle Database 11g Database Administration I : A Real-World Certification Guide

Format:

Book

Author/Creator:

Ries, Steve.

Language:

English

Subjects (All):

Oracle (Computer file).

Electronic data processing personnel--Certification--Study guides.

Oracle (Computer file)--Examinations--Study guides.

Local Subjects:

Electronic data processing personnel--Certification--Study guides.

Oracle (Computer file)--Examinations--Study guides.

Physical Description:

1 online resource (582 p.)

Edition:

1st edition

Other Title:

Oracle Database 11g

Oracle Certified Associate Oracle Database 11g

Place of Publication:

Birmingham : Packt Publishing, 2013.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

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

Notes:

Description based upon print version of record.

ISBN:

9781299261525

1299261523

9781849687317

1849687315

OCLC:

830162786