For an Introduction Video - https://youtu.be/yZEmK1dLELQ
ONLINE Interactive LIVE
AWS Cloud Oracle DBA on EC2 / RDS, Oracle GoldenGate,
Oracle DB Migration between On-Premises and AWS Cloud,
Oracle RAC DBA, Oracle DataGuard, Oracle DBA
and Oracle Apps EBS DBA Training Training Portals.
This Portals are
the very biggest knowledge gateway
and the best way to predict the
future for the people
in the Oracle Database Administration
DBA Cloud World
"This ONLINE Interactive Live Oracle DBA Training for you,
DBA Cloud World
"This ONLINE Interactive Live Oracle DBA Training for you,
would be a definite advantage to jump start your IT career immediately and effectively"
SABARI DBA Solutions, Chrompet, Chennai,
+91-999440 8197 (Contact Cum Whatsapp)
sabaridba@gmail.com (Email cum FaceBook ID)
sabaridba@gmail.com (Email cum FaceBook ID)
SABARI - An excellent
experienced Manager Professional with over 18 Years onsite/offshore
experience now at one of the top MNC is providing the Complete ONLINE Interactive Live Oracle
DBA effective Training in
1. AWS Cloud Oracle DBA on EC2 / RDS
2. Oracle GoldenGate
3. Oracle DB Migration Between On-Premises and AWS Cloud
4. Oracle RAC DBA
5.Oracle DataGuard
6. Oracle DBA 19c/18c/12c
7. Oracle Apps EBS DBA
Along with DaytoDay Real Time
Scenarios and Practical Oriented Method by Methods for Oracle DBA Trainees.
Located in CHROMPET, Near Railway Station, Chennai
Post Oracle DBA Training
1.While interacting with well-organized Oracle DBA efficient in any client discussion/interview, as a DBA, you would be effectively presented as an experienced DBA professional in the DBA world. Therefore you would be definitely appointed.
2. In the working environment on any oracle DBA project, as a DBA, you would be fixed the DBA administration tasks confidently without anxieties or doubts. Hence it is enhancing your oracle DBA career and DBA knowledge rewardingly.
1.While interacting with well-organized Oracle DBA efficient in any client discussion/interview, as a DBA, you would be effectively presented as an experienced DBA professional in the DBA world. Therefore you would be definitely appointed.
2. In the working environment on any oracle DBA project, as a DBA, you would be fixed the DBA administration tasks confidently without anxieties or doubts. Hence it is enhancing your oracle DBA career and DBA knowledge rewardingly.
3.In addition, this DBA training gives hands to complete OCA or OCP significantly. It would be highly appreciated in your yearly appraisal.
If you have any enquiries or clarifications
Contact cum Whatsapp +91-999440 8197
or
Visit : https://www.sabaridbasolutions.com
For the complete Modules on Oracle DBA Project Practical Oriented Syllabus, Refer the below.
M O D U L E - 1
AWS Cloud Oracle DBA on EC2 / RDS
Focus : AWS EC2 / RDS
OS : Linux on EC2
Duration : 3 to 4 Weekends on (Saturday and Sunday)
Duration : 3 to 4 Weekends on (Saturday and Sunday)
Audience Eligibility : Oracle DBA
Section-1 Introduction to Amazon Cloud & History
What is Free Tier in AWS
How-to Sign-up Process for AWS
Understanding AWS Cloud Management Console
Section-2 Amazon AWS Architechture
Exploring Regions & AZs
Understanding and Exploring Virtual Private Cloud(VPC)
Create a Custom VPC
What is Security Group and Creating Security Group
Definition of EBS (Elastic Block Store) Volume & Creating EBS
What is Amazon S3 Storage & Creating S3 Buckets
Install and Configure AWS Client on both Windows 10 & Linux on EC2 Instance/Machine
Install SSH Client i.e Windows Terminal on Windows 10
Section-3 Exploring Amazon EC2 with Oracle Database
Definition of EC2 (Elastic Compute Cloud)
What are AWS Instance Types & AMI (Amazon Machine Images
Creating an EC2 Instance for Oracle 12c/18c/19c
Download and Stage Oracle 12c/18c/19c
Installing of Oracle 12c/18c/19c on EC2
Configuring Oracle Secure Backup & Performing DB Backup to S3 Storage
Performing a Restore from S3 Storage
Section-4 Exploring Relational Database Service (RDS)
What is Amzon RDS and Amazon RDS for Oracle
Understanding Backup & Recovery in RDS
Creating DB Subnet Group
Creating Default and Custom (our own) DB Parameter Group
Creating Default and Custom (our own) DB Options Group
Provisioning an RDS Database for Oracle
Monitoring in RDS (CloudWatch / Enhanched Monitoring)
Creating a Manual Snapshot on Oracle RDS DB
Restoring a Database from RDS Snapshot
Applying Database Patching in RDS
Connecting to RDS Database using sqlplus
Oracle DB Commands Vs Oracle RDS Commands
======================================================================
M O D U L E - 2 Oracle GoldenGate DBA
Focus : Oracle GoldenGate19c
OS : Linux
Duration : 3 to 4 Weekends on (Saturday and Sunday)
Duration : 3 to 4 Weekends on (Saturday and Sunday)
Audience Eligibility : Oracle DBA
Oracle GoldenGate contents details would be provided On request.
============================================================
M O D U L E - 3
Oracle DB Migration Between On-Premises and AWS Cloud
Focus : Between On-Premises and AWS Cloud
OS : Linux
Duration : 3 to 4 Weekends on (Saturday and Sunday)
Audience Eligibility : Oracle DBA
Contents details would be provided On request.
============================================================
Module - 4 Oracle RAC DBA + ASM
Focus : On Linux OS Platform
Duration : 4 Weekends on (Saturday and Sunday)
Audience Eligibility : An Oracle DBA
P A R T - I
BEFORE RAC PRACTICE - ASM
1-Overview of ASM (Automatic Storage Management)
2-ASM Components
3-Creating Database with ASM
4-Migrating Database From FileSystem Storage to ASM
5-Managing & Monitoring ASM
BEFORE RAC P R A C T I C E - RAC
1-Overview of Oracle RAC (Real Application Cluster)
2-Oracle RAC Network
3-Oracle RAC Architecture
P A R T - II
P R A C T I C A L - RAC
1-Installing Virtual Machine Ver14.0 on Your Local Desktop/Laptop Windows OS 64 bit System
2-Creating Virtual Machine for RAC1 Node/Server
3-Installing OS OEL (Oralce Enterprise Linux) Ver6.5 on RAC1 Node/Server
4-Oracle Recommended Configuration in OS on RAC1 Node/Server
5-Creating Partitions on RAW Devices (for ASM Disks Usage) via RAC1 Node/Server
6-Cloning Virtual Machine i.e. RAC2 Node/Server from VM RAC1 Node/Server
7-Network Configuration between RAC1 Node & RAC2 Node (After Cloning the RAC2 Node)
8-sshUserSetup.sh Configuration & runcluvfy.sh execution on Both RAC1 Node and RAC2 Node via RAC1
Node
9-ASM Library Configuration on Both RAC1 Node & RAC2 Node
10-Installing Oracle Grid IS Software for RAC via RAC1 Node
11-Creating Further DiskGroups ex: DG1,RD, ... by invoking asmca (ASM Configuration Assistant)
12-Installing Oracle Database Software for RAC via RAC1 Node/Server
13-Creating RAC Database ex: devdb by DBCA via RAC1 Node/Server
14-TAF Service Config or RAC DB Service config on both Server Side & Client Side
15-Testing the TAF Service or RAC DB Service
16a-Creating Sample Single Instance Non-ASM Database ex: avrdb, avrdb1 on RAC1 Node/Server only
16b-Migrating Single Instance Database (i.e.Non-ASM DB) to RAC DB Environment
17-Before Adding Node Ex: RAC3 Node, Cloning VM RAC3 Node from VM RAC1 Node
18-Before Adding Node Ex: RAC3 Node, Network Configuration Between RAC1, RAC2 and RAC3 Nodes
19-On Adding Node Ex:RAC3 Node, runSSHSetup.sh excution for Extenting SSH on New Node
i.e. RAC3 Node
20-On Adding Node Ex: RAC3 Node, ASM Library Configuration for New Node i.e. RAC3 Node
21-On Adding Node Ex: RAC3 Node, run cluvfy utility via RAC1 Node before Extending Oracle GRID-IS SW
22-On Adding Node Ex: RAC3 Node, Extending Oracle Grid IS Software
23-On Adding Node Ex: RAC3 Node, Extending Oracle Database Software
24-On Adding Node Ex: RAC3 Node, Extending Database Instance Ex: devdb3
25-On Removing Node Ex: RAC3 Node, Deleting Database Instance Ex: devdb3
26-On Removing Node Ex: RAC3 Node, Removing Oracle Database Software
27-On Removing Node Ex: RAC3 Node, Removing Oracle Grid IS Software
28-On Removing Node Ex: RAC3 Node, Removing Remaining Components
P A R T - III
POST RAC PRACTICE - RAC BASIC ADMINISTRATION
1-Managing Initialization Parameters in RAC Environment
2-Managing SRVCTL Utility in RAC Environment
3-Enabling ARCHIVELOG Mode in RAC Environment
4-Enabling FLASHBACK ON in RAC Environment
5-Rescripting the Control File in RAC Environment
POST RAC PRACTICE - RAC ADVANCED ADMINISTRATION
1-Assigning the Virtual HAIP on Private Network OR Cluster Interconnect on Each Node
2-Managing (or) Modifying SCAN Name & SCAN VIPs
3-Adminstrating HAS (High Availability Server) & CRS (Cluster Ready Service)
4-Administrating OLR (Oracle Local Registry) File
5-Administrating OCR (Oracle Cluster Repository) File
6-Administrating VOTING DISK File
POST RAC PRACTICE - RAC INTERNAL
1-General Idea about RAC Internal
2-General Idea about RAC Background Process
POST RAC PRACTICE - ROLLING PATCH in RAC
1-How to Apply PSU, CPU, OneOff Patches
2-Sample of Applying PSU (or) CPU on Both GRID_HOME & ORACLE_HOME in Rolling
Manner
3-Sample of Applying PSU (or) CPU on Both GRID_HOME & ORACLE_HOME in NOT
Rolling Manner
4-Sample of Applying One-Off Patch in Rolling Manner
POST RAC PRACTICE - RAC Q and A
1-RAC Interview Q and A
Preparing for an Interview and Group Discussions.
Preparing the Resume in the required way for an Oracle RAC DBA
========================================================================
M O D U L E - 5 Oracle Dataguard DBA
Focus : On Linux OS Platform
Duration : 3 Weekends on (Saturday and Sunday)
Audience Eligibility : an oracle DBA
Audience Eligibility : an oracle DBA
P A R T - I
B E F O R E - P R A C T I C E
1-Introduction of DataGuard
2-Oracle Database Enterprise Edition Requirement
3-Dataguard Architecture Diagram
4-Standby Database Types
5-Dataguard Protection Modes
6-What is Dataguard Broker
P A R T - II
P R A C T I C A L
1-Installing Virtual Machine Ver14.0 on Your Local Desktop/Laptop Windows OS 64 bit System
2-Creating Virtual Machine for PRIMARY Server
3-Creating Virtual Machine for STANDBY1 Server
4-Installing OS OEL Ver6.5 on Both PRIMARY Server and STANDBY1 Server
5-Oracle Configuration in OS on Both PRIMARY Server and STANDBY1 Server
6-Creating Partitions on RAW Devices (for ASM Disks Usage) on Both PRIMARY Server and
STANDBY1 Server
7-Network Configuration Between PRIMARY Server and STANDBY1 Server
8-ASM Library Configuration on PRIMARY Server
9-Installing Oracle Grid IS Software for Stand Alone on PRIMARY Server
10-asmca (ASM Configuration Assistant) on PRIMARY Server
11-ASM Library Configuration on STANDBY1 Server
12-Installing Oracle Grid IS Software for Stand Alone on STANDBY1 Server
13-asmca (ASM Configuration Assistant) on STANDBY1 Server
14-Installing Oracle Database Software on PRIMARY Server
15- Installing Oracle Database Software on STANDBY1 Server
16-Sample Database Creation (example: devdb) on PRIMARY Server only
17a-Preparing Primary Database on PRIMARY Server and Standby Database on STANDBY1
Server
17b-Preparing Primary Database Newtwork Configuration
17c-Preparing Standby Database Network Configuration
17d-TNS Ping Checking on Both PRIMARY Server and STANDBY1 Server
17e-Duplicating the Primary Database on STANDBY1 Server
17f-Editing oratab File on STANDBY1 Server
17g-Verifying Standby Database Setup
17h-Set Retention and Turn on Flashback Mode on Both Primary Database and Standby Database
17i-Start Redo Apply on Standby Database
17j-Verify Synchronization Between Primary Database & Standby Database
18-Configuring and Enabling Dataguard Broker on Both PRIMARY Server and STANDBY1 Server
19-Dataguard Switch-Over (Role Transition)
20-Dataguard Manual Fail-Over Testing
P A R T - III
P O S T - P R A C T I C E
1-Start Up & Shutdown a Physical Standby Database
2-Monitoring, Configuring “Apply Lag” and Enabling “Zero Lag” in Real-Time Query
Environment in 11g
3-Monitoring Redo Transport Synchronizing Response Time on Primary Database
4-Automatic and Manual Repair of Corrupted Data Blocks
5-Adding Temp Files to Physical Standby Database
6-Primary Database Changes That Require Manual Intervention at Physical Standby Database
7-While Opening Primary Database with OPEN RESETLOGS Option (After Recover)
8-Manual Archived Redo Log Gap Solution
9-Snapshot Standby Database
10-Monitoring Primary Database, Physical Standby Database and Snapshot Standby Database
=======================================================================
M O D U L E - 6 Oracle DBA 19c/18c/12c/11gR2
Focus: On Linux OS Platform
Duration: 8 Weekends on (Saturday and Sunday)
General Session:-
DBA Perspective SQL Commands.
Connectivity between your laptop or desktop and the LINUX based Oracle Database servers.
DBA Perspective LINUX OS Commands and its OS Installation.
Imparting the tips, technic, and trick of irrespective of any version until Oracle 19c/18c/12c/11gR2 and specifically Oracle 19c/18c/12c and 11gR2 Database Installations (Both Manually Creating Database and During the Oracle Software Installation) on LINUX OS.
Session - 1 - Architecture:-
The complete Oracle Architecture such as SGA, Background Process, Instance, Database like Logical Database Structure and Physical Database Structure, Initialization Parameter File, Password file, Startup/Shutting down the Database, Control Files, Redolog files, ArchiveLog files, Directory Structure before creating database in any version, Manual Creating Database in 19c/18c/12c/11gR2, Type of INDEXES, Type of CONSTRAINTS, Profile, Schema/User Management, Privileges, ROLE, and PGA Management etc.,
Session - 2 - Performance Tuning:-
Strong Manual SQL Query Tuning in all version, Generating and Investigating AWR – Automatic Workload Repository, ADDM – Automatic Database Diagnostic Monitor, ASH - Active Session History Tuning, SQL Tuning Advisor, SQL Profile, SQL Plan Baseline Management, SGA Memory Tuning, ASMM – Automatic Shared Memory Management, AMM - Automatic Memory Management, APMM – Automatic PGA Memory Management (APMM), Disk I/O Contention, Handling Locking issue and Removing Locking, Monitoring Parallel Sessions / Inactive Sessions / Active Sessions, UNDO Tablespace Tuning, UNDO_Retention Tuning, RedoLog Group Size Tuning, Arc backgroud process Tuning etc.,
Session - 3 - (Advanced higher-end tasks including Backup and Recovery Strategies):-
Oracle Connectivity between the oracle DB servers / Oracle Client and Server based technology
Back and Recovery – Physical Backups such as RMAN and its Configuration, Hot/Online Backup, Cold/Offline Backup and Logical Backup - Exp / Imp and DATAPUMP ).
Upgrading the Oracle Software from Lower ver. to Higher ver.
Cross-Platform migration of the Oracle Database from one OS platform to another OS.
Migrating the Oracle Database from lower ver. to higher ver.
Cloning the Oracle Database viable RMAN Backup - Cloning the Oracle Database viable Hot Backup - Cloning the Oracle Database viable Cold Backup.
Preparing the DBA purpose Testing Database in Testing Server
Preparing Mirroring Database in Mirroring Server (Before or pre-requisite for DataGuard concept).
Database Refresh Activities (from lower ver. to higher ver.)
Schema Refresh Activities with proper Tablespace Calculations (from lower ver. to higher ver.)
Table Refresh Activities with proper Tablespace Calculations (from lower ver. to higher ver.)
The Complete Overview of Database Link (DBLinks) and Materialized view.
Flashback Technologies.
Oracle Loader / External Tables
Space Management (Segment Shrink Functionality, and Other Space Management Tools such as UNDO Advisor and Redo Log Advisor).
And the new features of Tablespace related topics till the latest ver. 19c
Preparing for an Interview and Group Discussions.
Preparing the Resume in the required way for an Oracle DBA.
=======================================================================
Module - 7 Oracle APPS EBS DBA R12.x.x
Focus : On Linux OS Platform
Duration : 4 Weekends on (Saturday and Sunday)
Audience Eligibility : an oracle DBA
P A R T - I - BEFORE Oracle APPS DBA P R A C T I C E
P A R T - II - P R A C T I C A L / P R A C T I C E - Oracle APPS DBA (R12.x.x)
P A R T - III - POST P R A C T I C A L / P R A C T I C E - Oracle APPS DBA (R12.x.x)
↪ Describe Oracle E-Business Suite Architecture
↪ Directory Structure (or) Navigating Oracle E-Business suite FileSystem
↪ Directory Structure - WEBLOGIC with FMW In EBS R12.2
↪ DIFFERENCES or Changes between R12, R12.1 AND R12.2
↪ START/STOP E-Business Suite R12, R12.1 AND R12.2
↪ EBS SCHEMAs - APPLSYS/APPS, APPLSYSPUB, GUEST ...
↪ FNDCPASS, FNDLOAD ...
↪ AUTOCONFIG in R12, R12.1 AND R12.2
↪ AD Utilities & Technology Layer (AD, FND,AU ...)
P A R T - I - BEFORE Oracle APPS DBA P R A C T I C E
P A R T - II - P R A C T I C A L / P R A C T I C E - Oracle APPS DBA (R12.x.x)
P A R T - III - POST P R A C T I C A L / P R A C T I C E - Oracle APPS DBA (R12.x.x)
↪ Gain Oracle E-Business suite
↪ Installing VM10 Workstation for E-Business Suite
↪ Creating VM for E-Business Suite
↪ Installing OS OEL65 on EBS Machine(s)
↪ Oracle Configuration in OS for EBS
↪ Oracle EBS Installation - Single Node AND Multi Node
↪ Oracle EBS Latest AD Patch
↪ Oracle Autoconfig Patch
↪ Oracle Rapid Clone Patches
↪ Creating Autoconfig Context File on DB Node or/In-case of Multi Node
↪ Clone Oracle E-Business Suite
↪ Apps DBA Roles AND Responsibilities
↪ Installing VM10 Workstation for E-Business Suite
↪ Creating VM for E-Business Suite
↪ Installing OS OEL65 on EBS Machine(s)
↪ Oracle Configuration in OS for EBS
↪ Oracle EBS Installation - Single Node AND Multi Node
↪ Oracle EBS Latest AD Patch
↪ Oracle Autoconfig Patch
↪ Oracle Rapid Clone Patches
↪ Creating Autoconfig Context File on DB Node or/In-case of Multi Node
↪ Clone Oracle E-Business Suite
↪ Describe Oracle E-Business Suite Architecture
↪ Directory Structure (or) Navigating Oracle E-Business suite FileSystem
↪ Directory Structure - WEBLOGIC with FMW In EBS R12.2
↪ DIFFERENCES or Changes between R12, R12.1 AND R12.2
↪ START/STOP E-Business Suite R12, R12.1 AND R12.2
↪ EBS SCHEMAs - APPLSYS/APPS, APPLSYSPUB, GUEST ...
↪ FNDCPASS, FNDLOAD ...
↪ AUTOCONFIG in R12, R12.1 AND R12.2
↪ AD Utilities & Technology Layer (AD, FND,AU ...)
- ↪ RAPID CLONE Oracle E-Business Suite in R12, R12.1 AND R12.2
- ↪ UPGRADE Oracle E-Business Suite
- ↪ In-Corporating or Registering Custom Application i.e CUSTOM_TOP
- ↪ System Management using Oracle Application Manager (OAM)
↪ Managing Concurrent Programs and Reports
↪ Flow-Concurrent Processing & Request Submission
↪ Flow-New Individual Standard Manager (or) Transaction Manager
↪ Summary-New Individual Standard Manager (or) Transaction Manager
↪ Summary-Concurrent Program/Concurrent Program Libraries
↪ Know-Directory Structure
↪ Define-Executable
↪ Define-Concurrent Program
↪ Summary-Responsibility
↪ Define-Responsibility - including Application Security Attribute
↪ Summary-User
↪ Define-User - including Application Security Attribute
↪ Explanation-Concurrent Manager
↪ Define-Concurrent Manager
↪ Administer-Concurrent Manager
↪ Submit-Concurrent Request
↪ Trouble Shooting Concurrent Manager
=======================================================================
Best Regards
Sabari ,
Sabari ,
Contact cum Whatsapp : +91-999440 8197
Email Cum FaceBook ID : sabaridba@gmail.com