1. Database Installation

1.1 Database Installation Guide for Linux

1. Oracle Database Installation Checklist
2. Checking and Configuring the Server for Oracle Database
3. Automatically Configuring Oracle Linux with Oracle Database Preinstallation RPM
4. Configuring Operating Systems for Oracle Database on Linux
5. Configuring Users, Groups, and Environments for Oracle Grid Infrastructure and Oracle Database
6. Configuring Networks for Oracle Database
7. Supported Storage Options for Oracle Database and Oracle Grid Infrastructure
8. Configuring File System Storage for Oracle Database
9. Configuring Storage for Oracle Grid Infrastructure for a Standalone Server
10. Installing and Configuring Oracle Grid Infrastructure for a Standalone Server
11. Installing Oracle Database
12. Oracle Database Post installation Tasks
13. Removing Oracle Database Software

1.2 Database Client Installation Guide for Linux

1. Oracle Database Client Installation Checklist
2. Checking and Configuring Server Hardware for Oracle Database Client
3. Configuring Operating Systems for Oracle Database Client on Linux
4. Configuring Users, Groups, and Environments for Oracle Database Client
5. Installing Oracle Database Client
6. Installing Oracle Instant Client on Linux for Arm (aarch64)
7. Oracle Database Client Postinstallation Tasks
8. Removing Oracle Database Software

1.3 Database Installation Guide for Windows

1. Oracle Database Installation Checklist
2. Oracle Database Preinstallation Tasks
3. Overview of Oracle Database Installation
4. Configuring Users, Groups, and Environments for Oracle Database
5. Configuring File System Storage for Oracle Database
6. Installing and Configuring Oracle Grid Infrastructure for a Standalone Server
7. Installing Oracle Database
8. Oracle Database Postinstallation Tasks
9. Getting Started with Oracle Database
10. Removing Oracle Database Software

1.4 Database Client Installation Guide for Microsoft Windows

1. Oracle Database Client Installation Checklist
2. Oracle Database Client Preinstallation Tasks
3. Installing Oracle Database Client
4. Oracle Database Client Postinstallation Tasks
5. Removing Oracle Database Client Software

---

2. Database Concepts

Part I: Oracle Relational Data Structures

1. Introduction to Oracle Database
2. Schema
3. Tables and Table Clusters
4. Indexes and Index-Organized Tables
5. Partitions, Views, and Other Schema Objects
6. Data Integrity
7. Data Dictionary and Dynamic Performance Views

Part II: Oracle Data Access

6. SQL
7. Server-Side Programming: PL/SQL and Java

Part III: Oracle Transaction Management

8. Data Concurrency and Consistency
9. Transactions

Part IV: Oracle Database Storage Structures

10. Physical Storage Structures
11. Logical Storage Structures

Part V: Oracle Instance Architecture

12. Oracle Database Instance
13. Memory Architecture
14. Process Architecture
15. Application and Oracle Net Services Architecture

Part VI: Oracle Database Administration and Application Development

16. Topics for Database Administrators and Developers
17. Concepts for Database Administrators
18. Concepts for Database Developers

---

3. Database Administration

Part I: Basic Database Administration

1. Getting Started with Database Administration
2. Creating and Configuring an Oracle Database
3. Starting Up and Shutting Down
4. Configuring Automatic Restart of an Oracle Database
5. Managing Processes
6. Managing Memory
7. Managing Users and Securing the Database
8. Monitoring the Database
9. Diagnosing and Resolving Problems

Part II: Oracle Database Structure and Storage

10. Managing Control Files
11. Managing the Redo Log
12. Managing Archived Redo Log Files
13. Managing Tablespaces
14. Managing Data Files and Temp Files
15. Transporting Data
16. Managing Undo
17. Using Oracle Managed Files

Part III: Schema Objects

18. Managing Schema Objects
19. Managing Space for Schema Objects
20. Managing Tables
21. Managing Indexes
22. Managing Clusters
23. Managing Hash Clusters
24. Managing Views, Sequences, and Synonyms
25. Repairing Corrupted Data

Part IV: Database Resource Management and Task Scheduling

26. Managing Automated Database Maintenance Tasks
27. Managing Resources with Oracle Database Resource Manager
28. Oracle Scheduler Concepts
29. Scheduling Jobs with Oracle Scheduler
30. Administering Oracle Scheduler

Part V: Distributed Database Management

31. Distributed Database Concepts
32. Managing a Distributed Database
33. Developing Applications for a Distributed Database System
34. Distributed Transactions Concepts
35. Managing Distributed Transactions

Part VI: Managing Read-Only Materialized Views

36. Read-Only Materialized View Concepts
37. Read-Only Materialized View Architecture
38. Planning for Read-Only Materialized Views
39. Creating and Managing Read-Only Materialized Views
40. Troubleshooting Problems with Read-Only Materialized Views

Blockchain Tables

---

