Get in Touch
 Duration 7 hours

Course Outline

Introduction to Oracle Database 19c

  • A look at the key features and architectural design of Oracle Database 19c
  • Assessing the system prerequisites required for installation
  • An overview of deployment methods, including manual installation and the use of Oracle Universal Installer (OUI)

Pre-Installation Preparation

  • Environment setup: reviewing hardware and software requirements
  • Configuring the operating system to support Oracle Database installation
  • Establishing network and storage configurations

Installing Oracle Database 19c

  • Guided installation process using Oracle Universal Installer (OUI)
  • Configuring Oracle Net Services to enable database connectivity
  • Database creation using the Database Configuration Assistant (DBCA)
  • Post-installation activities: setting environment variables, verifying the install, and hardening security

Installing Oracle Grid Infrastructure

  • Understanding Oracle Grid Infrastructure for standalone servers (Oracle Restart)
  • Deployment and configuration of Oracle Grid Infrastructure
  • Administration of Oracle ASM and Clusterware components

Oracle Database Upgrade Process Overview

  • Identifying valid upgrade paths and supported version transitions
  • Strategic planning for upgrades: reviewing pre-upgrade tasks and key considerations
  • Selection of tools and methods for upgrading to Oracle Database 19c

Getting Ready for the Upgrade

  • Utilizing the Oracle Database Pre-Upgrade Information Tool
  • Resolving any pre-upgrade warnings or recommendations
  • Executing a full database backup prior to the upgrade

Executing the Upgrade

  • Upgrading to Oracle Database 19c via the Database Upgrade Assistant (DBUA)
  • Performing manual upgrades using command-line utilities
  • Post-upgrade maintenance: adjusting database parameters, recompiling invalid objects, and testing system integrity

Troubleshooting and Best Practices

  • Identifying common pitfalls during installation and upgrade processes
  • Leveraging log files and diagnostic tools for effective troubleshooting
  • Adhering to best practices for a successful installation and upgrade

Summary and Future Pathways

Requirements

  • A foundational knowledge of Oracle database administration concepts
  • Proficiency in SQL and PL/SQL

Target Audience

  • Database administrators
  • IT professionals

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories