Skill Up Card - Course Bundles

Pricing is per delegate, giving you huge savings over the cost of individual courses.

  • UK = £2,000 + VAT per Skill Up Card
  • Ireland = €2,400 per Skill Up Card
skill up card logo - Nexus Human

Oracle 12c Administration I

4.6 out of 5 rating Last updated 14/11/2024   English

Jump to outline

Click "Enquire" below to find out more about this course

Interested in available dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.


Duration

5 Days

30 CPD hours

Overview

Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics.

Description

In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems.

Oracle Database Architercture Overview
  • The Database Instance
  • Database Memory Structures
  • Database Process Structures
  • Database Storage Architecture
  • Oracle Clusterware
Configuring the Host for Standalone Installlation
  • Host Configuration Overview
  • Choosing a Database Host
  • Choosing an Operating System
  • Proprietary Unix vs Open-Source Linux
  • Making the OS Selection
  • Prepare an Oracle LINUX Installation
  • Perform Oracle LINUX Installation
  • Configure the LINUX Host
  • Step 1 - Confirm General System Requirements
  • Step 2 - Confirm The Operating System Platform
  • Step 3 - Confirm LINUX Package Requirements
  • Step 4 - Confirm Network Configuration
  • Configure Host for Virtualization
  • VM Technologies
  • Configure Oracle Linux for Virtualization
  • Step 1 - Download Linux Updates
  • Step 2 - Check Linux Kernel
  • Step 3 - Download Latest yum Configuration File
  • Step 4 - Enable Oracle Linux Add-ons
  • Step 5 - Install VirtualBox
  • Oracle Optimal Flexible Architecture
  • OFA Goals
  • ORACLE_BASE
  • ORACLE_HOME
  • Database Files
  • Multiple ORACLE_HOMEs
  • Databse Software Upgrades
  • Mutliple Oracle Software Installations
GRID Infrastructure Configuration
  • Configure the Linux Installation
  • About ASM Devices
  • Configure Linux Devices for ASM
  • Partioning a Device
  • Oracle ASMLib
  • Configue MS Windows Devices
GRID Infrastructure Installation
  • Perform the Installation
  • Download
  • Unpack the Installation Package
  • Launch the Installation Session
  • The Installation Dialog
  • Verify the Installation
  • Operating System Confirmation
  • Oracle Utilities Setup
  • SQL*Plus Confirmation
  • Using EM Cloud Control
  • Troubleshooting Problems
DATABASE Installation Configuraion
  • Configure a Linux Installation
  • System Groups & Users
  • Configure Kernel Parameters
  • Create the Physical Directories
  • Configure MS Windows Installation
  • Prerequisite Checks & Fixup Utility
DATABASE Installation
  • ABOUT THE INSTALLATION
  • The Installation Tools
  • About The Installation Dialog
  • The Installation Session Log
  • PERFORM INSTALLATION ON LINUX
  • Download
  • Unpack The Installation Files
  • Set Environment Variables
  • Launch The Installation
  • SERVER CLASS INSTALLATION DIALOG
  • More About The Global Database Name
  • About Enterprise Manager Cloud Control
  • Secure The New Database
  • PERFORM INSTALLATION ON WINDOWS
  • Launch The Installation
  • POST---INSTALLATION CONFIGURATION
  • Required Environment Variables
  • Defining The Environment Variables
  • About SSH
  • VERIFY THE INSTALLATION
  • SQL*PlusConfirmation
  • Operating System Confirmation
  • Firewall Configuration
  • Accessing EM Database Express
Creating Databses Using DBCA
  • About DBCA
  • DBCA Templates
  • Are You Sure
  • DEFAULT CONFIGURATION DATABASE
  • ADVANCED MODE DATABASE
  • File Location Variables
  • Database Vault and Label Security
  • CONFIGURE AN EXISTING DATABASE
  • DELETE A DATABASE
  • MANAGE TEMPLATES
  • MANUALLY CREATE A DATABASE
  • The CREATE DATABASE Command
Using Oracle Restart
  • WHAT IS ORACLE RESTART
  • What Oracle Restart Does
  • Is Oracle Restart Deprecated
  • Registering With Oracle Restart
  • More About srvctl
  • Terminal Session Configuration
  • COMPONENT STATUS USING SRVCTL
  • Database Status
  • Grid Infrastructure Status
  • Oracle Home Status
  • CONFIGURATION USING SRVCTL
  • Examining A Database Configuration
  • Examining The Listener Configuration
  • Examining The ASM Configuration
  • Manual Registration
  • ListenerConfiguration Modification
  • Database ConfigurationModification
  • STARTUP/SHUTDOWN USING SRVCTL
  • Why Use srvctl
  • MANAGING ORACLE RESTART
  • Obtaining Oracle Restart Status
  • Start/Stop Oracle Restart
