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.
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
Testimonials (1)
good explanation on each points and provide assignment for practices.