Oracle Database 12c Install and Upgrade Workshop 1.0 Training & Placements in Chennai "ISQL Global"
Oracle Database 12c R2: Install and Upgrade Workshop
(Course Materials and Course Completion Certificates are directly delivered
from Oracle University to those required for Foreign Opportunity)
(Government of India Approved Education Center - SQL STAR)
This Oracle Database 12c R2: Install and Upgrade Workshop will provide you with keyinformation to install Oracle Database 12c Release 2
software. You’ll also learn how to create a container database and provision pluggable databases.
This
Oracle Database 12c R2: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c
Release 2 software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases.
Learn To:- Configure the Oracle Linux 7 operating system for Oracle softwareinstallation.
- InstallOracle Grid Infrastructure for a Standalone Server (12.1) usingOracle Universal Installer.
- InstallOracle Grid Infrastructure for an Independent Server (12.2) using a golden image.
- ConfigureASMLIB and create ASM disk groups.
- InstallOracle Database software (12.1) using Oracle Universal Installer.
- InstallOracle Database software (12.2) using a silent installation.
- Apply patch set updates to Oracle software.
- Use Oracle Restart to manage components.
- Upgradean existing Oracle Database to Oracle Database 12c Release 2(12.2.0.0.3.
- Create a container database and provision pluggable databases.
Benefits
To You Students will benefit from working with multiple install scenarios in the lab sessions. This will allow the new course to be relevant for
both 12c R1 and 12c R2 setups. After the install of the Grid Infrastructure software, the student will then gain experience
patching Oracle Software.
Prerequisites
Suggested Prerequisite
- Basic knowledge of Linux operating system
- Basic knowledge of Linux System Administration
- Working knowledge of SQL and use of PL/SQL packages
Required Prerequisite- Oracle Linux 5 & 6 System Administration Ed 3
- Oracle Database 12c: Introduction to SQL Ed 1.1
- Oracle Database 12c: Administration Workshop Ed 2
Audience
- Technical Administrator
- Data Warehouse Administrator
- Data Warehouse Administrator
- Database Administrators
- Support Engineer
Course
Objectives- Upgradedatabase to Oracle Database 12c Release 2
- Create a container database
- InstallOracle Grid Infrastructure for a Standalone Server (12.1.0.2.0)
- ConfigureASMLIB and create ASM disk groups
- Apply the latest patch set updates to the Grid Infrastructure software(12.1.0.2.160719)
- InstallOracle Database 12c Release 2 software (12.2.0.0.3)
- Use Oracle Restart to manage components
- Preparethe Linux operating system for Oracle software installation
- InstallOracle Grid Infrastructure for an Independent Server (12.2.0.0.3)
- InstallOracle Database 12c software (12.1.0.2.0)
- Create an Oracle Database using DBCA
- Installthe latest patch set updates to the Oracle database software(12.1.0.2.160719)
Course Topics
Oracle Database 12c R2: Overview
- Oracle Database Innovation
- Oracle Database Server Architecture: Overview
- ProcessArchitecture
- DatabaseStorage Architecture
- Oracle Database Memory Structures
- Objectives
- Oracle Database Instance Configurations
- Connecting to the Database Instance
Oracle
Software Installation Basics- Operating System Groups and Users
- EnvironmentVariables
- Configuring the Oracle Software Owner Environment
- PlanningYour Installation
- UsingOracle Universal Installer (OUI)
- InstallationOption: Silent Mode
- ConfiguringOracle Linux with Oracle RDBMS Pre-Install RPM
Installing
Oracle Grid Infrastructure for a Standalone Server- PostPatch steps using Datapatch
- Determining the latest patch sets available using Oracle Support
- Patching Using OPatch
- UpgradingOPatch
- Patching Using OPlan
- Patching Using opatchauto
- Overview of Patching
- Types of patches
Installing
Oracle Database Software- Creating Operating System Groups and Users
- Types of Installations
- Oracle Database Installation: System Requirements
Creating
an Oracle Database by Using DBCA- Creating a Container Database by Using DBCA
- Planning the Database
- Using the DBCA to Create a Database
- Creating a Database Design Template
- Choosing the Appropriate Character Set
- UnderstandingHow Character Sets Are Used
- Setting the NLS_LANG Initialization Parameter
- Types of Databases
Oracle
Restart- ControllingOracle Restart
- Obtaining Help for the SRVCTL Utility
- Using the SRVCTL Utility
- OracleRestart
- OracleRestart Configuration
- OracleRestart Process Startup
- Choosing the Correct SRVCTL Utility
- Starting Components by Using the SRVCTL Utility
Introduction
to Upgrading to Oracle Database 12c- UpgradePaths
- Upgrade Method Limitations
- Database Upgrade Assistant: Advantages and Disadvantages
- Upgradingto a New Release of Oracle Database
- Defining Upgrade and Data Migration
- UpgradeMethods
- ManualUpgrade: Advantages and Disadvantages
- MigrationMethods
Preparing
to Upgrade to Oracle Database 12c- Requirements for Databases Using Oracle Label Security or Oracle Database Vault
- PerformanceTesting
- Developing a Test Plan
- Planning the Upgrade
- Requirementfor Databases Using Oracle Warehouse Builder
- Using the Pre-Upgrade Information Tool
- Backing Up the Database
- Preparingto Upgrade
Upgrading
to Oracle Database 12c- ManuallyUpgrading to Oracle Database 12c
- Upgradingby Using the Database Upgrade Assistant (DBUA)
- Plugging a Non-CDB Database into a CDB
- KeyDBUA Features
- Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
Performing
Post-Upgrade Tasks- Understanding Auditing Implementation
- Recommended Tasks After Database Upgrade
- Enabling Unified Auditing
- RequiredTasks After Database Upgrade
- Administering the Roles Required for Auditing
Migrating
Data by Using Oracle Data Pump- Creating a New PDB from PDB$SEED
- Exportingfrom a Non-CDB and Importing into a PDB
- Oracle Data Pump: Overview
- Importingby Using a Network Link
- Migratingby Using Oracle Data Pump
- Creating a Container Database by Using DBCA
- DataPump Utility: Interfaces and Modes
- DataPump Export and Import Clients: Overview