4. Net Services Administrator’s Guide

Part I: Understanding Oracle Net Services

1. Introducing Oracle Net Services
2. Identifying and Accessing the Database
3. Managing Network Address Information
4. Understanding the Communication Layers
5. Understanding Oracle Net Architecture

Part II: Configuration and Administration of Oracle Net Services

6. Quick Start to Oracle Net Services
7. Managing Oracle Net Services
8. Configuring Naming Methods
9. Configuring and Administering Oracle Net Listener
10. Configuring Oracle Connection Manager
11. Configuring a Shared Server Architecture
12. Configuring Profiles
13. Enabling Advanced Features of Oracle Net Services
14. Optimizing Performance

Part III: Testing and Troubleshooting Oracle Net Services

15. Testing Connections
16. Troubleshooting Oracle Net Services

---

5. Backup and Recovery User’s Guide

Part I: Overview of Backup and Recovery

1. Introduction to Backup and Recovery
2. Getting Started with RMAN
3. Recovery Manager Architecture
4. Starting and Interacting with the RMAN Client
5. Configuring the RMAN Environment
6. Configuring the RMAN Environment: Advanced Topics
7. Using Flashback Database and Restore Points

Part II: Backing Up and Archiving Data

8. RMAN Backup Concepts
9. Backing Up the Database
10. Backing Up the Database: Advanced Topics

Part III: Managing RMAN Backups

11. Reporting on RMAN Operations
12. Maintaining RMAN Backups and Repository Records
13. Managing a Recovery Catalog

Part IV: Diagnosing and Responding to Failures

14. RMAN Data Repair Concepts
15. Diagnosing and Repairing Failures with Data Recovery Advisor
16. Validating Database Files and Backups
17. Performing Complete Database Recovery
18. Performing Flashback and Database Point-in-Time Recovery
19. Performing Block Media Recovery
20. Performing RMAN Recovery: Advanced Scenarios
21. Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
22. Recovering Tables and Table Partitions

Part V: Tuning and Troubleshooting

23. Tuning RMAN Performance
24. Troubleshooting RMAN Operations

Part VI: Transferring Data with RMAN

25. Duplicating Databases
26. Duplicating Databases: Advanced Topics
27. Creating Transportable Tablespace Sets
28. Transporting Data Across Platforms

Part VII: Setting Up RMAN for Cloud Backup and Restores

29. Backing Up an Oracle Database to Cloud
30. Persistent Settings for RMAN Cloud Backups
31. Oracle Database Backup Cloud Service
32. Oracle Secure Backup Cloud Module for Amazon S3

Part VIII: Performing User-Managed Backup and Recovery

33. Making User-Managed Database Backups
34. Performing User-Managed Database Flashback and Recovery
35. Performing User-Managed Recovery: Advanced Scenarios

---

6. Automatic Storage Management

Part I: Introduction

1. Introducing Oracle Automatic Storage Management
2. Exploring Considerations for Oracle ASM Storage

Part II: Oracle ASM Instances and Disk Groups

3. Administering Oracle ASM Instances
4. Administering Oracle ASM Disk Groups
5. Administering Oracle ASM Files, Directories, and Templates
6. Using Views to Display Oracle ASM Information
7. Administering Oracle ASM with Oracle Enterprise Manager
8. Performing Oracle ASM Data Migration with RMAN
9. Managing Oracle ASM With ASMCA
10. Managing Oracle ASM with ASMCMD

Part III: Oracle Automatic Storage Management Cluster File System

11. Introducing Oracle ACFS and Oracle ADVM
12. Using Views to Display Oracle ACFS Information
13. Administering Oracle ACFS with Oracle Enterprise Manager
14. Managing Oracle ACFS and Oracle ADVM With ASMCA
15. Managing Oracle ADVM with ASMCMD
16. Managing Oracle ACFS with Command-Line Tools

Part IV: Advanced Topics

17. Understanding Oracle ACFS Advanced Topics
18. Configuring Oracle ACFS Snapshot-Based Replication
19. Oracle Patching and Oracle ACFS
20. Managing Oracle Flex ASM
21. Administering Oracle ASM Filter Driver
22. Creating Database Files in Oracle ASM Using SQL*Plus

---

7. Database Performance Tuning Guide

Part I: Getting Started

1. Introduction
2. Oracle Database Performance Method

Part II: Proactive Database Tuning

3. Automatic Database Performance Monitoring
4. Monitoring Real-Time Database Performance
5. Monitoring Real-Time Database Operations
6. Monitoring Performance Alerts

Part III: Reactive Database Tuning

7. Manual Database Performance Monitoring
8. Resolving Transient Performance Problems
9. Resolving Performance Degradation Over Time
10. Using Automatic Workload Repository Warehouse for Generating Performance Reports

Part IV: SQL Tuning

11. Identifying High-Load SQL Statements
12. Tuning SQL Statements
13. Optimizing Data Access Paths