RAC-Training

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:

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



Regards,
Mallik

4 comments:

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...