Home
Home
Help
Help
Contact us
Contact Us

Oracle Database
  10g Release 2 (10.2)

WelcomeSearchBooksAdministrationApplication DevelopmentOLTPData WarehousingGrid ComputingUnstructured DataInformation IntegrationWindows

Administration

Administration involves:

  • Creating and maintaining schema objects, such as tables and indexes
  • Backup and recovery
  • Granting permissions to users
  • Performance tuning
  • Monitoring the condition of the database
  • Administering network connections
  • Administering database security

Oracle Enterprise Manager

Enterprise Manager lets you administer and monitor the database through a browser-based user interface. You can work with one or many database instances, and manage the whole software stack through the Grid Control.

Enterprise Manager Advanced Configuration HTML PDF
2 Day DBA HTML PDF
Enterprise Manager Concepts HTML PDF
Enterprise Manager Grid Control Quick Installation Guide for Linux x86 HTML PDF
Enterprise Manager Installation and Basic Configuration HTML PDF
Enterprise Manager Release Notes for Linux x86 HTML PDF
Enterprise Manager SNMP Support Reference Guide HTML PDF

Monitoring

To observe and customize database settings from SQL, you can query the data dictionary views and read or set initialization parameters for an individual session or the whole database.

High Availability

To keep your database available at all times, you can use these software components:

Advanced Replication HTML PDF
Advanced Replication Management API Reference HTML PDF
Data Guard Broker HTML PDF
Data Guard Concepts and Administration HTML PDF
High Availability Overview HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for AIX HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for hp HP-UX PA-RISC (64-Bit) HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for Microsoft Windows Platforms HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for Solaris Operating System (SPARC 64-Bit) HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux HTML PDF
Streams Advanced Queuing Java API Reference (Javadoc) HTML  
Streams Advanced Queuing User's Guide and Reference HTML PDF
Streams Concepts and Administration HTML PDF
Streams Replication Administrator's Guide HTML PDF

Data Guard

Data Guard provides a standby database for disaster recovery:

Data Guard Concepts and Administration HTML PDF
Data Guard Broker HTML PDF

Network Management

Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks:

Net Services Administrator's Guide HTML PDF
Net Services Reference HTML PDF

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:

HTTP Server Administrator's Guide HTML PDF
HTTP Server mod_plsql User's Guide HTML PDF
 

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.

Recovery Manager Quick Start Guide HTML PDF
Backup and Recovery Basics HTML PDF
Recovery Manager Reference HTML PDF
Backup and Recovery Advanced User's Guide HTML PDF

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.

In addition to the individual books for each environment, there is an online quick reference that combines all three environments.

SQL Reference HTML PDF
SQL Quick Reference HTML PDF
PL/SQL User's Guide and Reference HTML PDF
PL/SQL Packages and Types Reference HTML PDF
SQL*Plus User's Guide and Reference HTML PDF
SQL*Plus Quick Reference HTML PDF

Security

Security involves many aspects, such as network protocols, user privileges, and encryption:

Security Guide HTML PDF
Label Security Administrator's Guide HTML PDF
Advanced Security Administrator's Guide HTML PDF
Enterprise User Administrator's Guide HTML PDF

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:

Performance Tuning Guide HTML PDF

Guides

These books cover specific aspects of administering Oracle:

Administrator's Guide HTML PDF
Advanced Security Administrator's Guide HTML PDF
Data Mining Administrator's Guide HTML PDF
Enterprise User Administrator's Guide HTML PDF
Heterogeneous Connectivity Administrator's Guide HTML PDF
HTTP Server Administrator's Guide HTML PDF
Label Security Administrator's Guide HTML PDF
Net Services Administrator's Guide HTML PDF
Platform Guide for Microsoft Windows HTML PDF
Platform Guide for Microsoft Windows (64-Bit) on Intel Itanium HTML PDF
Platform Guide for Microsoft Windows (x64) HTML PDF
Streams Replication Administrator's Guide HTML PDF
Transparent Gateway for Informix Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Informix Administrator's Guide for Solaris Operating System (SPARC) HTML PDF
Transparent Gateway for Ingres II Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Ingres II Administrator's Guide for Solaris Operating System (SPARC) HTML PDF
Transparent Gateway for Microsoft SQL Server Administrator's Guide for Microsoft Windows HTML PDF
Transparent Gateway for Sybase Administrator's Guide for HP Tru64 UNIX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for IBM AIX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for Solaris Operating System (SPARC) HTML PDF
Transparent Gateway for Sybase Administrator's Guide for Windows HTML PDF
Transparent Gateway for Teradata Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Teradata Administrator's Guide for Solaris Operating System (SPARC) HTML PDF
Transparent Gateway for Teradata Administrator's Guide for Windows HTML PDF
Ultra Search Administrator's Guide HTML PDF
Workflow Administrator's Guide HTML PDF

lower border