Courses

Oracle Basic Course

Oracle RAC Course 

 

Oracle Basic Course

1.       Oracle Database Architecture

                                I.            Instance Components

                              II.            SGA

                            III.            DB Buffer pool

                            IV.            Data Dictionary pool

                              V.            Log buffer

                            VI.            Background processes

                          VII.            SMON

                        VIII.            PMON

                            IX.            CKPT

                              X.            LGWR

                            XI.            DBWR

                          XII.            ARCH

2.       Installing the Oracle Database

                                I.            Install and configure Oracle database

                              II.            Use of DBCA

3.       Managing Oracle Instance

                                I.            Startup modes of Instance

                              II.            Shutdown Modes of Instance

                            III.            How to start Instance

                            IV.            How to stop Instance

4.       Pfile/SPfile Management

                                I.            Difference between pfile and spfile

                              II.            Working of pfile and spfile

5.       Multiplexing of Controlfile

                                I.            Multiplexing of control file and it’s benefits

6.       Viewing Alert Log 

7.       Tablespace Management 

8.       Creation on data file 

9.       Expansion of data files 

10.     Log file concepts 

11.     User Management 

12.     Undo Management

13.     Locking Mechanism 

14.     Performance Management 

15.     Backup and Recovery Concepts 

16.     Logical and Physical Backup 

17.     Data Pump Concepts 

18.     Automatic Storage Management Concepts

Oracle RAC Course 

1.       Evaluation of RAC

                                I.            RAC Architecture

                              II.            Difference between Single instance Vs RAC Environment

                            III.            Components of RAC

                            IV.            Oracle Cluster ware

                              V.            Oracle Cluster Registry (OCR)

                            VI.            Cluster Synchronization Service (CSS)

                          VII.            RAID Levels 

2.       Fresh installation and configuration of RAC

                                I.            Install LINUX/OEL O/S

                              II.            Configuring Public, Private and Virtual I/P’s

                            III.            Configuring Hang Check timer

                            IV.            Creation of Oracle user & Groups and Setting environmental variable

                              V.            Configuring SSH

                            VI.            Configuring storage for database

                          VII.            Create partition

                        VIII.            Install and configure oracle ASM libraries

                            IX.            Create Oracle ASM volumes

                              X.            Execute runcluvry.sh

                            XI.            Installing GRID software

                          XII.            Installing Database software

                        XIII.            Creating database instance 

3.       RAC Administration

                                I.            Administration through SRVCTL

                              II.            Administration through CRSCTL

                            III.            Checking OCR Integrity 

4.       Cache Fusion

                                I.            Introduction to Cache Fusion

                              II.            Different Scenarios of Cache Fusion 

5.       TAF (Transparent Application Failover)

                                I.            Introduction to TAF

                              II.            Configure and test TAF 

6.       RAC trouble shooting

                                I.            Log Directories on Each Instance

                              II.            Log Directories in Oracle RDBMS

                            III.            Node Eviction Issues

                            IV.            Split Brain Syndrome (Cause)

                              V.            Patching Oracle RAC Instances (Only Theory)