book

OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition

Name: OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition
Author: John Watson
ISBN: 9780071831277

by John Watson

May 2014

Intermediate to advanced

768 pages

16h 3m

English

McGraw Hill Computing

Read now

Unlock full access

Cover
About the Authors
About the Technical Editor
Title Page
Copyright Page
Contents at a Glance
Contents
Preface
Introduction
1. Installing Oracle Database Software
Plan for an Oracle Database Software InstallationSupported PlatformsObtain the Oracle Database SoftwareUser AccountsDisk Space and DirectoriesThe Prerequisite ChecksInstall the Oracle Database SoftwareThe OUI InventoryThe OUI Dialog: Interactive InstallSilent Install and Response FilesWindows and Linux VariationsExercise 1-1: Install the Oracle Database SoftwareTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
2. Creating an Oracle Database Using DBCA
Create a Database by Using the Database Configuration Assistant (DBCA)The Instance, the Database, and the Data DictionaryUsing the DBCA to Create a DatabaseThe DBCA DialogExercise 2-1: Create a Database with DBCAGenerate Database Creation Scripts by Using DBCAGenerating the ScriptsThe Creation ScriptsThe Initialization Parameter FileExercise 2-2: Generate Database Creation Scripts by Using DBCAManage Database Design Templates by Using DBCAExercise 2-3: Manage Database Design Templates by Using DBCAConfigure Database Options by Using DBCAExercise 2-4: Configure Database Options by Using DBCATwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer

