Oracle Database Administration for JuniorDBA/Oracle cloud.
สิ่งที่คุณจะได้เรียนรู้
- After completing this course you will have fundamentals required for installation, configuration, and administration of an Oracle 12c database
- To learn Database instance and storage,Instance memory pools
- PGA,SGA
- backup and recovery
ข้อกำหนด
- Oracle Linux operating system RAM 8GB , CPU Two Cores
- Labtop and Oracle virtual box, Oracle Linux 7
คำอธิบาย
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
Database instance and storage
Instance memory pools
Instance background processes
Client connections
Database storage file types
Control files and backup files
Multi-tenant databases
Starting and stopping the database
Installing Oracle 12c software
Using the developer tools
Database management
Oracle Backup (RMAN) Hands-On Demo and Concepts
Starting and connecting to database
How to backup database in Archivelog and NoArchivelog mode with RMAN
Oracle database incremental backup using RMAN
Oracle Backup (User-Managed Backup) Hands-On Demo and Concepts
How to take cold backup and Restore
How to take Hot backup
How to restore Hot backup
Oracle DBA interview questions
Oracle DBA terminology
Oracle Basic Concepts
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
=========================================
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.
หลักสูตรนี้เหมาะกับ
- Oracle Database Administrator ,Oracle Developer
- anyone who wants to start his career as Oracle Database administrator role with all basic to expert level
วิทยากร
- คะแนนวิทยากร 4.0
- รีวิว 3,642 รายการ
- ผู้เรีียน 184,781 คน
- หลักสูตร 25 รายการ
I have done a Master in Computer Science (IT)Additionally) I have more than 23 years of professional experience in UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat), and working as a role Database specialist. I have complete command over the following functions and skills.
Key Skills:
· Oracle Database Administration
· MS SQL Server Administrations
· MYSQL/MariaDB Administration
· Sun Solaris Administration (Certified)
· Linux Administration (Red Hat ,CENTOS,UBUNTU)
· Oracle Application Server Administration
· Banner UDC technology stack DBA track
· Application Administration (LAMP,LEMP)
· Oracle EBS Administration
· Oracle Database Administration (RAC, Data Guard)
· Oracle Business Intelligence Administration
· Hyperion /ESBASE/WEB LOGIC
· Windows Server Administration
· Oracle Data Warehouse Builder
· SQL Server Administration
· Project Management
· Problem solving skills and approach
· Systems audit and control
· Oracle OAM 11G,OSSO 10G EBS R12
· Data Center Design and Implementation
· VMware Infrastructure
· EMC Storage and Legato Networker Administration