Dear All,
Those who
want to learn Oracle 19C RAC DBA online training from starting to Expert level
follow the below course content.
Course
Duration: 7 weekends ( Sat &
Sun) 3 hours / per day ( 42 hours )
Staring the training from 15th Feb 2025 to 30th Mar 2025 (Total 7
weekends)
Weekend sessions:
Saturday: 8:00 AM to 11 AM IST , 10:30 PM to 1:30AM ET
Sunday: 8:00 AM to 11 AM IST , 10:30 PM to 1:30AM ET
Demo Session : Oracle RAC DBA Demo session Weekend
batch
Time: 15th
Feb 2025 08:00 AM IST
Join Zoom
Meeting :: will share on request those who are interested to join Oracle RAC
DBA online training .
Course Content:
WhatsApp group:
https://chat.whatsapp.com/JTC9OhT5Aq1ETTuByC3MEr
Contact no: +91 9392634440 ( whatsapp) , mail id : racsinfotech@gmail.com
Registration Form :: https://docs.google.com/forms/d/1L8gWNTCP3WvOlklR62oag3XGXCPqd_CBjbDl2AtsK1s/viewform
RAC Course Contents:
1.
Introduction to Oracle Custer ware / Cluster ware Architecture
>>
Standalone Vs RAC
>>
What is Oracle Cluster ware
>>
Oracle Cluster ware Architecture and Cluster Services
>>
RAC One Node Vs RAC database
>>
Online Relocation
>>
Networking in Cluster ware
>>
Cluster ware services Start-up and shutdown Sequences
>>
what are OCR and Voting disk
2. Linux
Installation and Configuration step by step on Oracle VM.
>>
Oracle Virtual box 7 version setup on windows.
>>
Installation of Linux OS (7.x)
>>
OS Post Installation checks and Tasks
>>
Node1 VM to Node2 VM Clone .
3.
Network Setting and Configuration setup.
>>
Public IP, Private IP , VIP and Scan IP Configuration
>>
DNS Server Configuration
>>
VM Shared Disk Creation process
>>
how to create ASM Disks using VM shared disk's.
4.
Cluster Installation and Configuration steps.
>>
Custer Pre-installation Tasks
> System requirements Checks
> Kernel parameters checks
> Create required directory ,groups and
users for grid & db install
> Execute the ./runcluvfy from any one of
the nodes using below command
ex: ./runcluvfy.sh stage -pre crsinst -n
racnode1,racnode2 -verbose)
>>
ssh user password less /equivalence configuration on cluster nodes.
>>
Start the Oracle Cluster Installation and Configuration steps using
./gridSetup.sh
>>
Cluster Post Installation checks
ex::
./cluvfy stage -post crsinst -n racnode1,racnode2 -verbose
5. Oracle
RAC DB Installation and Configuration steps
>>
Pre-installation tasks
> System requirements Checks
> Kernel parameters checks
> Create required directory ,groups and
users for db install
> ssh user password less connection setup / equivalence configuration
>>
Installation and Configuration RAC DB.
>>
RAC DB software Post Installation Tasks
6. Create
Oracle ASM Disk groups >> +OCR,+DATA & +ARCH etc disk groups.
7. Oracle
RAC Database Creation and Configuration
>>
Pre-installation for Oracle RAC DB Configuration
./cluvfy
stage -pre dbcfg -n racnode1,racnode2 -d Oracle_home -verbose
./cluvfy
stage -pre dbinst -n node_list [-r {11gR1 | 11gR2 | 12cR1 | 12cR2}] [-osdba osdba_group] [-d Oracle_home] [-fixup
[-fixupdir fixup_dir] [-verbose]
>>
Oracle RAC Database Creation and Configuration using dbca / command line using
response file.
>>
Post Installation Tasks for Oracle RAC DB Configuration
8. Oracle
ASM Introduction & Architecture
>>
Oracle ASM Storage Components.
>>
what is Mirroring and Stripping in ASM.
>>
what are the ASM instance parameters.
>>
Oracle ASM Administration process / steps.
9. Oracle
ASM Disk Groups Administering
>>
How to Administering Oracle ASM Disk Groups.
>>
How to Preform Adding Disk to Disk group and Dropping Disks from disk groups.
>>
How to Preform Disk group Rebalance and Rebalance Power limit in ASM.
10. RAC
Database Administration and Oracle Cluster ware Administration
##Oracle
Cluster ware Administration
>>
What are OCR and Voting Disks in Cluster.
>>
What are the Cluster Resource and Services
>>
What are crsctl vs srvctl utilities / tools.
>>
How to Restarting Oracle Cluster ware and Services.
>>
How to Restarting Oracle Cluster Databases.
>>
How to Rebooting Cluster Nodes.
>>
what is VIP, SCAN IP , Private and Public IP In RAC.
11. RAC
Database Administration
>>
Oracle RAC specific parameters In Init/spfile.
>>
Difference between pfile and spfile in RAC database
>>
Use of password file for RAC database
>>
How to manage the Redo Log Files and Control file.
>>
UNDO & TEMP Tablespaces use cases.
12.
Backup and Recovery in Oracle RAC Database
>>
Backup strategy Understanding in RAC.
>>
Types of Backups in RAC.
>>
Recoveries scenarios in RAC.
13.
Networking setup in RAC ( Listeners in Cluster ware / Local )
>>
Grid / ASM Listeners.
>>
Remote / SCAN Listeners (Remote Listeners).
>>
Local Database Listeners (Local Listeners).
14. RAC
Database Multitenant Architecture vs Non Multitenant Architecture
>>
Oracle Multitenant Architecture In-detail.
>>
what are CDB and PDB databases.
>>
How to Install the Pluggable database(PDB).
>>
How to Clone Pluggable Database(PDB).
15. ASM
Cluster Filesystem (ACFS) Configuration and Administration
>>
How to Configure ACFS in Linux.
>>
How to Administering & Managing ACFS.
16.
Patching Oracle RAC and RAC Databases
>>
What are the OPatch Vs opatchauto utilities.
>>
How to Patch Oracle Cluster ware.
>>
How to Patch RAC Oracle Home.
>>
How to Patch RAC Databases.
>>
what is Datapatch.
17.
Oracle Cluster/Grid and Database Upgradation from lower version to Higher
>>
Pre-Upgrade steps.
>>
How many ways we can perform db and grid
upgrade.
>>
Post-upgrade steps.
18. How
to perform Node Addition and Deletion in RAC
>>
Pre-requisites for node addition.
>>
Node addition steps
>>
post node addition steps.
>>
Pre-requisites for node deletion.
>>
Node deletion steps
>>
post node deletion steps.
19. How
to Convert the Single Instance to RAC using DBCA / OEM / RCONFIG etc.
**20.
Interview Preparation Tips and Mock Interviews to crack Realtime Interviews.
**21.
Resume / CV Preparation Tips and suggestions.
Thanks,
Srini
