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


OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
$28.79
save 20%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
$59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Prepare for Oracle Database Administration I certification
  • Learn real world skills in database administration
  • Written in an example driven format with step-by-step real world examples

Book Details

Language : English
Paperback : 582 pages [ 235mm x 191mm ]
Release Date : February 2013
ISBN : 1849687307
ISBN 13 : 9781849687300
Author(s) : Steve Ries
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Introducing the Oracle Relational Database System
Chapter 2: Installing the Oracle Database Software
Chapter 3: Creating the Oracle Database
Chapter 4: Examining the Oracle Architecture
Chapter 5: Managing Oracle Storage Structures
Chapter 6: Managing the Oracle Instance
Chapter 7: Managing Security
Chapter 8: Managing Concurrency
Chapter 9: Configuring an Oracle Network
Chapter 10: Managing Database Performance
Chapter 11: Understanding Backup and Recovery Concepts
Chapter 12: Performing Database Backups
Chapter 13: Performing Database Recovery
Chapter 14: Migrating Data
Appendix: Preparing for the Certification Exam
Test Your Knowledge – Answers
Index
  • 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 solutions
        • Examining 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 prerequisites
        • Reviewing 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 installation
          • Understanding 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 Architecture
          • Understanding 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
              • Understanding the PGA
          • Examining the Oracle database components
            • Understanding the control file
            • Exploring the redo logfiles
            • Understanding the archived redo logs
            • Examining Oracle's core infrastructure datafiles
              • Understanding the SYSTEM tablespace
              • Understanding the SYSAUX tablespace
              • Exploring the temporary tablespace
              • Understanding the Undo tablespace
            • Understanding non-specialized datafiles
          • Exploring Oracle Real Application Clusters
          • Certification objectives covered
          • Summary
          • Test your knowledge
          • Chapter 5: Managing Oracle Storage Structures
            • Examining Oracle's physical space paradigm
              • Understanding the database block
                • Sizing the database block
                • Examining the anatomy of a database block
              • Understanding the database extent
              • Understanding the database segment
              • Understanding the database datafile
            • Managing tablespaces
              • Starting SQL Developer
              • Creating tablespaces
              • Modifying tablespaces
                • Resizing datafiles
                • Adding datafiles
                • Automatically extending datafiles
                • Managing tablespace availability
                • Dropping a tablespace
            • Using advanced tablespace management techniques
              • Using non-standard block size tablespaces
              • Understanding locally managed tablespaces
            • Using Oracle Managed Files
            • Certification objectives covered
            • Summary
            • Test your knowledge
            • Chapter 6: Managing the Oracle Instance
              • Understanding database startup and shutdown
                • Understanding the startup process
                • Controlling the startup and shutdown process
                  • Establishing a connection with SYSDBA privileges
                  • Controlling the database startup process
                  • Controlling the database shutdown process
                  • Controlling startup and shutdown on Windows platforms
              • Setting database initialization parameters
                • Understanding the PFILE and SPFILE
                • Working with the PFILE and SPFILE
              • Understanding the data dictionary
                • Exploring the Oracle base tables
              • Exploring the static data dictionary views
                • Exploring the dynamic data dictionary views
                • Querying the data dictionary views
                • Listing common data dictionary views
                  • Object-related views
                  • Administration-related views
                  • Security-related views
                  • Storage-related views
              • Understanding database diagnostic information
                • Understanding the alert log
                • Understanding the trace files
                • Understanding the Automatic Diagnostic Repository
              • Understanding the Oracle Support model
                • Using My Oracle Support
                • Patching Oracle
              • Certification objectives covered
              • Summary
              • Test your knowledge
              • Chapter 7: Managing Security
                • Understanding the fundamentals of database security
                  • Exploring the principles behind security
                • Creating and managing user accounts
                  • Creating users
                • Understanding privileges
                  • Granting system privileges
                  • Granting object privileges
                  • Removing privileges with REVOKE
                • Understanding role-based security
                  • Using system roles
                  • Managing user roles
                  • Enabling roles
                • Understanding profiles
                  • Understanding password limits
                  • Using profiles to manage passwords
                  • Using profiles to manage system resources
                • Understanding key security parameters
                • Understanding auditing
                  • Exploring the audit trail
                  • Auditing database actions
                • Certification objectives covered
                • Summary
                • Test your knowledge
                • Chapter 8: Managing Concurrency
                  • Understanding the lifecycle of a transaction
                    • Examining the rules of a transaction
                    • Examining types of transactions
                  • Managing undo data
                    • Understanding undo-related parameters
                    • Managing undo tablespaces
                  • Managing serialization mechanisms
                    • Understanding Oracle's locking scheme
                    • Examining locking in action
                    • Recognizing deadlocks
                    • Understanding latches and mutexes
                  • Certification objectives covered
                  • Summary
                  • Test your knowledge
                  • Chapter 9: Configuring an Oracle Network
                    • Understanding Oracle networking concepts
                      • Exploring Oracle Net
                      • Understanding the dedicated and shared server architectures
                    • Understanding the listener
                      • Controlling the listener
                      • Understanding the networking configuration files
                    • Using Oracle name resolution
                      • Understanding Easy Connect
                      • Understanding local naming
                      • Using directory naming and external naming
                    • Understanding database registration
                      • Using static registration
                      • Using dynamic registration
                    • Using database links
                    • Certification objectives covered
                    • Summary
                    • Test your knowledge
                    • Chapter 10: Managing Database Performance
                      • Understanding object-level tuning
                        • Understanding the Oracle optimizer
                        • Gathering object statistics
                          • Gathering statistics manually
                          • Gathering statistics automatically
                        • Discovering invalid objects
                      • Managing the Automatic Workload Repository
                        • Understanding the AWR
                        • Using statistics, metrics, and baselines
                        • Generating an AWR report
                      • Understanding Oracle's Advisory Framework
                        • Understanding the Automatic Database Diagnostic Monitor
                        • Generating an ADDM Report
                        • Using Memory Advisors
                          • Using the Buffer Pool Advisor
                          • Using the Shared Pool Advisory
                          • Using the PGA Advisor
                        • Understanding the Alert Framework
                      • Understanding Oracle Memory Management
                        • Using Manual Memory Management
                        • Using Automatic Shared Memory Management
                        • Using Automatic Memory Management
                      • Certification objectives covered
                      • Summary
                      • Test your knowledge
                      • Chapter 11: Understanding Backup and Recovery Concepts
                        • Understanding the redo-based architecture
                          • Adding redo log members
                          • Adding a redo log group
                          • Exploring ARCHIVELOG mode
                          • Converting to an ARCHIVELOG mode
                        • Understanding Flash Recovery Area
                          • Configuring the Flash Recovery Area
                        • Understanding instance recovery
                        • Understanding the categories of database failure
                          • Addressing statement failures
                          • Addressing user errors
                          • Addressing user process errors
                          • Addressing media failure
                          • Understanding RAID
                            • RAID 0
                            • RAID 1
                            • RAID 10
                            • RAID 5
                          • Understanding file-level media failure
                        • Introducing the Data Recovery Advisor
                        • Certification objectives covered
                        • Summary
                        • Test your knowledge
                        • Chapter 12: Performing Database Backups
                          • Creating user-managed backups
                            • Creating user-managed cold backups
                            • Creating user-managed hot backups
                          • Understanding Oracle Recovery Manager
                            • Introducing RMAN
                            • Understanding the RMAN architecture
                          • Performing RMAN offline backups
                            • Performing a tablespace-level RMAN backup
                            • Performing a full backup
                            • Performing compressed backups
                            • Backing up image copies
                          • Performing RMAN hot backups
                            • Performing full hot backups
                            • Creating incremental backups
                          • Performing backup maintenance activities
                            • Understanding RMAN Parameters
                            • Using the LIST command in RMAN
                            • Using the REPORT command in RMAN
                            • Checking files using CROSSCHECK
                            • Monitoring the Flash Recovery Area with Enterprise Manager
                          • Automating database backups
                            • Automating Backups With Scripting
                            • Automating backups using Enterprise Manager
                          • Certification objectives covered
                          • Summary
                          • Test your knowledge
                          • Chapter 13: Performing Database Recovery
                            • Understanding the recovery process
                              • Understanding the importance of database recovery
                              • Understanding the different types of recovery
                            • Performing RMAN complete recoveries
                              • Performing datafile-level RMAN complete recovery
                              • Performing complete recovery of the database
                            • Performing incomplete recoveries
                              • Understanding incomplete recovery
                              • Performing a time-based incomplete recovery
                            • Using the Data Recovery Advisor
                              • Performing recovery using the DRA command-line interface
                              • Performing recovery using the DRA with Enterprise Manager
                            • Certification objectives covered
                            • Summary
                            • Test your knowledge
                            • Chapter 14: Migrating Data
                              • Understanding external data access
                                • Creating directory objects
                                • Creating external tables
                              • Loading data with SQL*Loader
                                • Understanding the key command files used by SQL*Loader
                                  • Understanding SQL*Loader's load paths
                                  • Understanding the input data file
                                  • Constructing a parameter file
                                  • Constructing a control file
                                • Running a SQL*Loader job
                              • Migrating data with Oracle Data Pump
                                • Understanding the architecture of Data Pump
                                • Exporting data Using Data Pump
                                • Importing data using Data Pump
                                • Using Data Pump with NETWORK_LINK
                              • Certification objectives covered
                              • Summary
                              • Test your knowledge

                                Steve Ries

                                Steve Ries has been an Oracle DBA for 16 years, specializing in all aspects of database administration, including security, performance tuning and backup and recovery. He is a specialist in Oracle Real Application Clusters (RAC) and has administered Oracle clustered environments in every version of Oracle since the creation of Oracle Parallel Server. Steve is the author of OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide, Packt Publishing. He holds five Oracle certifications as well as a Security+ certification. He currently consults for the Dept. of Defense, US Marine Corps, and holds a high-level security clearance. Additionally, Steve has been an adjunct instructor of Oracle technologies at Johnson County Community College for 9 years, where he teaches classes that prepare students for the Oracle certification exams. He was also a speaker at the 2011 and 2012 Oracle Open World conferences. Steve is a two-time, award-winning technical paper writer and the creator of the alt.oracle blog.
                                Sorry, we don't have any reviews for this title yet.

                                Code Downloads

                                Download the code and support files for this book.


                                Submit Errata

                                Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                                Errata

                                - 1 submitted: last submission 20 Mar 2013

                                The online chapters Online Chapter 1 and Online Chapter 2 are available as free downloads with the Code files.

                                Sample chapters

                                You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                                Frequently bought together

                                OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide +    JIRA 5.2 Essentials =
                                50% Off
                                the second eBook
                                Price for both: $51.15

                                Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                                What you will learn from this book

                                • Learn about installation of the Oracle database software package
                                • Create and configure your very own Oracle database
                                • Discover how the Oracle database architecture provides a platform for high-performance, high availability databases
                                • Learn how to manage an Oracle instance, including startup and shutdown concepts
                                • Optimise performance and perform crucial database tasks including offline, online, and incremental backups as well as data migration
                                • Learn how to restore and recover an Oracle database from media failure, including point-in-time recoveries

                                In Detail

                                Oracle Database Server is the most widely used relational database in the world today. This book gives you the essential skills to master the fundamentals of Oracle database administration and prepares you for Oracle DBA certification.

                                "OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide" prepares you to master the fundamentals of Oracle database administration using an example driven method that is easy to understand. The real world examples will prepare you to face the daily challenges of being a database administrator.

                                Starting with the essentials of why databases are important in today's information technology world and how they work, you are then guided through a full, customized installation of the Oracle software and creating your own personal database.

                                We then examine fundamental concepts of Oracle, including architecture, storage structures, security, performance tuning, networking, and instance management. Finally, we take an in-depth look at some of the most important concepts in the daily life of an Oracle DBA - backup, recovery, and data migration.

                                "OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide" provides you with the skills you need in order to become a successful Oracle DBA, both for certification and real life tasks.

                                Approach

                                Developed as a practical book, "OCA Oracle Database 11g: Database Administration I: A Real-World 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.

                                Who this book is for

                                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.

                                Code Download and Errata
                                Packt Anytime, Anywhere
                                Register Books
                                Print Upgrades
                                eBook Downloads
                                Video Support
                                Contact Us
                                Awards Voting Nominations Previous Winners
                                Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                                Resources
                                Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software