Monday, August 7, 2017

ONLINE Oracle DBA Training in Chennai Day to Day RealTime Scenarios, Project & Practical Oriented

https://sites.google.com/site/sabarioracledbaonline/

"ONLINE Oracle RAC DBA+ASM, Oracle DBA, DataGuard and GoldenGate 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 Oracle DBA Training for you, would be a definite advantage to jumpstart your IT career immediately and effectively"

Sabari – Chennai – contact – (0) 9994408197
sabaridba@gmail.com



SABARI - Oracle DBA an excellent experienced Manager Professional with more than 18 Years onsite/offshore experience now at one of the top MNC is Providing the Complete ONLINE Oracle DBA effective Training in (1) RAC DBA +ASM 2) Combined Oracle 12c/11g/10g DBA  3) DataGuard 4) GoldenGate) along with Day-to-Day and Real Time Scenarios and Method by Methods for trainees.


Located Near by CHROMPET Rly. Station - Chennai


Post Oracle DBA Training

1.While interacting with well-organized Oracle DBA efficients in any client discussion / interview, as a DBA / RAC DBA, you would be effectively presented like an experienced DBA professional in the DBA world. Therefore you would be definite appointed.

2. In 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 me, Whatsapp Cum Tel. +91-9994408197



Refer the complete Modules for Oracle  DBA Project Practical Oriented Syllabus as cited below

Regards
Sabari - Chennai
sabaridba@gmail.com
Contact : 9994408197

======================================================================


Module -I
1. 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 RAC11gR2 (Real Application Cluster)
2-Oracle RAC11gR2 Network
3-Oracle RAC11gR2 Architecture


P A R T - II
P R A C T I C A L - RAC

1-Installing Virtual Machine Ver10.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 required way for an Oracle RAC DBA 
Best Regards
Sabari - 9994408197
=========================================================================


M O D U L E - II
2. Oracle Dataguard 11gR2 DBA 

Focus : On  Linux OS Platform
Duration : 3 Weekends on (Saturday and Sunday)
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 Ver10.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 in 11g
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

Best Regards
Sabari - 9994408197
sabaridba@gmail.com
=======================================================================


M O D U L E - III
3. Combined Oracle DBA 12c,11gR2 and 10gR2   

Focus : On Linux OS platform

General Session :-

DBA Perspective SQL Commands.

Connectivity between your laptop or desktop and the UNIX based Oracle Database servers.


DBA Perspective UNIX flavoured OS Commands and its OS Installation.


Imparting the tips, technic and trick of ir-respective of  any version until Oracle 12c and specifically Oracle 12c/11g and 10g Database Installations (Both Manually Creating Database and During Oracle Software Installation) on UNIX flavoured OS.

Remote Oracle 12c/11g/10g Database Installations with using VNC Server.

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 12c/11gR2/10gR2, 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 base 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 Managements (Segment Shrink Functionality, and Other Space Management Tools such as UNDO Advisor and Redo Log Advisor).

And new feature of  Tablespace related topics till latest ver. 12c

Preparing for an Interview and Group Discussions.
Preparing the Resume in required way for an Oracle DBA.

Best Regards
Sabari - 9994408197
sabaridba@gmail.com

=======================================================================

M O D U L E - IV
4. Oracle GoldenGate DBA

Focus : On Unix / Linux OS Platform
Audience Eligibility an oracle DBA

Oracle GoldenGate contents details would be provided after the discussion held and once your admission has confirmed.

Best Regards
Sabari - 9994408197
sabaridba@gmail.com