Documents

D50102GC20_sg2.pdf

Categories
Published
of 498
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Related Documents
Share
Description
Oracle Database 11g: Administration Workshop I Student Guide ã Volume II D50102GC20 Edition 2.0 March 2013 D62542 A n d r e s J u l i a n S a e n z L a n d a z a b a l ( a n d r e s j ฺ s a e n z l @ u n i l i b r e b o g ฺ e d u ฺ c o ) h a s a n o n - t r a n s f e r a b l e l i c e n s e t o u s e t h i s S t u d e n t G u i d e ฺ U n a u t h o r i z e d r e p r o d u c t i o n o r d i s t r i b u t i o n p r o h i b i t e d ฺ C o p y r i g h t © 2 0 1 3 ,
Transcript
  Oracle Database 11 g  : Administration Workshop I Student Guide ã Volume II D50102GC20Edition 2.0March 2013D62542  Copyright ©2009, 2013,Oracle and/or it affiliates. All rights reserved.Disclaimer  This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes fair use under copyright law, you may not use, share, download, upload, copy, print, display, perform,reproduce, publish, license, post, transmit, or distribute this document in whole orin part without the express authorization of Oracle.The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writingto: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights Notice If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, thefollowing notice is applicable: U.S. GOVERNMENT RIGHTSThe U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms ofthe applicable Oracle license agreement and/or the applicable U.S. Government contract. Trademark Notice Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Authors Deirdre Matishak Mark Fuller Technical Contributors and Reviewers Maria BillingsHerbert BradburyYanti ChangTimothy ChienAndy Fotunak Gerlinde FrenzenSteve FriedbergJoel GoodmanVimala JacobDominique JeunotPete JonesFukue KawabeDonna KeeslingSean KimAchiel LangersGwen LazenbyEssi ParastRandy RichesonJoe RochHilda SimonIra Singer Jim Spiller Supithran ThananayagamBranislav ValnyManju Varrier  Editors Raj Kumar Daniel Milne Graphic Designer Rajiv Chandrabhanu Publishers Jobi VargheseVeena Narasimhan    iii Contents I Introduction Course Objectives I-2 Suggested Schedule I-3 Oracle Products and Services I-4 Oracle Database 11 g  : “ g  ” Stands for Grid I-5 Grid Infrastructure for Single-Instance I-7 1 Exploring the Oracle Database Architecture Objectives 1-2 Oracle Database 1-3 Connecting to a Server 1-4 Oracle Database Server Architecture: Overview 1-6 Instance: Database Configurations 1-7 Connecting to the Database Instance 1-8 Oracle Database Memory Structures 1-9 Shared Pool 1-11 Database Buffer Cache 1-13 Redo Log Buffer 1-14 Large Pool 1-15 Java Pool and Streams Pool 1-16 Program Global Area (PGA) 1-17 Quiz 1-18 Process Architecture 1-20 Process Structures 1-21 Database Writer Process (DBWn) 1-23 Log Writer Process (LGWR) 1-25 Checkpoint Process (CKPT) 1-27 System Monitor Process (SMON) 1-28 Process Monitor Process (PMON) 1-29 Recoverer Process 1-30  Archiver Processes (ARC n ) 1-31 Process Startup Sequence 1-32 Database Storage Architecture 1-33 Logical and Physical Database Structures 1-35    iv Segments, Extents, and Blocks 1-37 Tablespaces and Data Files 1-38 SYSTEM  and SYSAUX  Tablespaces 1-39  Automatic Storage Management 1-40  ASM Storage Components 1-41 Interacting with an Oracle Database: Memory, Processes and Storage 1-42 Quiz 1-44 Summary 1-46 Practice 1: Overview 1-47 2 Installing your Oracle Software Objectives 2-2 Tasks of an Oracle Database Administrator 2-3 Tools for Administering an Oracle Database 2-4 Planning Your Installation 2-6 Oracle Grid Infrastructure and Oracle Database Installation: System Requirements 2-8 Preparing the Operating System 2-9 Setting Environment Variables 2-10 Checking the System Requirements 2-11 Oracle Universal Installer (OUI) 2-12 Example: Installation Scenario 2-13 Part One: Installing the Oracle Grid Infrastructure for Standalone Server 2-14 Selecting Product Languages 2-15 Creating an ASM Disk Group 2-16 Defining ASM Passwords 2-17 Defining Privileged Operating System Groups 2-18 Specifying Installation Location 2-19 Creating Inventory 2-20 Performing Prerequisite Checks 2-21 Verifying Installation Summary Data 2-22 Monitoring Installation Progress 2-23 Executing root  Configuration Scripts 2-24 Executing Configuration Assistants 2-25 Finishing Installation 2-26 Configuring the FRA Disk Group 2-27 Quiz 2-28 Part Two: Installing the Oracle Database Software 2-30 Choosing the Type of Installation 2-31 Choosing Grid Installation Options 2-32 Choosing Language Settings 2-33
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks