Oracle Database Online Documentation
10g Release 2 (10.2)
Administration
Oracle Enterprise Manager
Provides a single source reference for administering Oracle Database in a small to midsize environment. If you are familiar with computers, but unfamiliar with administering Oracle Database, and your computer has four CPUs or fewer, and you do not expect to support more than 500 users, this book is appropriate for you.
High Availability
To keep your database available at all times, you can use these software components:
Describes the features and functionality of Advanced Replication. Specifically, Oracle Database Advanced Replication contains conceptual information about Advanced Replication, as well as information about planning your replication environment and troubleshooting replication problems. Oracle Database Advanced Replication also contains an introduction to the Replication Management tool in the Oracle Enterprise Manager Console.
Describes the features and functionality of the replication management API. Specifically, the Oracle Database Advanced Replication Management API Reference contains reference information for the packages in the replication management API, as well as examples of their use.
Oracle Data Guard is the most effective solution available today to protect the core asset of any enterpriseâ¿¿its data, and make it available on a 24x7 basis even in the face of disasters and other calamities. This guide describes Oracle Data Guard technology and concepts, and helps you configure and implement standby databases.
Explains how to install and configure Oracle Clusterware and Oracle Database with Oracle Real Application Clusters on Microsoft Windows clusters running Windows 2000 (32-bit) with Service Pack 1 or higher, Windows Server 2003 x64, or Windows Server 2003 for 64-bit Itanium 2 Systems.
Introduces you to Oracle's approach for a highly available database environment. It provides an overview of high availability and helps you to determine your high availability requirements. It describes the Oracle database products and features that are designed to support high availability and describes the primary database architectures that can help your business achieve high availability.
Describes the Oracle Clusterware and Real Application Clusters architectures and provides an overview of these products. This book also describes administrative and deployment topics for Oracle Clusterware and RAC.
Describes features of application development and integration using the Oracle messaging system, Advanced Queuing . Includes the PL/SQL, C, Visual Basic, Java, and JMS interfaces to AQ and gateways to non-Oracle messaging systems.
Describes the features and functionality of Streams. This document contains conceptual information about Streams, along with information about managing a Streams environment. In addition, this document contains detailed examples that configure a Streams capture and apply environment and a rule-based application.
Describes the features and functionality of Streams that can be used for data replication. This document contains conceptual information about Streams replication, along with information about configuring and managing a Streams replication environment.
Data Guard
Data Guard provides a standby database for disaster recovery:
Oracle Data Guard is the most effective solution available today to protect the core asset of any enterpriseâ¿¿its data, and make it available on a 24x7 basis even in the face of disasters and other calamities. This guide describes Oracle Data Guard technology and concepts, and helps you configure and implement standby databases.
Network Management
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks:
Oracle HTTP Server
The database includes a built-in Web server. You can build Web-based front ends to stored procedures for data entry and reporting:
Backup and Recovery
You can use Recovery Manager (RMAN) to back up and recover Oracle databases. The new Oracle Backup media management utility enables you to back up and restore any files on the file system. RMAN can also use the Oracle Backup SBT interface to back up database files to tape.
Helps you understand the features, functionality, and options available for Oracle Programs. If you have a question about your licensing needs, please contact your Oracle sales representative or refer to the resources listed in "Related Documents" for more information.
Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery.
SQL and PL/SQL
SQL is the underlying language for all database programming. PL/SQL is tightly integrated with SQL, usually for code running inside the database such as triggers, stored procedures and functions, and PL/SQL packages. SQL*Plus is the command-line tool for running SQL and compiling PL/SQL.
Describes conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; and view and create reports.
Contains a complete description of the Structured Query Language used to manage information in an Oracle Database. Oracle SQL is a superset of the American National Standards Institute and the International Standards Organization SQL:1999 standard.
Contains a high-level description of the Structured Query Language used to manage information in an Oracle database. Oracle SQL is a superset of the American National Standards Institute and the International Standards Organization standard.
Security
Security involves many aspects, such as network protocols, user privileges, and encryption:
Oracle Label Security enables access control to reach specific rows of a database. With Oracle Label Security in place, users with varying privilege levels automatically have (or are excluded from) the right to see or alter labeled rows of data.
Provides an overview and detailed configuration information about database advanced security features. These features include network encryption, strong authentication (RADIUS, Kerberos, and SSL), and centralized user management that uses the Oracle Identity Management infrastructure (Enterprise User Security). The audience for this guide includes network security and enterprise user security administrators.
Provides a comprehensive overview of security for Oracle Database. It includes conceptual information about security requirements and threats, descriptions of Oracle Database security features, and procedural information that explains how to use those features to secure your database. This version updated to address security bug 5929834 and bug fix 7565177.
Performance
Oracle Database 10g includes many automated performance features, which you access through Oracle Enterprise Manager. You can also learn about and use detailed performance features, such as indexes, hints, and performance-related views in the data dictionary:
Guides
These books cover specific aspects of administering Oracle:
Provides an overview and detailed configuration information about database advanced security features. These features include network encryption, strong authentication (RADIUS, Kerberos, and SSL), and centralized user management that uses the Oracle Identity Management infrastructure (Enterprise User Security). The audience for this guide includes network security and enterprise user security administrators.
Explains how to install the various components of Oracle Data Mining and perform basic administration tasks.
Download As...
PDF for offline viewing
Describes Oracle's approach for information integration in a heterogeneous environment. Specifically, it describes Oracle Transparent Gateways and Generic Connectivity and is meant to be an administrator's guide for these Oracle products.
Oracle Label Security enables access control to reach specific rows of a database. With Oracle Label Security in place, users with varying privilege levels automatically have (or are excluded from) the right to see or alter labeled rows of data.
Describes the features and functionality of Streams that can be used for data replication. This document contains conceptual information about Streams replication, along with information about configuring and managing a Streams replication environment.
Describes the Oracle Transparent Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Ingres II, which enables Oracle client applications to access Ingres II data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Ingres II, which enables Oracle client applications to access Ingres II data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Microsoft SQL Server, which enables Oracle client applications to access Microsoft SQL Server data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.