Preparing for a Database Upgrade
  • What is a Database Upgrade
  • Database Upgrade Methods
  • Real World Database Upgrade
  • Develop A Database Upgrade Plan
  • ABOUT THE DATABASE VERSION
  • Direct Upgrade
  • The COMPATIBLE Database Parameter
  • PRE-UPGRADE PREPARATIONS
  • Oracle Warehouse Builder
  • Oracle Label Security (OLS)
  • Oracle Database Vault
  • Locating The Older Database Installations
  • THE PRE-UPGRADE INFORMATION TOOL
  • Pre-Upgrade Information Tool Files
  • Run The Pre---Upgrade Information Tool
  • Examining The Pre---Upgrade Information Tool Results
Upgrade to Oracle Databse 12c
  • Launch DBUA
  • Database Upgrade Dialog
Post-Upgrade Tasks
  • Post-Upgrade Checklist
  • Enable Unified Auditing
  • Migrate to Unified Auditing
  • Database Parameter Changes
  • Enable New Features
  • Source Destination Specific Post-Upgrade Tasks
Oracle Architecture: The Systems Infrastructure
  • About Enterprise Architectures
  • The Relational Database
  • Legacy Computing Models
  • The Multi-Tiered Computing Model
  • Scaling Up
  • Cloud-Based Deployment
  • ORACLE INFRASTRUCTURE ECOSYSTEM
  • USING ORACLE ENTERPRISE MANAGER
  • More About EM
  • Using EM Database Express
  • Using EM Cloud Control
Oracle Architecture: The Database Host
  • The Database Server Stack
  • PROCESSOR LAYER
  • CPU Resources
  • Memory Resources
  • I/O & STORAGE PROCESSING
  • OS LAYER PROCESSING MODES
  • DATABASE SERVER VIRTUALIZATION
  • STORAGE VIRTUALIZATION
  • ORACLE DATABASE SERVER STACK
  • ORACLE ENGINEERED SYSTEMS
  • Oracle Exadata Database Platform
  • Exalogic Cloud Machine
  • Exalytics BI Machine
Oracle Architecture: Princilples & Technology Concepts
  • Grid Computing Principles
  • Why Grid Computing
  • What Is Grid Computing
  • PARALLELIZATION PRINCIPLES
  • Hardware Parallelization
  • Grid Computing Devices
  • Clustered Database Servers
  • CLOUD COMPUTING PRINCIPLES
  • Multi-Tenancy
Oracle Architecture: The RDBMS Installation & the Database Instance
  • The Database Server Software
  • Database Versions & Releases
  • Database Editions
  • Using PRODUCT_COMPONENT_VERSION View
  • The Core Database Components
  • Using V$VERSION View
  • Understanding The Database Version Number
  • The COMPATIBLE Database Parameter
  • DATABASE INSTANCE ELEMENTS
  • Individual Elements Of A Database Instance
  • Physical Database Elements
  • An Operational Database installation
  • DATABASE INSTANCE CONFIGURATIONS
  • Single Instance
  • Parameter Files & Instance Configuration
  • MAX_STRING_SIZE Parameter Example
  • Independent Instances
  • Clustered Instances
  • The Database Instance In A Multi-tenant Configuration
  • RECONFIGURING A DATABASE INSTANCE
  • Static Vs. Dynamic Parameters
  • Dynamic Parameter Setting
  • Parameter Setting Scope
  • Parameter Setting Level
  • Setting Upgrade Related Parameters
  • DATABASE COMPONENTS
  • Advanced Data Functionality Components
  • Security Components
  • High-Performance Components
  • Administration Components
  • Database F
Additional course details:

Nexus Humans Oracle 12c Administration I training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Oracle 12c Administration I course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Oracle 12c Administration I Course

Available Delivery Options for the Oracle 12c Administration I training.
  • Live Instructor Led Classroom Online (Live Online)
  • Traditional Instructor Led Classroom (TILT/ILT)
  • Delivery at your offices in London or anywhere in the UK
  • Private dedicated course as works for your staff.
How many CPD hours does the Oracle 12c Administration I training provide?

The 5 day. Oracle 12c Administration I training course give you up to 30 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

What is the correct audience for the Oracle 12c Administration I training?

This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals.

Do you provide training for the Oracle 12c Administration I.

Yes we provide corporate training, dedicated training and closed classes for the Oracle 12c Administration I. This can take place anywhere in UK including, England, Scotland, Cymru (Wales) or Northern Ireland or live online allowing you to have your teams from across UK or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Oracle 12c Administration I program.

The Oracle 12c Administration I training takes place over 5 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

Why are Nexus Human the best provider for the Oracle 12c Administration I?
Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for UK on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.
Is there a discount code for the Oracle 12c Administration I training.

Yes, the discount code PENPAL5 is currently available for the Oracle 12c Administration I training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.

Jump to dates

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Top

}