Oracle Database 21c
Books
Browse the Oracle Database 21c bookshelf below for a particular title, or download a zip file containing all the books.
2 Day + Java Developer's Guide
HTML
PDF
Guides application developers on how to use Java to access and modify data in Oracle Database.
2 Day + Performance Tuning Guide
HTML
PDF
Explains how to perform day-to-day database performance tuning tasks using features provided by Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager Cloud Control.
2 Day Developer's Guide
HTML
PDF
An introduction to application development for developers who are new to Oracle Database. Explains general concepts behind development with Oracle Database, introduces basic features of SQL and PL/SQL, provides references to in-depth information elsewhere in Oracle Database library, and shows how to create a simple application.
Advanced Security Guide
HTML
PDF
Explains how to configure and use Oracle Database Advanced Security Transparent Data Encryption (TDE) and Oracle Data Redaction.
Automatic Storage Management Administrator's Guide
HTML
PDF
Describes how to administer Oracle Automatic Storage Management (Oracle ASM) for Oracle Database.
Automatic Storage Management Cluster File System Administrator's Guide
HTML
PDF
Describes how to administer Oracle Automatic Storage Management Cluster File System (Oracle ACFS) for Oracle Database.
Autonomous Health Framework User’s Guide
HTML
PDF
This book describes how to use Oracle Autonomous Health Framework diagnostic components - Oracle ORAchk, Cluster Health Monitor, Oracle Trace File Analyzer Collector, Oracle Cluster Health Advisor, Memory Guard, and Hang Manager.
Clusterware Administration and Deployment Guide
HTML
PDF
The Oracle Clusterware Administration and Deployment Guide describes the Oracle Clusterware architecture and provides an overview of this product. This book also describes administrative and deployment topics for Oracle Clusterware.
Data Cartridge Developer's Guide
HTML
PDF
Describes how to implement custom indexing and query optimization services and how to package and use these as a server extension called a data cartridge.
Data Guard Broker
HTML
PDF
Describes the Oracle Data Guard broker, a management and monitoring interface that automates many of the tasks involved in configuring and monitoring standby databases in an Oracle Data Guard configuration.
Data Guard Concepts and Administration
HTML
PDF
Provides a comprehensive overview of Oracle Data Guard concepts and describes how to configure and implement standby databases that can take over production operations if your production database becomes unusable. This guide includes several database scenarios such as creating, recovering, failing over, switching over, configuring, and backing up standby and primary databases.
Data Provider for .NET Developer's Guide
HTML
PDF
Describes provider-specific features and properties of ODP.NET. Oracle Data Provider for .NET is an implementation of Microsoft's ADO.NET interface and provides access to Oracle databases.
Database Administrator's Guide
HTML
PDF
Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing.
Database Advanced Queuing Java API Reference
HTML
Describes the Java APIs for application development and integration using the Oracle messaging system, Advanced Queuing.
Database Backup and Recovery Reference
HTML
PDF
Provides detailed descriptions of the Recovery Manager (RMAN) commands and recovery catalog views.
Database Backup and Recovery User's Guide
HTML
PDF
Explains how to use Recovery Manager (RMAN) to back up, recover, and duplicate a database, and how to use Oracle Flashback Technology to restore all or a portion of your data to a previous state.
Database Client Installation Guide for Linux
HTML
PDF
Describes how to install and configure Oracle Database client on Linux.
Database Concepts
HTML
PDF
Describes Oracle Database architecture and essential topics for database administrators and developers.
Database Data Warehousing Guide
HTML
PDF
Provides conceptual, reference, and implementation material for using Oracle Database in data warehousing. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques.
Database Development Guide
HTML
PDF
Describes various features that are available in the Oracle database and how to use them in real time applications.
Database Error Messages
HTML
PDF
Describes error messages that may appear while using products that are part of Oracle Database.
Database Examples Installation Guide
HTML
PDF
Describes how to install and configure the products available on the Oracle Database Examples installation media.
Database Gateway for APPC Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64
HTML
PDF
Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.
Database Gateway for APPC Installation and Configuration Guide for Microsoft Windows
HTML
PDF
Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.
Database Gateway for APPC User's Guide
HTML
PDF
Provides Oracle applications seamless access to virtually any APPC-enabled system, including IBM mainframe data and services through Remote Procedure Call (RPC) processing.
Database Gateway for Informix User's Guide
HTML
PDF
Describes the Oracle Database Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language (SQL).
Database Gateway for ODBC User's Guide
HTML
PDF
Describes the Oracle Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL).
Database Gateway for SQL Server User's Guide
HTML
PDF
Describes the Oracle Database Gateway for SQL Server, which enables Oracle client applications to access SQL Server data through Structured Query Language (SQL).
Database Gateway for Sybase User's Guide
HTML
PDF
Describes the Oracle Database Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language (SQL).
Database Gateway for Teradata User's Guide
HTML
PDF
Describes the Oracle Database Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language (SQL).
Database Gateway for WebSphere MQ Installation and User's Guide
HTML
PDF
Provides access to WebSphere MQ services. This gateway requires a system that is capable of running 64-bit applications.
Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64
HTML
PDF
Provides Oracle Database Gateway installation and configuration information.
Database Gateway Installation and Configuration Guide for Microsoft Windows
HTML
PDF
Describes how to install Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on Microsoft Windows (32-bit) and Microsoft Windows (64-bit) platform.
Database Globalization Development Kit Java API Reference
HTML
Describes Java APIs for Oracle Database Globalization Development Kit (GDK)
Database Globalization Support Guide
HTML
PDF
Describes Oracle globalization support for the database. Explains how to set up a globalization support environment, choose and migrate a character set, customize locale data, do linguistic sorting, program in a global environment, and program with Unicode.
Database In-Memory Guide
HTML
PDF
Describes the architecture, configuration, and administration of the In-Memory Column Store
Database Installation Guide for Linux
HTML
PDF
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Linux.
Database Licensing Information User Manual
HTML
PDF
Describes Oracle Database licensing. If you have a question about your licensing needs, contact your Oracle sales representative.
Database Net Services Administrator's Guide
HTML
PDF
Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
Database Net Services Reference
HTML
PDF
Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.
Database Performance Tuning Guide
HTML
PDF
Provides information about how to tune the performance of Oracle Database using Oracle performance tools.
Database PL/SQL Language Reference
HTML
PDF
Presents PL/SQL, the Oracle procedural extension of SQL, an advanced fourth-generation programming language. Explains the concepts behind PL/SQL and illustrates every facet of the language.
Database PL/SQL Packages and Types Reference
HTML
PDF
Describes the PL/SQL packages provided with the Oracle database server that extend database functionality and provide PL/SQL access to SQL features.
Database Reference
HTML
PDF
Provides reference information about database initialization parameters, static data dictionary views, and dynamic performance views that are part of Oracle Database.
Database Release Notes
HTML
PDF
Contains information about new features, changes, unsupported products, preinstallation requirements, generic and platform-specific bug fixes, and known issues that are not included in the Oracle Database Documentation Library.
Database Sample Schemas
HTML
PDF
Sample schemas provide a common platform for examples in each release of the Oracle Database. The sample schemas are a set of interlinked database schemas.
Database Security Assessment Tool Release Notes
HTML
PDF
These release notes list the new features for this release of Database Security Assessment Tool (DBSAT), how to download the latest product software and documentation, and how to address known issues in DBSAT.
Database Security Assessment Tool User Guide
HTML
PDF
Analyzes database configurations, users, their entitlements, security policies and identifies where sensitive data resides to uncover security risks and improve the security posture of Oracle Databases within your organization.
Database Security Guide
HTML
PDF
Explains how to configure an Oracle database to use the default security features
Database Transactional Event Queues and Advanced Queuing User's Guide
HTML
PDF
Describes features of application development and integration using Oracle Database Transactional Event Queues (TEQ) and Advanced Queuing (AQ). This information applies to versions of the Oracle Database server that run on all platforms, unless otherwise specified.
Database Transactional Event Queues Java API Reference
HTML
Describes the client-side Kafka Java APIs for the Oracle messaging system, Transactional Event Queues (TEQ).
Database Vault Administrator's Guide
HTML
PDF
Describes how to register and administer Oracle Database Vault
Fleet Patching and Provisioning Administrator's Guide
HTML
PDF
This guide describes Oracle Fleet Patching and Provisioning, a software lifecycle management method for provisioning and maintaining Oracle homes.
Global Data Services Concepts and Administration Guide
HTML
PDF
Provides dynamic load balancing, failover, and centralized service management for a set of replicated databases that offer common services.
Graph Developer's Guide for Property Graph
HTML
Graph Developer's Guide for RDF Graph
HTML
PDF
Provides usage and reference information about Oracle Database support for semantic technologies, including storage, inference, and query capabilities for data and ontologies based on Resource Description Framework (RDF), RDF Schema (RDFS), and Web Ontology Language (OWL).
Graph Java API Reference for Property Graph (Javadoc)
HTML
Graph Python API Reference for Property Graph
HTML
Grid Infrastructure Installation and Upgrade Guide for Linux
HTML
PDF
Describes how to install and upgrade grid infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Linux.
Heterogeneous Connectivity User's Guide
HTML
PDF
Describes Oracle's approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is a user's guide for these Oracle products.
High Availability Overview and Best Practices
HTML
PDF
Presents Oracle best practices for deploying a highly available environment, helps you determine your availability requirements, and describes the database architectures that can help your business achieve high availability.
Java Developer's Guide
HTML
PDF
Describes how to develop, load, and run Java applications in Oracle Database.
JDBC Developer's Guide
HTML
PDF
Describes how to use Oracle JDBC drivers to develop powerful Java database applications.
JSON Developer's Guide
HTML
PDF
This manual describes the use of JSON data that is stored in Oracle Database. It covers how to store, generate, view, manipulate, manage, search, and index it.
Label Security Administrator's Guide
HTML
PDF
Describes how to register and administer Oracle Label Security
Multitenant Administrator's Guide
HTML
PDF
Describes how to create and configure multitenant container databases (CDBs), pluggable databases (PDBs), and application containers.
Object-Relational Developer's Guide
HTML
PDF
Explains how to use the object-relational features of Oracle Database.
ODBC Driver Release Notes
HTML
PDF
Describes Oracle Database ODBC driver new features, functionality, platforms supported, software required, server requirements, hardware required, testing matrix, UNIX platform certification matrix, post-installation, known issues, and software problems fixed.
OLAP DML Reference
HTML
PDF
Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.
OLAP Expression Syntax Reference
HTML
PDF
Describes the Oracle OLAP expression syntax used to generate information-rich content from the data stored in dimensional database objects such as cubes and cube dimensions.
OLAP Java API Developer's Guide
HTML
PDF
Provides guidance for developing client applications using the Oracle OLAP Java API.
OLAP User's Guide
HTML
PDF
Explains how SQL applications can extend their analytic processing capabilities and manage summary data by using the OLAP option of Oracle Database.
Oracle C++ Call Interface Programmer's Guide
HTML
PDF
Presents the Oracle C++ Call Interface, an application program interface that enables applications written in C++ to interact with one or more Oracle databases. To extend the functionality of code generated by the Object Type Translator, programmers may want to add code in the OTT-generated file. The OTT can distinguish between OTT-generated code and user-generated code by looking for some predefined markers (tags).
Oracle Call Interface Programmer's Guide
HTML
PDF
Describes the Oracle Call Interface (OCI) which is an application programming interface (API) that allows applications written in C or C++ to interact with Oracle Database.
Oracle Database Upgrade Guide
HTML
PDF
Guides you through the process of planning and performing upgrades for Oracle Database. This book also provides information about compatibility, upgrading applications, and changes in the new release that affect upgrading Oracle Database.
Oracle Database Utilities
HTML
PDF
Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The topics discussed include Data Pump Export, Data Pump Import, SQL*Loader, external tables and associated access drivers, the Automatic Diagnostic Repository Command Interpreter (ADRCI), DBVERIFY, DBNEWID, LogMiner, the Metadata API, original Export, and original Import.
Oracle Machine Learning for R Installation and Administration Guide
HTML
PDF
Provides instructions for installing and administering Oracle Machine Learning for R.
Oracle Machine Learning for R Licensing Information User Manual
HTML
PDF
Identifies the required notices for open source or other separately licensed software products or components distributed with Oracle Machine Learning for R along with the applicable licensing information.
Oracle Machine Learning for R Release Notes
HTML
PDF
Provides key information about the current release of Oracle Machine Learning R, including new features, requirements, and bugs that have been fixed.
Oracle Machine Learning for R User's Guide
HTML
PDF
Explains how to use the R language and Oracle Machine Learning for R packages to perform statistical analysis on data in an Oracle database.
Oracle Machine Learning for SQL API Guide
HTML
PDF
Provides reference information on Oracle Machine Learning for SQL - Introduction, Using API, Oracle Machine Learning for SQL API reference
Oracle Machine Learning for SQL Concepts
HTML
PDF
Discusses the basic concepts underlying Oracle Machine Learning for SQL. Includes an overview of the features of Oracle Machine Learning for SQL and information about mining functions and algorithms.
Oracle Machine Learning for SQL User's Guide
HTML
PDF
Explains how to use the SQL interface to Oracle Machine Learning to create models and score data. This guide also addresses administrative issues such as security, import/export, and upgrade for Oracle Machine Learning for SQL.
Oracle® Database JDBC Java API Reference
HTML
Provides Java API reference for Java Database connectivity.
Oracle® Database RAC FAN Events Java API Reference
HTML
Provides easy access to Oracle Fast Application Notification (FAN) events.
Oracle® Database Reactive Streams Ingestion Library Java API Reference
HTML
Provides Java API reference for Reactive Streams Ingestion Library that enables efficient data streaming into Oracle Database in a nonblocking way.
Oracle® Database Real Application Security Java API Reference
HTML
Documents two Java packages: - oracle.security.xs contains the APIs for using lightweight user sessions - oracle.security.xs.admin contains the APIs for administering lightweight user session.
Oracle® Database Real Application Security Session Service Java API Reference
HTML
Documents one Java package: - oracle.security.xs.ee.session contains the APIs for using an application session service.
Oracle® Universal Connection Pool Java API Reference
HTML
Provides Java API reference for Universal Connection Pool for JDBC.
Pro*C/C++ Programmer's Guide
HTML
PDF
Describes how to develop C++ programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data.
Pro*C/C++ Release Notes
HTML
PDF
Contains important information not included in the Pro*C/C++ Programmer's Guide.
Pro*COBOL Programmer's Guide
HTML
PDF
Describes how to develop COBOL programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data.
Pro*COBOL Release Notes
HTML
PDF
Contains important information not included in the Pro*COBOL Programmer's Guide.
Pro*FORTRAN Supplement to the Oracle Precompilers
HTML
PDF
Supplements the Oracle Database Programmer's Guide to the Oracle precompilers to provide additional information on how to develop FORTRAN programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data.
Programmer's Guide to the Oracle Precompilers
HTML
PDF
Describes how to develop applications using the Oracle precompilers and the SQL and PL/SQL database languages to access and manipulate Oracle data.
Provider for DRDA User's Guide
HTML
PDF
For customers who have a large investment in DB2-based applications, this document describes how to migrate to Oracle Database while keeping these applications largely unchanged.
Real Application Clusters Administration and Deployment Guide
HTML
PDF
Describes the Oracle Real Application Clusters (Oracle RAC) architecture and provides an overview of this product, including Oracle Real Application Clusters One Node (Oracle RAC One Node).
Real Application Clusters Installation Guide for Linux and UNIX
HTML
PDF
Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Real Application Security Administration Console (RASADM) User's Guide
HTML
PDF
Provides a graphical user interface (RASADM) that security administrators and developers using Real Application Security can use to develop end-to-end security for mid-tier applications. The RASADM application allows users to develop declarative data security policies to enforce access control requirements at the database layer to protect data at both the row and column levels. This approach allows developers to control application user access to data in Oracle database throughout all components of an Oracle enterprise in a common manner.
Real Application Security Administrator's and Developer's Guide
HTML
PDF
Describes how to implement Real Application Security on the database. Real Application Security is a new feature in Oracle Database 12c. Real Application Security is a database authorization model that enables end-to-end security for multitier applications. It provides an integrated solution to securing the database and application user communities. Also, it advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet.
REST API for Fleet Patching and Provisioning
HTML
Provides users the ability to perform Fleet Provisioning, Patching and Upgrades for Oracle Databases and Oracle Grid Infrastructure through REST APIs.
Fleet Patching and Provisioning was known in prior releases as Rapid Home Provisioning. Oracle continues to use "Rapid Home Provisioning" and "rhp" for some descriptions of REST APIs and in directory paths and URLs.
REST API for Spatial Network Data Model Contraction Hierarchies
HTML
Spatial Network Data Model Contraction Hierarchies REST API
REST APIs for Clusterware
HTML
The REST APIs for Oracle Clusterware enable you to remotely execute commands on your cluster, whether in the Oracle Cloud, at remote physical locations, or locally provisioned. With the remote execution of REST interface commands, you can retrieve information about that execution, including output, error codes, and execution duration. In some cases, a command generates a file as output. In such cases, the REST interface also provides a Uniform Resource Identifier (URI) through which the file can be retrieved.
The REST interface provides secure support for Oracle Clusterware CLUVFY, CRSCTL, and SRVCTL command line interfaces (CLIs).
REST APIs for Oracle Database
HTML
Provide consumers the ability to perform operations with different Oracle Database features through a web REST API that can be easily adopted.
SecureFiles and Large Objects Developer's Guide
HTML
PDF
This guide explains what are Large Objects(LOBs), different types of LOBs, their usage and utilities, configuring LOBs, and how to use the LOBs in real time applications.
Spatial Developer's Guide
HTML
PDF
Provides usage and reference information for indexing and storing spatial data and for developing spatial applications using Oracle Spatial.
Spatial GeoRaster Developer's Guide
HTML
PDF
Provides usage and reference information for the GeoRaster feature of Oracle Spatial, which lets you store, index, query, analyze, and deliver raster data (raster image and gridded data and its associated metadata).
Spatial Java API Reference
HTML
Provides Javadoc-generated information about interfaces and classes that support features available with Oracle Spatial, including GeoRaster, the Topology and Network Data Model features, the location tracking server, and the map visualization component (formerly called MapViewer).
Spatial Map Visualization Developer's Guide
HTML
PDF
Describes how to use the Oracle Spatial map visualization component, which renders maps showing different kinds of spatial data. It is intended primarily for programmers who develop applications that require maps to be drawn.
Spatial Map Visualization Oracle Maps HTML5 JavaScript API Reference
HTML
Provides JSdoc-generated reference information for the Oracle Spatial Map Visualization Component (formerly called MapViewer) Oracle Maps HTML5 JavaScript API.
Spatial Topology and Network Data Model Developer's Guide
HTML
PDF
Provides usage and reference information about the Topology and Network Data Model features of Oracle Spatial.
SQL Language Quick Reference
HTML
PDF
Contains a high-level text description of the SQL syntax used to manage information in Oracle Database.
SQL Language Reference
HTML
PDF
Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database.
SQL Translation and Migration Guide
HTML
PDF
Describes the installation, configuration, and administration tasks for all activities related to migrating applications to Oracle Database from other databases, including DB2, MySQL, and Sybase.
SQL Tuning Guide
HTML
PDF
Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals.
SQL*Plus Release Notes
HTML
PDF
Contains important information not included in the SQL*Plus User's Guide and Reference.
SQL*Plus User's Guide and Reference
HTML
PDF
Contains a complete description of the SQL*Plus command-line interface to Oracle Database, and a complete reference to SQL*Plus commands and syntax.
SQLJ Developer's Guide
HTML
PDF
Provides guidance to developers on SQLJ programming. This document can be read by anyone with an interest in SQLJ programming, but assumes at least some prior knowledge of Java, SQLJ, PL/SQL, and Oracle database.
Testing Guide
HTML
PDF
Provides information about how to assure the integrity of database changes and manage test data using Oracle Real Application Testing.
Text Application Developer's Guide
HTML
PDF
Provides information for building applications with Oracle Text.
Universal Connection Pool Developer's Guide
HTML
PDF
Provides instructions for using Oracle Universal Connection Pooling API.
Upgrading Oracle Restart for Linux and Unix-Based Operating Systems
HTML
PDF
Describes how to upgrade, patch, and downgrade Oracle Grid Infrastructure for a Standalone Server (Oracle Restart) on systems running Linux and UNIX.
VLDB and Partitioning Guide
HTML
PDF
Contains an overview of very large database (VLDB) topics, with emphasis on partitioning and parallel execution as a key component of the VLDB strategy.
Workspace Manager Developer's Guide
HTML
PDF
Provides usage and reference information about Oracle Workspace Manager, which enables applications to create workspaces and to group different versions of table row values in different workspaces.
XML C API Reference
HTML
PDF
Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C programming language. It primarily lists the syntax of functions, methods, and procedures associated with these APIs.
XML C++ API Reference
HTML
PDF
Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C++ programming language. This manual primarily lists the syntax of functions, methods, and procedures associated with these APIs.
XML DB Developer's Guide
HTML
PDF
This manual describes Oracle XML DB. It includes guidelines and examples for storing, generating, accessing, searching, validating, transforming, evolving, and indexing XML data in Oracle Database.