Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (1)
good explanation on each points and provide assignment for practices.