3. Exploring the Oracle Database Architecture
List the Architectural Components of an Oracle DatabaseSingle-Instance Database ArchitectureDistributed Systems ArchitecturesExercise 3-1: Identify the Components of the Database ServerExplain the Memory StructuresThe Database Buffer CacheThe Log BufferThe Shared PoolThe Large PoolThe Java PoolThe Streams PoolExercise 3-2: Investigate the Memory Structures of the InstanceDescribe the Background ProcessesSMON, the System MonitorPMON, the Process MonitorDBWn, the Database WriterLGWR, the Log WriterCKPT, the Checkpoint ProcessMMON, the Manageability MonitorMMNL, the Manageability Monitor LightMMAN, the Memory ManagerLREG, the Listener Registration ProcessARCn, the ArchiverRECO, the Recoverer ProcessSome Other Background ProcessesExercise 3-3: Investigate the Processes Running in Your InstanceExplain the Relationship Between Logical and Physical Storage StructuresThe Physical Database StructuresThe Logical Database StructuresThe Data DictionaryExercise 3-4: Investigate the Storage Structures in Your DatabaseTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
4. Managing the Database Instance
Use Database Management ToolsWorking with SQL*PlusLog On as a Normal or Privileged UserWorking with Database ExpressWorking with SQL DeveloperExercise 4-1: Use Database Management ToolsUnderstand Initialization Parameter FilesStatic and Dynamic Parameter FilesStatic and Dynamic Parameters and the Initialization Parameter FileThe Basic ParametersChanging ParametersExercise 4-2: Query and Set Initialization ParametersStart Up and Shut Down an Oracle Database InstanceStarting the Database ListenerDatabase Startup and ShutdownExercise 4-3: Start Up and Shut Down an Oracle Database InstanceView the Alert Log and Access Dynamic Performance ViewsThe Alert LogThe DDL LogThe Dynamic Performance ViewsExercise 4-4: Use the Alert Log and Dynamic Performance ViewsTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
5. Configuring the Oracle Network Environment
Configure Oracle Net ServicesOracle Net and the Client-Server ParadigmEstablishing a SessionCreating a Database ListenerDynamic Service RegistrationShared ServerUse Tools for Configuring and Managing the Oracle NetworkThe Net ManagerThe Net Configuration AssistantThe Listener Control UtilityThe TNS_ADMIN Environment VariableConfigure Client-Side NetworkEasy Connect Name ResolutionLocal Naming Name ResolutionDirectory Naming and External NamingTesting Oracle Net ConnectivityExercise 5-1: Configure Oracle NetUnderstand Database Resident Connection PoolingConfigure Communication Between DatabasesExercise 5-2: Create and Use a Database LinkTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
6. Managing Database Storage Structures
Describe the Storage of Table Row Data in BlocksThe Oracle Data Storage ModelSegments, Extents, Blocks, and RowsExercise 6-1: Investigate Storage StructuresCreate and Manage TablespacesTablespace CreationExercise 6-2: Create, Alter, and Drop TablespacesAltering TablespacesDropping TablespacesExtent ManagementSegment Space ManagementOracle Managed Files (OMF)Exercise 6-3: Change Tablespace CharacteristicsTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
7. Managing Space
Explain How Oracle Database Server Automatically Manages SpaceExtent ManagementExercise 7-1: Segment Space ManagementAutomatic Segment Space Management (ASSM)Save Space by Using CompressionExercise 7-2: Investigate CompressionProactively Monitor and Manage Tablespace Space UsageUse the Segment AdvisorReclaim Wasted Space from Tables and Indexes by Using the Segment Shrink FunctionalityManage Resumable Space AllocationExercise 7-3: Use Resumable Space AllocationTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
8. Administering User Security
Create and Manage Database User AccountsUser Account AttributesAuthentication MethodsCreating AccountsExercise 8-1: Create UsersGrant and Revoke PrivilegesSystem PrivilegesObject PrivilegesExercise 8-2: Grant Direct PrivilegesCreate and Manage RolesCreating and Granting RolesPredefined RolesEnabling RolesPrivilege AnalysisExercise 8-3: Create and Grant RolesCreate and Manage ProfilesPassword Profile LimitsCreating and Assigning ProfilesExercise 8-4: Create and Use ProfilesTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
9. Managing Undo Data
Explain DML and Undo Data GenerationDatabase TransactionsUndo GenerationExecuting SQL StatementsHow Transactions Use Undo SegmentsExercise 9-1: Use Undo DataMonitor and Administer Undo DataError Conditions Related to UndoParameters for Undo ManagementSizing and Monitoring the Undo TablespaceTemporary UndoCreating and Managing Undo TablespacesExercise 9-2: Work with Undo TablespacesDescribe the Difference Between Undo Data and Redo DataConfigure Undo RetentionConfiguring Undo Retention to Support Long-Running QueriesFlashback Query and Undo RetentionExercise 9-3: Work with Transactions and Flashback QueryTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
10. Managing Data Concurrency
Describe the Locking Mechanism and How Oracle Manages Data ConcurrencyShared and Exclusive LocksThe Enqueue MechanismAutomatic and Manual LockingMonitor and Resolve Locking ConflictsThe Causes of Lock ContentionDetecting Lock ContentionSolving Lock ContentionDeadlocks: A Special CaseExercise 10-1: Monitor and Resolve Locking ConflictsTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
11. Implementing Oracle Database Auditing
Explain DBA Responsibilities for Security and AuditingReasons for AuditAuditing TechniquesEnable Standard Database Auditing and Unified AuditingEnable Standard AuditingEnable Unified AuditingExercise 11-1: Use Unified AuditingTwo-Minute DrillQ&A Self TestSelf Test Answers
12. Performing Database Maintenance
Manage the Automatic Workload Repository (AWR)Gathering AWR StatisticsManaging the AWRExercise 12-1: Monitor the Automatic Workload RepositoryUse the Automatic Database Diagnostic Monitor (ADDM)Exercise 12-2: Generate an ADDM ReportDescribe and Use the Advisory FrameworkThe Memory AdvisorsThe SQL AdvisorsThe Automatic Undo AdvisorThe Mean Time to Recover (MTTR) AdvisorThe Data Recovery AdvisorThe Segment AdvisorThe SQL Repair AdvisorSet Alert ThresholdsAlert Condition Monitoring and NotificationsSetting ThresholdsExercise 12-3: Configure AlertsUse Automated TasksThe AutotasksControlling the AutotasksTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
13. Managing Performance
Use Enterprise Manager to Monitor PerformanceA Performance Tuning MethodologyPerformance Monitoring DataThe Database Express Performance PagesExercise 13-1: Use Enterprise Manager to Monitor ActivityUse Automatic Memory ManagementPGA Memory ManagementSGA Memory ManagementAutomatic Memory ManagementExercise 13-2: Set the Memory Management ParametersUse the Memory Advisor to Size Memory BuffersExercise 13-3: Use the Memory AdvisorsTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
14. Managing Performance: SQL Tuning
Manage Optimizer StatisticsObject StatisticsHow the Optimizer Uses StatisticsGathering Statistics ManuallyExercise 14-1: Gather Optimizer StatisticsUse the SQL Tuning AdvisorThe Capabilities of the SQL Tuning AdvisorThe SQL Tuning Advisor API: The DBMS_SQLTUNE PackageExercise 14-2: Run the SQL Tuning Advisor for a SQL StatementUse the SQL Access Advisor to Tune WorkloadThe Capabilities of the SQL Access AdvisorUsing the SQL Access Advisor with DBMS_ADVISORTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
15. Managing Resources Using Database Resource Manager
Configure the Database Resource ManagerThe Need for Resource ManagementThe Resource Manager ArchitectureResource Manager ConfigurationAccess and Create Resource PlansCPU MethodUse of the Ratio CPU MethodThe Active Session Pool MethodLimiting the Degree of ParallelismControlling Jobs by Execution TimeTerminating Sessions by Idle TimeRestricting Generation of Undo DataExercise 15-1: Create and Implement a Resource Manager PlanMonitor the Resource ManagerExercise 15-2: Test and Monitor a Resource Manager PlanTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
16. Automating Tasks by Using Oracle Scheduler
Use Oracle Scheduler to Simplify Management TasksThe Scheduler ArchitectureScheduler ObjectsExercise 16-1: Creating a Job with the Scheduler APIUse Job Chains to Perform a Series of Related TasksUse Scheduler Jobs on Remote SystemsUse Advanced Scheduler Features to Prioritize JobsUsing Job ClassesUsing WindowsExercise 16-2: Use Scheduler Windows to Control the Resource ManagerTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
17. Moving Data
Describe Ways to Move DataCreate and Use Directory ObjectsUse SQL*Loader to Load Data from a Non-Oracle DatabaseUsing SQL*LoaderSQL*Loader Express ModeUse External Tables to Move Data via Platform-Independent FilesExercise 17-1: Use Directories, SQL*Loader, and External TablesExplain the General Architecture of Oracle Data PumpUse Data Pump Export and Import to Move Data between Oracle DatabasesCapabilitiesUsing Data Pump with the Command-Line UtilitiesTablespace Export and ImportExercise 17-2: Use Data Pump Export/ImportTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
18. Backup and Recovery: Concepts and Configuration
Identify the Importance of Checkpoints, Redo Logfiles, and Archive LogfilesInstance RecoveryThe Impossibility of Database CorruptionCheckpointingProtecting the Online Redo LogfilesArchivelog Mode and the Archiver Process(es)Backup and Recovery: ConfigurationExercise 18-1: Investigate and Adjust the Redo Log ConfigurationConfigure the Fast Recovery AreaConfigure Archivelog ModeExercise 18-2: Enable Archivelog ModeTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
19. Backup and Recovery Operations
Create Consistent Database BackupsExercise 19-1: Consistent Server-Managed BackupBack Up Your Database Without Shutting It DownExercise 19-2: Perform Server-Managed Open BackupsCreate Incremental BackupsAutomate Database BackupsManage BackupsThe RMAN RepositoryReports on BackupsAdministering BackupsDetermine the Need for Performing RecoveryUse Recovery Manager (RMAN) and the Data Recovery Advisor to Perform Recovery of the Controlfile, Redo Logfile, and DatafileThe Health Monitor and the ADRUsing the DRAExercise 19-3: Use the DRA to Diagnose and Repair a ProblemTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
20. Installing Oracle Grid Infrastructure for a Standalone Server
Configure Storage for Oracle Automatic Storage Management (ASM)GI ArchitectureASM ArchitectureASM DisksCreating ASM DisksInstall Oracle Grid Infrastructure for a Standalone ServerExercise 20-1: Install Grid InfrastructureTwo-Minute DrillQ&A Self TestLab ExerciseSelf Test AnswersLab Answer
21. Using Oracle Restart
Use Oracle Restart to Manage ComponentsAdministering the Oracle Restart ProcessesAdministering Registered ResourcesThe Restart CapabilityExercise 21-1: Configure a Database for Oracle RestartTwo-Minute DrillQ&A Self TestLab ExerciseSelf Test AnswersLab Answer
22. Upgrading Oracle Database Software and Migrating Data
Describe Upgrade MethodsSoftware UpgradeDatabase Upgrade: DBUA or ManualDescribe Data Migration MethodsDescribe the Upgrade ProcessMigrating Data by Using Oracle Data PumpExercise 22-1: Perform a Data Pump Full Database MigrationTwo-Minute DrillQ&A Self TestSelf Test Answers
23. Database Upgrade: Preparation, Upgrading, and Post-Upgrade Tasks
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle DatabaseOracle Label Security and Oracle Data VaultOracle Warehouse BuilderUse the Pre-Upgrade Information Tool Before Performing an UpgradePrepare the New Oracle Home Prior to Performing an UpgradeUpgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant (DBUA)Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and ToolsMigrate to Unified AuditingPerform Post-Upgrade TasksExercise 23-1: Simulate Some Upgrade TasksTwo-Minute DrillQ&A Self TestLab QuestionSelf Test AnswersLab Answer
A. About the Download
System RequirementsInstalling and Running Total TesterAbout Total TesterTechnical Support
Glossary
Index

Content preview from OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition

CERTIFICATION OBJECTIVES

4.01 Use Database Management Tools

4.02 Understand Initialization Parameter Files

4.03 Start Up and Shut Down an Oracle Database Instance

4.04 View the Alert Log and Access Dynamic Performance Views

Two-Minute Drill

Q&A Self-Test

After creating a database and an instance, the instance will be started and the database will be open. Assuming that the database was configured with Enterprise Manager Database Express, it will be available as a management tool. What may not be running is the database listener (which ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063), 3rd Edition

Publisher Resources

ISBN: 9780071829236

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition

by John Watson

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.