Course Key Notes:
1. Weekend batch will be of 4 hours on Saturday & 4 hours on Sunday
2. This is Oracle RAC Workshop
3. Theory and Live demonstration on each topic
4. Daily sessions will be recorded and uploaded to google drive
5. Lab, Quiz, Workbook, Tools/Software given in advance
6. Each topic will be having quiz and multiple-choice answers
7. Daily practical task will be assigned and reviewed
8. This course will be covering real time demonstration and examples
9. Resume and Cover letter writing after course completion
10.We will be reviewing the Interview Questions
11.After the course we will be conducting the Mock Interview
Course fees for Database Course 15K INR or 185 USD
RAC Course Contents:
1. Introduction to Custerware:
a) What is Oracle Clusterware
b) Standalone Vs RAC
c) Networking in Clusterware
2. Clusterware Architecture:
a) Oracle Clusterware Architecture and Cluster Services
b) OCR and Voting disk
c) Clusterware Start-up Sequences
3. Linux Installation and Configuration:
a) Oracle Virtual box setup
b) Installation of Linux (7.9)
c) Post Installation Tasks
d) Clone VMs
4. Network Setting and Configuration:
a) DNS Server Configuration
b) Public IP, VIP and Scan IP Configuration
b) Shared Disk Creation
d) Creation of ASM Disks
5. Cluster Installation and Configuration:
a) Preinstallation Tasks
Check system requirements
Check software requirements
Check kernel parameters
Create groups and users
Create directory
runcluvfy check (./runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose)
b) ssh user equivalence configuration
c) Cluster Installation and Configuration
d) Post Installation Tasks (./cluvfy stage -post crsinst -n node1,node2 -verbose)
6. RAC Oracle Home Installation and Configuration:
a) Preinstallation tasks
Check system requirements
Check software requirements
Check kernel parameters
Create groups and users
Create directory
b) ssh user equivalence configuration
c) RAC Oracle Home Installation and Configuration
d) Post Installation Tasks
7. Disk group Creation:
a) +DATA & +RECO disk group creation
8. RAC Database Creation and Configuration:
a) Preinstallation tasks
(./cluvfy stage -pre dbcfg -n node1,node2 -d Oracle_home -verbose)
(./cluvfy stage -pre dbinst -n node_list [-r {10gR1 | 10gR2 | 11gR1 | 11gR2}] [-osdba osdba_group] [-d Oracle_home] [-fixup [-fixupdir fixup_dir] [-verbose])
b) RAC Database Creation and Configuration
c) Post Installation Tasks
9. ASM Architecture and Understanding:
a) ASM Storage Components
b) Mirroring and Stripping
c) ASM instance parameters
d) ASM Administration
10. Administering ASM Disk Groups:
a) Administering ASM Disk Groups
b) Adding Disk and Dropping Disks
c) Disk group Rebalance and Rebalance Power
11. Clusterware and RAC Database Administration:
a) crsctl vs srvctl
b) Restarting Clusterware and Services
c) Restarting Cluster Databases
d) Rebooting Cluster nodes
12. Clusterware Administration:
a) OCR and Voting Disk
b) Cluster Resource and Services
c) VIP, SCAN IP and Public IP
13. RAC Database Administration:
a) RAC specific parameters
b) pfile and spfile in RAC database
c) password file for RAC database
d) Redo Log Files and Controlfile
e) Tablespaces (Undo, Temp, etc...)
14. RAC Database Backup and Recovery:
a) Understanding the Backup strategy
b) Various Types of Backup
c) Various Recoveries scenarios
15. Listeners in Clusterware:
a) ASM Listeners
b) SCAN Listeners (Remote Listeners)
c) Database Listeners (Local Listeners)
16. Multitenant Architecture and RAC Database:
a) Complete Understanding of Multitenant architecture
b) CDB and PDB Understanding
c) Installation of Pluggable database and Cloning Pluggable Database
d) Connecting to CDB Vs Connecting to PDB
e) Creating a RAC CDB
f) Creating a PDB to RAC CDB
17. ACFS Configuration and Administration:
a) ACFS Configuration
b) Administering Oracle ACFS
c) Managing ACFS
18. Oracle RAC One Node:
a) RAC One Node Vs RAC database
b) Online Relocation
19. Patching Oracle RAC and RAC Databases:
a) OPatch Vs opatchauto
b) Patching Oracle Clusterware
c) Patching RAC Oracle Home
d) Patching RAC Databases
e) Datapath
20. Upgradation Oracle RAC and RAC Databases:
a) Preinstallation Tasks
a) Clusterware upgradation
b) RAC Database Upgradation
d) Post Installation Tasks
21. Node Addition and Removal:
22. Converting Single Instance to RAC:
a) DBCA
b) Enterprise Manager
c) RCONFIG
23. Resume and Cover letter Preparation:
24. Interview Questions:
a) Frequently asked Interview questions and answers
25. Mock Interview:
a) Mock interview and Tips on how to crack interview
when course will start
ReplyDeleteAny fee discount
ReplyDeleteDear Malik,
ReplyDeleteWhen will be the next session start?
are U going show us how to analyze awr and addm reports ?
ReplyDeleteAny course related to tunning
ReplyDelete