Oracle Database 12c Administration

Duration: 
5 days
Codes: 
12C

Overview

This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.

Audience

At the end of this course you will be able to:

  • Describe the Oracle Clusterware architecture
  • Describe how Grid Plug and Play affects Clusterware
  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • Describe global cache coordination
  • Install the Oracle database software
  • Create a cluster database
  • Perform post-database-creation tasks
  • Convert a single-instance Oracle database to RACs
  • Explain the principles and purposes of clusters
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Configure RMAN for the RAC environment

Course Outline

Learn To:

  • Install Oracle RAC software.
  • Create cluster databases.
  • Administer both administrator and policy-managed Oracle RAC databases.
  • Monitor and address performance issues.
  • Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
  • Create and administer a RAC One Node Database.
  • Create and manage multitennant RAC databases.

Benefits to You:

  • Ensure fast, reliable, secure and easy to manage performance.
  • Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Target Audience:

  • Database Administrators
  • Administrator

Grid Infrastructure Overview and Review

  • What is a Cluster?
  • What is a Flex Cluster
  • Clusterware Characteristics
  • Oracle Clusterware
  • Hardware and Software Concepts (High level)

RAC Databases Overview & Architecture

  • Overview of Oracle RAC
  • RAC One Node
  • Cluster-Aware Storage Solutions
  • Benefits of Using RAC
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Global Resources
  • RAC and Flex ASM

Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software
  • Installation options
  • Creating the Cluster Database
  • Post-installation Tasks
  • Single Instance to RAC Conversion
  • Cleaning Up Unsuccessful Installs
  • Parameters and RAC - SPFILE, Identical and Unique Parameters
  • Instance Startup, Shutdown and Quiesce
  • Undo Tablespaces
  • Redo Threads
  • Use Enterprise Manager Cluster Database Pages
  • RAC Alerts
  • RAC Metrics
  • Session management on RAC instances

RAC Backup and Recovery

  • Instance Failure And Recovery In RAC - LMON and SMON
  • Redo Threads and Archive Log Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin For RAC: Channels, Instances, Backup Distribution
  • RMAN Restore And Recovery RAC Considerations

RAC Global Resource Management and Cache Fusion

  • Globally Managed Resources and Management
  • Library Cache Management
  • Row cache management
  • Buffer cache fusion
  • Buffer Cache Management Requirements
  • Accessing single blocks in RAC
  • Multi-block read considerations in RAC
  • Undo and read consistency considerations in RAC

RAC Monitoring and Tuning

  • OCPU and Wait Time Latencies
  • Wait Events for RAC
  • Common RAC Tuning
  • Session and System Statistics
  • RAC specific V$ Views
  • Automatic Database Diagnostic Monitor for RAC

Managing High Availability of Services in a RAC Environment

  • Oracle Services
  • Services for Policy - and Administrator-Managed Databases
  • Creating Services
  • Managing Services
  • Use Services with Client Applications
  • Services and Connection Load Balancing
  • Services and Transparent Application Failover
  • Services and the Resource Manager

Managing High Availability of Connections

  • Types of Workload Distribution
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Runtime Connection Load Balancing and Connection Pools
  • Fast Application Notification
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts
  • Configuring the Server-Side ONS

Upgrading and Patching RAC

  • Overview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU and Interim Patches
  • Merge Patches
  • Performing Out Of Place Database Upgrades
  • Planning and Preparing for Upgrade
  • Performing Out of Place Release Install or Upgrade
  • Post Upgrade Tasks

