Oracle

From Dilli

Contents 1 Oracle Database Installation 2 Oracle Database Uninstallation 3 Oracle Real Application Cluster Installation 4 Standby Database 5 Tunning Oracle Database 6 Tunning Oracle Real Application Cluster 7 Troubleshoot Oracle Database 8 Troubleshoot Oracle Real Application Cluster Database 9 Patching and Upgradation Oracle 10 Oracle logfiles 11 Training 12 Tips and Tricks 13 Tutorials

Oracle Database Installation

• Install Oracle 10g database on Windows
• Install Oracle 10g on Linux
• Install Oracle 10g on Solaris
• Install Oracle 11g database on Windows
• Install Oracle 11g on Linux
• Install Oracle 11g on Linux RHEL 6
• Install Oracle 11g on Solaris
• Install Oracle 11g database with ASM on Linux 5
• Step by Step installing Oracle 10g RAC on VMware
• Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS

Oracle Database Uninstallation

• Uninstall Oracle 10g database on Windows
• Uninstall Oracle 10g on Linux
• Uninstall Oracle 10g on Solaris
• Uninstall Oracle 11g database on Windows
• Uninstall Oracle 11g on Linux
• Uninstall Oracle 11g on Solaris

Oracle Real Application Cluster Installation

• Install Oracle 10g RAC on Windows
• Install Oracle 10g RAC on Linux
• Install Oracle 10g RAC on Solaris
• Install Oracle 11g RAC database on Windows
• Install Oracle 11g RAC on Linux
• Install Oracle 11g RAC on Solaris

Standby Database

• Configure Physical Standby Database
• Configure Logical Standby Database

Tunning Oracle Database

Tunning Oracle Real Application Cluster

• RAC Cheatsheet

Troubleshoot Oracle Database

Troubleshoot Oracle Real Application Cluster Database

• Adding a Node on an Existing Oracle RAC 10g R2 Cluster on Linux
• Remove a Node from an Existing Oracle RAC 10g R2 Cluster on Linux
• Adding a Node on an Existing Oracle RAC 11g R2 Cluster on Linux
• Remove a Node from an Existing Oracle RAC 11g R2 Cluster on Linux
• Disk time out setting
• Fixing IPC Send timeout detected
• Troubleshooting ORA-24756: transaction does not exist DISTRIB TRAN
• Multiple Idle session

Patching and Upgradation Oracle

• Patching Oracle 10.2.0.1 to Oracle 10.2.0.4

1. Pre-Request for upgrade
2. Cluster Upgrade
3. Database Upgrade

• Patching Oracle 10.2.0.1 to Oracle 10.2.0.5
• Patching Oracle 11.2.0.1 to Oracle 11.2.0.3

• Upgrading Oracle 10.2.0.5 to Oracle 11.2.0.1

Oracle logfiles

• Log Files Oracle Database
• Log Files Oracle RAC Environment

Training

• Oracle 10g DBA training course
• Oracle 11g DBA training course

Tips and Tricks

• How Oracle Works
• How Oracle stores data in its files
• How the database is ticking
• Rollup and Cube
• Oracle 10g New Features
• How to find Master Node in Oracle RAC
• Backup and Recovery of OCR - Oracle Cluster Registry
• Voting disk Backup and Recovery
• Encrypt Oracle 10g RMAN backup files using Oracle wallet
• Restore encrypted RMAN backup
• Resource Management
• Resource management Quick Demo
• Insert demo data
• Auto Start/Shutdown Oracle 11g on CEntOS
• Update with join

Tutorials

• Undo Management
• Using rlwrap to get command line history in SQL*Plus
• Installing ASM on Linux and Windows