Graphic for Getting Started page

Oracle Database 12c Release 2

Administration

Give us your thoughts!

Get Started

2 Day DBA
Provides a single source reference for administering Oracle Database in a small to midsize environment, using the graphical user interface of Oracle Enterprise Manager Database Express. 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.
Open As...

PDF for offline viewing

2 Day + Security Guide
Provides an introduction to securing an Oracle database using the default security features, such as how to secure the database installation and configuration or manage encryption. It includes beginning level tutorials for creating secure application roles, Oracle Database Vault policies, Oracle Virtual Private Database policies, Oracle Data Redaction policies, Oracle Label Security policies, and unified auditing policies.
Open As...

PDF for offline viewing

2 Day + Performance Tuning Guide
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.
Open As...

PDF for offline viewing

SQL and PL/SQL

SQL and PL/SQL are fundamental to all Oracle application development. SQL is the language used to query and modify Oracle databases. PL/SQL is used to create and call triggers, stored procedures and functions, and PL/SQL packages. Other programming technologies depend upon SQL and PL/SQL to interact with the Oracle Database server.

SQL Language Reference
Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database.
Open As...

PDF for offline viewing

SQL Language Quick Reference
Contains a high-level text description of the SQL syntax used to manage information in Oracle Database.
Open As...

PDF for offline viewing

PL/SQL Language Reference
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.
Open As...

PDF for offline viewing

PL/SQL Packages and Types Reference
No summary available.
Open As...

PDF for offline viewing

Development Guide
Provides usage information for developers (all experience levels) of databases and database applications.
Open As...

PDF for offline viewing

Clients for Database Administration

Oracle SQL Developer is a powerful easy-to-use GUI with browse, create, edit, and drag-and-drop capabilities for managing database objects, and creating and viewing reports. SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer has all the capabilities of SQL*Plus in a GUI-based interface.

SQL*Plus Release Notes
Contains important information not included in the SQL*Plus User's Guide and Reference.
Open As...

PDF for offline viewing

SQL*Plus User's Guide and Reference
Contains a complete description of the SQL*Plus command-line interface to Oracle Database, and a complete reference to SQL*Plus commands and syntax.
Open As...

PDF for offline viewing

SQL*Plus Quick Reference
Contains a complete list of SQL*Plus command syntax.
Open As...

PDF for offline viewing

Network Management

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

Net Services Reference
Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.
Open As...

PDF for offline viewing

Net Services Administrator's Guide
Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
Open As...

PDF for offline viewing

Storage

Using Automatic Storage Management for Oracle databases.

Automatic Storage Management Administrator's Guide
Describes how to administer Oracle Automatic Storage Management (Oracle ASM) for Oracle Database.
Open As...

PDF for offline viewing

Backup and Recovery

Enhance database availability using the full range of backup and recovery capabilities of the Oracle database, such as Recovery Manager and the flashback features.

Backup and Recovery User's Guide
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.
Open As...

PDF for offline viewing

Backup and Recovery Reference
Provides detailed descriptions of the Recovery Manager (RMAN) commands and recovery catalog views.
Open As...

PDF for offline viewing

UNIX and Windows Database Administration

Administration concepts and tasks specific to the Oracle Database on a specific operating system.

Administrator's Reference for Linux and UNIX-Based Operating Systems
Explains how to configure and manage Oracle Database on Linux and UNIX-based operating systems.
Open As...

PDF for offline viewing

Platform Guide for Microsoft Windows
Provides platform-specific information for configuring and using Oracle Database software on the Windows platform. Topics discussed include: architecture, services, tools, configuration, administration, tuning, backup, accounts, passwords, user authentication, registry parameters, and application development.
Open As...

PDF for offline viewing

Testing

Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.

Testing Guide
Provides information about how to assure the integrity of database changes and manage test data using Oracle Real Application Testing.
Open As...

PDF for offline viewing