Oracle Database 19c DBA Administration - Production Support Training Course

I am offering Oracle DBA 19c Production Support Detailed Course
DBA Professional increase skills and expert level and secure job

Course Outline
Phase I - Installation Configuration and Upgrade DB Version:
• Discuss Oracle Database Structure and Design Cloud Computing
• Oracle Pre-Requisite before installation and Configuration system requirement
• Discuss shared storage GB / TB database, Memory Calculation, Characterset & Instance
• Operating System (MS. Windows Server / Linux – Unix) system & patch requirement
• Oracle Enterprise Edition Installation and Configuration Single Node and Multi-Node
• Verify the Installation & DB Logs
• Oracle DBCA, DBUA & Deinstallation

Phase II – Oracle DBA Administration:
• Manually Starting & Stopping Database Services
• Configure Oracle Enterprise Manager Tool
• Create an Database Instance & Create an Oracle Database (DBCA)
• Create Schema’s, manage roles (grant & revoke)
• Oracle Database Link’s
• Oracle Centralized database concept and database replication
• Oracle Network Service Configuration (Listener, Netmgr Admin)
• Start / Stop Listener and resolve listener issues
• Manage Transparent Data Encryption
• Manage Oracle Databases Tablespaces & Data Files
• How to reduce TEMP Tablespace, Data Files & Undo Data
• Security: Implementing Oracle Database Security & Privileges
• Security: Administering User Security & Create and Manage Password File
• Moving Data: SQL Loader
• Moving Data: Export & Import
• Database Migration & Upgrade

Phase III – Oracle Database Tuning & Performance:
• Database Maintenance & Performance Monitoring
• Database Health Check Report
• Managing Database Locks

Backup / Restore:
• Backup and Recovery Concepts and Configuration
• Import & Export Data
• Data Migration One OS to another OS
• Oracle RMAN configuration & Commands
• Oracle RMAN backup / restore scripts included OS schedule backup
• Tape backup concept and scripting
• Backup Database Encryption

Oracle Patching:
• How to apply Oracle DB Patch to upgrade features as per oracle support recommended
• How to apply Oracle RAC Database patch on multi-nodes

Phase IV - Oracle Database Health Checks:
•` Oracle Database Health Checks Scripts and EM Cloud Control 13c Health Checks & Alert Notification
• Database Gather Stat Schema / Table / Database to improve Database Performance
• Database Administrator Activities and Performance
• Auto Reindex New Advance Future in 19c
• Database Guard Implementation for Disaster Recovery and High Availability

Oracle Support Account Information:
• How to create a ticket to oracle support for Disaster, crash Database
• Step By Step how to resolve problem / issues on via support documents
• Download patch, software upgrade version’s
• How to manage admin DBA account and create and manage privilege of oracle support

Oracle DBA Support Tools:
• Oracle * SQL-Loader (load data & Scripting)
• EM (Oracle Enterprise Manager) tool (Core DB & RAC DB)
• Oracle Enterprise Manager Cloud Control 13c Tool
• Toad DBA tool
• Spotlight tool

Operating System Platform:
• MS. Windows Server
• Red hat Linux

Course Fee: 2500-SAR
Course Duration
Weekly: 3 classes and per class (3 hours) in a day and 3 days in week (Thr-Fri-Sat): Total 4 Weeks
Time: Evening 5:00 pm to 8:00 pm

Contact Details:
Instructor Name: Khalid Khan (Sr. Oracle DBA -OCP 12c)
Mob- Whatsapp:0553316892