Get in Touch

Course Outline

Introduction to Oracle Database 19c

  • Summary of Oracle Database 19c capabilities and architectural design.
  • Review of system requirements necessary for installation.
  • Examination of installation techniques, including manual setup and the use of Oracle Universal Installer (OUI).

Planning for Installation

  • Preparing the environment: defining hardware and software prerequisites.
  • Configuring the operating system for Oracle Database deployment.
  • Establishing network and storage specifications.

Deploying Oracle Database 19c

  • Guided installation process utilizing Oracle Universal Installer (OUI).
  • Setting up Oracle Net Services to enable database connectivity.
  • Building the database instance using the Database Configuration Assistant (DBCA).
  • Completing post-installation activities: defining environment variables, validating the setup, and hardening database security.

Installing Oracle Grid Infrastructure

  • Overview of Oracle Grid Infrastructure for standalone servers (Oracle Restart).
  • Procedures for installing and configuring Oracle Grid Infrastructure.
  • Administration of Oracle ASM and Clusterware components.

Oracle Database Upgrade Process Overview

  • Identification of valid upgrade paths and supported versions.
  • Strategic planning for upgrades, including pre-upgrade tasks and critical considerations.
  • Selection of tools and methodologies for upgrading to Oracle Database 19c.

Preparing for Database Upgrades

  • Execution of the Oracle Database Pre-Upgrade Information Tool.
  • Resolution of pre-upgrade alerts and recommendations.
  • Creation of database backups prior to the upgrade.

Executing the Upgrade

  • Upgrading to Oracle Database 19c with the Database Upgrade Assistant (DBUA).
  • Manual upgrade procedures using command-line utilities.
  • Post-upgrade operations: refreshing database parameters, recompiling invalid objects, and testing the upgraded system.

Troubleshooting and Best Practices

  • Identification of frequent issues during installation and upgrade phases.
  • Utilization of log files and diagnostic utilities for problem resolution.
  • Application of best practices to ensure successful installation and upgrade outcomes.

Conclusion and Future Steps

Requirements

  • Foundational knowledge of Oracle database administration.
  • Proficiency with SQL and PL/SQL.

Target Audience

  • Database administrators.
  • IT professionals.
 7 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories