Oracle DBA Checklists Pocket Reference: DBA Tasks and Procedures

by Quest Software

Overview

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities:

• Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and active and inactive redo logs).
• Installation and configuration. Contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. Also includes special steps for configuring a parallel database.
• Network management. Helps with installing, configuring, and testing Net8 software on server and client machines. Tasks include confirming network availability and Net8 connectivity, verifying Net8 name resolution, configuring Net8 clients (with LDAP or Oracle Names), configuring Net8 on the server, configuring the Multi-Threaded Server (MTS), tracing client connections, and tracing the Net8 listener.

This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need—and find it fast.

Product Details

ISBN-13:	9780596001223
Publisher:	O'Reilly Media, Incorporated
Publication date:	04/28/2001
Pages:	80
Product dimensions:	4.25(w) x 7.00(h) x 0.26(d)

About the Author

This pocket reference distills Oracle DBA information from one of the knowledge bases developed by RevealNet, the industry leader in knowledge-based solutions and development tools for Oracle and DB2. The goal of these knowledge bases is to fully anticipate the daily challenges of database professionals. RevealNet's code-formatting technology has become the industry standard for Oracle source code formatting. RevealNet's products help database professionals rapidly apply solutions that save hundreds of programming and research hours every year.

Table of Contents

 Introduction

 Database Management

Performing Routine DBA Procedures

Preparing a Database for Production

Performing Backup and Recovery

 Installation and Configuration

Installing Oracle on Unix

Installing Oracle on Windows NT

Installing Oracle on VMS

Creating a Parallel Oracle Database

 Network Management

Confirming Network Availability

Confirming Net8 Connectivity

Verifying Net8 Name Resolution

Configuring Net8 Clients

Configuring Net8 Clients to Use LDAP

Configuring Net8 Clients to Use Oracle Names

Configuring Net8 on the Server

Configuring Multi-Threaded Server

Tracing Client Connections

Tracing the Listener