Oracle 11g For Dummies

by Zeis, Chris; Ruel, Chris; Wessler, Michael

• ISBN13: 9780470277652
• ISBN10: 0470277653
• Edition: 1st
• Format: Paperback
• Copyright: 2009-01-14
• Publisher: For Dummies

Summary

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you'll be glad to have Oracle 11g For Dummies in your cubicle.This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You'll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle's physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal moreCompletely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Author Biography

Chris Zeis is Chief Technology Officer and partner at Perpetual Technologies, Inc., an Oracle partner. Chris Ruel is an Oracle database administrator and consultant. Michael Wessler manages multiple Web applications for the Department of Defense and consults at various government and private agencies.

Table of Contents

Introduction

You Don't Have to Go to Delphi to Know Oracle

A Pragmatic Introduction to Oracle

Understanding Oracle Database Architecture

Preparing to Implement Oracle in the Real World

Implementing Oracle on Your Own

Creating an Oracle Database

Connecting to and Using an Oracle Database

Speaking the SQL Language

Populating the Database

Caring for an Oracle Database

Protecting Your Oracle Database

Protecting Your Oracle Data

Keeping the Database Running

Tuning an Oracle Database

Troubleshooting an Oracle Database

Monitoring and Managing with Enterprise Manager

Inspecting Advanced Oracle Technologies

Flashing Back and Replaying: Advanced Features

Using High-Availability Options

The Part of Tens

Top Ten Oracle Installation Do's

Top Ten Database Design Do's

Quick Start Install of Oracle 11g on Linux

Index

Table of Contents provided by Publisher. All Rights Reserved.