Application Continuity

  • What is AC?

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA, ATO of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London5 7368 £7368 2019-09-23
Virtual Virtual5 7368 £7368 2019-09-30
Glasgow Glasgow5 7368 £7368 2019-09-30
Edinburgh Edinburgh4 7368 £7368 2019-10-01
Bristol Bristol4 7368 £7368 2019-10-01
London London5 7368 £7368 2019-10-07
Midlands Birmingham5 7368 £7368 2019-10-07
Edinburgh Edinburgh5 7368 £7368 2019-10-07
Virtual Virtual5 7368 £7368 2019-10-28
Manchester Manchester5 7368 £7368 2019-10-28
Midlands Coventry5 7368 £7368 2019-11-04
Yorkshire Harrogate5 7368 £7368 2019-11-04
Middlesbrough Middlesbrough5 7368 £7368 2019-11-04
Surrey Guildford5 7368 £7368 2019-11-04
Aberdeenshire Aberdeen5 7368 £7368 2019-11-04
Sunderland Sunderland5 7368 £7368 2019-11-04
Staffordshire Stoke on Trent5 7368 £7368 2019-11-04
Sussex Brighton5 7368 £7368 2019-11-04
Cheshire Crewe5 7368 £7368 2019-11-04
Midlands Birmingham5 7368 £7368 2019-11-04
Derbyshire Buxton5 7368 £7368 2019-11-04
Edinburgh Edinburgh5 7368 £7368 2019-11-04
Bristol Bristol5 7368 £7368 2019-11-04
Middlesbrough Teeside5 7368 £7368 2019-11-04
Cheshire Chester5 7368 £7368 2019-11-04
Hertfordshire Watford5 7368 £7368 2019-11-04
Sussex Brighton5 7368 £7368 2019-11-04
Cheshire Warrington5 7368 £7368 2019-11-04
Merseyside Liverpool5 7368 £7368 2019-11-04
Warwickshire Warwick5 7368 £7368 2019-11-04
Glasgow Glasgow5 7368 £7368 2019-11-04
Lincolnshire Lincoln5 7368 £7368 2019-11-04
Leicestershire Hinckley5 7368 £7368 2019-11-04
Oxfordshire Oxford5 7368 £7368 2019-11-04
Clwyd Wrexham5 7368 £7368 2019-11-04
Cumbria Carlisle5 7368 £7368 2019-11-04
Buckinghamshire Milton Keynes5 7368 £7368 2019-11-04
Warwickshire Warwick5 7368 £7368 2019-11-04
Suffolk Ipswich5 7368 £7368 2019-11-04
Glasgow Glasgow5 7368 £7368 2019-11-04
Bedfordshire Luton5 7368 £7368 2019-11-04
West Sussex Chichester5 7368 £7368 2019-11-04
Yorkshire Leeds5 7368 £7368 2019-11-04
Yorkshire Doncaster5 7368 £7368 2019-11-04
Glamorgan Cardiff5 7368 £7368 2019-11-04
Essex Chelmsford5 7368 £7368 2019-11-04
Hampshire Southampton5 7368 £7368 2019-11-04
Merseyside Liverpool5 7368 £7368 2019-11-04
Yorkshire Wakefield5 7368 £7368 2019-11-04
Essex Chelmsford5 7368 £7368 2019-11-04
Manchester Manchester5 7368 £7368 2019-11-04
Leicestershire Leicester5 7368 £7368 2019-11-04
Devon Exeter5 7368 £7368 2019-11-04
Dorset Bournemouth5 7368 £7368 2019-11-04
Midlands Wolverhampton5 7368 £7368 2019-11-04
West Sussex Chichester5 7368 £7368 2019-11-04
London London5 7368 £7368 2019-11-04
Cambridgeshire Cambridge5 7368 £7368 2019-11-04
Bedfordshire Bedford5 7368 £7368 2019-11-04
Midlands Derby5 7368 £7368 2019-11-04
Yorkshire Sheffield5 7368 £7368 2019-11-04
Somerset Bath5 7368 £7368 2019-11-04
Worcestershire Worcester5 7368 £7368 2019-11-04
Nottinghamshire Nottingham5 7368 £7368 2019-11-04
Devon Plymouth5 7368 £7368 2019-11-04
Somerset Bath5 7368 £7368 2019-11-04
Leicestershire Leicester5 7368 £7368 2019-11-04
Berkshire Swindon5 7368 £7368 2019-11-04
Kent Canterbury5 7368 £7368 2019-11-04
Cambridgeshire Peterborough5 7368 £7368 2019-11-04
Bristol Bristol5 7368 £7368 2019-11-04
Hampshire Southampton5 7368 £7368 2019-11-04
Northern Ireland Belfast5 7368 £7368 2019-11-04
Fife Dunfermline5 7368 £7368 2019-11-04
Edinburgh Edinburgh5 7368 £7368 2019-11-04
Midlands Wolverhampton5 7368 £7368 2019-11-04
Middlesbrough Teesside5 7368 £7368 2019-11-04
Derbyshire Burton upon Trent5 7368 £7368 2019-11-04
Kent Tonbridge5 7368 £7368 2019-11-04
Nottinghamshire Nottingham5 7368 £7368 2019-11-04
Dundee Dundee5 7368 £7368 2019-11-04
Tyne and Wear Newcastle5 7368 £7368 2019-11-04
Oxfordshire Oxford5 7368 £7368 2019-11-04
Devon Plymouth5 7368 £7368 2019-11-04
Northamptonshire Corby5 7368 £7368 2019-11-04
Yorkshire Wakefield5 7368 £7368 2019-11-04
Yorkshire Sheffield5 7368 £7368 2019-11-04
Manchester Manchester5 7368 £7368 2019-11-18
Virtual Virtual5 7368 £7368 2019-11-25
Virtual Virtual5 7368 £7368 2019-11-25
London London5 7368 £7368 2019-11-25
Bristol Bristol5 7368 £7368 2019-12-02
Edinburgh Edinburgh5 7368 £7368 2019-12-02
Bristol Bristol4 7368 £7368 2019-12-03
Devon Exeter4 7368 £7368 2019-12-03
Midlands Birmingham4 7368 £7368 2019-12-03
London London4 7368 £7368 2019-12-16
Virtual Virtual5 7368 £7368 2019-12-16
London London5 7368 £7368 2020-01-13
London London5 7368 £7368 2020-01-27