Oracle Application Database Administration

1. Server Configuration
2. Load And Unload Data
3. Automatic Management
4. Application Management And Availability
5. SQL Support For Analytical Applications
6. System Resource Management
7. The Scheduler
8. Space Management
9. Installing Patches
10. Backups and Crash recovery

Database Performance management

1. Performance Tuning Overview
2. Statistics and Wait Events
3. Metrics, Alerts, and Baselines
4. Using AWR
5. Reactive Tuning
6. Tuning the Shared Pools and Buffer Cache
7. Automatic Shared Memory
8. Checkpoint and Redo Tuning
9. Tuning I/O
10. Tuning PGA and Temporary Space
11. Tuning Block Space Usage
12. Pinning Objects

Cluster Concepts

1. What is a Cluster
2. Why do we need a Cluster in Real Time
3. Advantage and Benefits of Cluster

Oracle 10g RAC Architecture

1. RAC Concept and Architecture
2. RAC Architecture with E-business Suite
3. RAC Architecture with core Application

RAC Pre-Installation Configuration on Cluster Nodes

1. Oracle OS user and group creation
2. OS /etc/hosts entries - Public, Private and Virtual IP address
3. OS .rhosts enable for Oracle and root users
4. Enable rcp and ssh on both cluster Node
5. Make necessary OS related changes as prescribed by Oracle
6. Ping, rcp and ssh test on both cluster nodes
7. Add entry in /etc/hosts.equiv of Cluster nodes to root and oracle user
8. Creating voting and OCR files on the cluster shared mount point

OCFS Installation on SAN (Storage Device)

1. Download Software OCFS2
2. Check for SAN with required disk space
3. Install the OCFS 2
4. Configure
5. O2CB Cluster services Enable
6. Formating Disks using OCFS2 Console
7. Create Mount points and mount the same
8. Tune
9. File system checks
10. Post configuration check using mounted.ocfs2 utility

Oracle 10g RAC Installation

1. Clusterware installation
2. RDBMS Installation
3. Upgrade both CRS and RDBMS for the latest version
4. Create Database based on the application specific sizing
5. Create ASM instance on SAN
6. Create diskgroup for ASM on SAN
7. If for E-business suite need to follow the steps for converting into RAC

Oracle 10g RAC Post Installation

1. Check all the services are running using on both nodes - crs_stat -t
2. Check all the database are up and running by login from both nodes
3. Check by login through the application
4. Stop all the service and reboot the server and restart all the services

Introduction to Data Guard

1. What is Data Guard
2. Why do we need to have a Data Guard
3. Benefits and Advantage of Implementing Data Guard

Pre Data Guard Setup activity

1. Have a separate server with all the pre-requisites for Data Guard Setup
2. Ensure Primary Database in Archivelog mode
3. Take a backup of the Primary database
4. Create the standby control file from Primary Database
5. Copy files to the Standby Server
6. Set the initialization parameters for the primary database

Data Guard Setup on the Standby Server

1. Create same directory structure as the primary database on the Standby server
2. Copy DB TOP or install the same Enterprise Edition RDBMS
3. Create a Backup Copy of the Primary Database Datafiles
4. Copy the primary database parameter file to the standby database server
5. Set Up the Environment to Support the Standby Database
6. Configure listeners for the standby database
7. Start the physical standby database in a READ ONLY Mode
8. Create a new temporary file for the physical standby database
9. Start Redo Apply
10. Test archival operations to the physical standby database

Post Data Guard Setup on the Standby Server

1. Verify the Physical Standby Database Is Performing Properly
2. Identify the existing archived redo log files
3. Force a log switch to archive the current online redo log file
4. Verify the new redo data was archived on the standby database
5. Verify new archived redo log files were applied