Oracle Database Administration for JuniorDBA/Oracle cloud.

About Oracle Database Administration for JuniorDBA/Oracle cloud.

Oracle Database 12c is the world's leading relational database management system.After completing this course you will have fundamentals required for installation, configuration, and administration ,Architecture of an Oracle 12c database including hand on all exercise files are attached with respective chapter.

Topics Covered

1. Database instance and storage 2. Instance memory pools 3. Instance background processes 4. Client connections 5. Database storage file types 6. Control files and backup files 7. Multi-tenant databases 8. Starting and stopping the database 9. Installing Oracle 12c software 10. Using the developer tools 11. Database management

Oracle Backup (RMAN) Hands-On Demo and Concepts

12. Starting and connecting to database 13. How to backup database in Archivelog and NoArchivelog mode with RMAN 14. Oracle database incremental backup using RMAN

Oracle Backup (User-Managed Backup) Hands-On Demo and Concepts

15. How to take cold backup and Restore 16. How to take Hot backup 17. How to restore Hot backup 18.

Oracle DBA interview questions

19. Oracle DBA terminology 20. Oracle Basic Concepts 21.

QUICK REVIEW VERY Useful for DBA

Install oracle 18c Demo Install Oracle enterprise manager(OEM) in steps Demo Oracle Migration from Non-RAC to RAC database Demo Oracle Database clone in RAC enviroment Demo Convert oracle database from windows to Linux Demo Duplicate Oracle Database using RMAN Demo ========================================= 22.

Oracle Database 19c installation in Oracle Linux 7

Action Plan:

1. Preparing the Oracle Linux 7.6 Operating System for Database 19c installation. 2. Virtual Box Settings for Oracle Linux 7 VM. 3. Setting the static ip address 4. kernel parameters configuration 5. Resource limit configuration and stopping the Firewall 6. dependencies installation 7. oracle database installation 8. Host name configuration for Oracle Linux VM. 9. Oracle listener configuration after installation. 10. Starting the Database in SQL Plus 11. Create one Common user called "scott" 12. SQL Developer 19.1 Connectivity with Oracle database 19c 13. Mounting the pluggable database orclpdb and check connectivity on SQL Developer. 14. Access the Oracle Enterprise Manager on host machine browser.