Oracle 11gR2 DBA Training Manual

About this manual

This manual introduces the fundamentals of Oracle Database 11gR2 for readers with no prior DBA experience. It covers basic concepts, the relationship between databases, data warehouses, and big data, and provides step‑by‑step lab exercises using a Red Hat 6.4 environment.

The book also explains how to install and configure Oracle 11gR2, perform backup and recovery, and explore performance tuning. Additional resources such as installation media and official documentation are linked via a QR code on the back cover. This manual is written in Chinese.

What's inside

• Overview and Environment Preparation
• Database, Data Warehouse and Big Data
• Database Technology in Big Data
• Related Technologies
• Book Content and Structure
• Experiment Environment Setup

Specifications

Frequently asked questions

Which Oracle version is used as the main environment in this manual?

The manual uses Oracle Database 11gR2, specifically version 11.2.0.4, as the primary environment.

What operating system is required for the lab exercises?

All lab exercises are performed on Red Hat 6.4.

Where can I obtain the Oracle 11gR2 installation media?

The book’s back‑cover QR code links to the support website where the Oracle 11gR2 installation media and official documentation can be downloaded.

Is Oracle 10g still supported?

No, Oracle announced at the end of 2013 that it no longer provides official support for Oracle 10g.