Thursday, December 31, 2009

Oracle DBA Training Chennai - Day-to-Day and Real Time Scenarios DBA Project Oriented Training


"Oracle DBA, Oracle RAC DBA + ASM, Oracle GoldenGate DBA & Oracle DataGuard  DBA portals are the very biggest knowledge gateway and the best way to predict the future for the people in the Oracle Database Administration 
DBA World"   

"This 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 Manager Professional with more than 18 Years onsite/offshore experience now at one of the top MNC) is providing the Complete Oracle DBA effective training in (Oracle RAC DBA + ASM / Oracle GoldenGate DBA  / Oracle DataGuard DBA /Combined Oracle DBA 12c,11gR2,10gR2 & 9iR2) along with Day-to-Day DBA project oriented with Real Time Scenarios and Methods for DBA trainess.

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 : 9994408197

Refer the complete Modules and its DBA Project & Practical oriented Syllabus as cited below for 
M O D U L E - I Combined Oracle DBA 12c,11g,10g & 9i  / M O D U L E - II Combined Oracle RAC 11gR2 DBA + ASM &  / M O D U L E - III Oracle DataGuard 11gR2 DBA 
M O D U L E - IV Oracle GoldenGate DBA 11gR2 


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

======================================================================
M O D U L E - I
1. Combined Oracle DBA 12c,11gR2,10gR2, & 9iR2    
Focus : On UNIX flavoured 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 upto Oracle 11gR2 and specifically Oracle 11gR2/10gR2 and 9iR2  Database Installations (Both Manually Creating Database and During Oracle Software Installation) on UNIX flavoured OS.

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

Session - 1 - Architecture in 11g/10g/9i:-

The complete Oracle Architecture such as SGA,  Background Process,   Instance,  Database like Logical Database Structure &  Physical Database Structure,  Parameter File, Password file,  Startup/Shutting down the Database,  Control Files,  Redolog files,  ArchiveLog files, Manual Creating Database in 12c/11gR2/10gR2/9iR2,  Type of INDEXES, Type of CONSTRAINTS,  Profile,  Schema/User Management,  Privileges,  ROLE &  PGA Management (APMM),  etc.,

Session - 2 - Performance Tuning :-

Strong Manual SQL Query Tuning in all version,  SQL Tuning Advisor (Automatic),  Memory Tuning,  ASMM – Automatic Shared Memory Management, AMM - Automatic Memory Management ADDM – Automatic Database Diagnostic MonitorStatspack Analysis,  AWR – Automatic Workload Repository,  Disk I/O Contention,  Handling Locking issue and Removing Locking,  Monitoring Parallel Sessions / Inactive Sessions / Active Sessions, PGA Tuning,  APMM – Automatic PGA Memory Management, ASH - Active Session History Tuning, 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  & DATAPUMP ).  

Upgrading the Oracle Software from lower version to higher version.


Upgrading the Oracle Software from one version to another version.

Cross Platform migration of the Oracle Database from one OS platform to another OS.

Migrating the Oracle Database (from 9i to 10g, 10g to 11g and 9i to 11g, 9i to 12c).

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 DataGuard concept).

 Database Refresh Activities (from 9i to 12c).

 Schema Refresh Activities with proper Tablespace Calculations (from 9i to 12c).

 Table Refresh Activities with proper Tablespace Calculations (from 9i to 12c).

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 & Redo Log Advisor).

 And Further Tablespace related topics since Oracle 12c/11g/10g.

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 - II
2. Combined Oracle RAC11gR2 DBA + ASM  
Focus : On Unix / Linux OS Platform

Audience Eligibility : an oracle DBA

P A R T - I

B E F O R E - P R A C T I C E  =>  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

B E F O R E - 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

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 & 
   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 (Database Configuration Assistant) 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 & 
     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 Software

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

P O S T - P R A C T I C E => 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



P O S T - P R A C T I C E => 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



P O S T - P R A C T I C E => RAC INTERNAL

1-General Idea about RAC Internal
2-General Idea about RAC Background Process


P O S T - P R A C T I C E => 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


P O S T - P R A C T I C E => RAC  Q & A

1-RAC Interview Q & A


Best Regards
Sabari - 9994408197

sabaridba@gmail.com

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

M O D U L E - III
3. Oracle Dataguard 11gR2 DBA 
Focus : On Unix / Linux OS Platform

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 (Oracle Enterprise Linux) Ver6.5 on Both PRIMARY Server & STANDBY1 
   Server

5-Oracle Configuration in OS on Both PRIMARY Server & STANDBY1 Server

6-Creating Partitions on RAW Devices (for ASM Disks Usage) on Both PRIMARY Server & 
   STANDBY1 Server

7-Network Configuration Between PRIMARY Server & 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 & 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 & 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 & Turn on Flashback Mode on Both Primary Database & Standby Database

17i-Start Redo Apply on Standby Database

17j-Verify Synchronization Between Primary Database & Standby Database

18-Configuring & Enabling Dataguard Broker on Both PRIMARY Server & 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” & Enabling “Zero Lag”  in Real-Time Query 
   Environment in 11g

3-Monitoring Redo Transport Synchronizing Response Time on Primary Database

4-Automatic & 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 & Snapshot Standby Database

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

M O D U L E - IV

4. Oracle GoldenGate DBA 11gR2/12c
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