oracle_dba_checklists_pocket_reference.pdf

Oracle DBA Checklists

Pocket Reference

Beijing• Cambridge• Farnham• Köln• Paris• Sebastopol• Taipei• Tokyo

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

Oracle DBA Checklists

Pocket Reference

Introduction

The purpose of the Oracle DBA Checklists Pocket Reference is

to help Oracle DBAs quickly look up the procedures they’ll

need to follow when performing key Oracle data- base

administration tasks.

This book is divided into three major sections covering the

three main areas of an Oracle DBA’s responsibilities: data-

base management, installation and configuration, and

network management. While we can’t possibly cover every

DBA task in this concise reference, we’ve highlighted the most

important tasks within each of these three fundamen- tal areas.

The information presented here should be helpful

to both new and experienced DBAs.

Each section takes a “cookbook” or checklist-style approach

to presenting the material. Our goal is to make the most

important DBA information as accessible as it can be so you’ll

be able to use it most effectively in your daily work. While

we’ve designed the steps to be easy to follow, please

note that this book is not a self-contained user guide; basic

knowledge of Oracle, SQL, and SQL*Plus is assumed. You

will need to refer to Oracle documentation and other third-

party books for detailed information. In addition, every

Oracle site has its own special procedures. You’ll need to

supplement the procedures described in this book and in the

Oracle documentation with your own site’s procedures.

Conventions

The following typographical conventions are used in this

book:

Italic

Used for filenames, directory names, and URLs

Constant width

Used for code examples and the output of commands

Constant width italic

Indicates that the item (e.g., a filename) is to be replaced

by a user-specified value

Constant width bold

Indicates user input in code examples

UPPERCASE

In syntax descriptions, usually indicates keywords

lowercase

In syntax descriptions, usually indicates user-defined items

such as variables

[ ] In syntax descriptions, enclose optional items

NOTE

Before Oracle8 i , Oracle commands were typically issued

from Server Manager ( srvmgrl ). Starting with Oracle8 i , Ora-

cle recommends that you issue commands from SQL*Plus. In

most cases, however, issuing these commands from Server

Manager will still work.

Acknowledgments

The information contained in this pocket reference is

extracted from the RevealNet Knowledge Base for Oracle

Administration. Special thanks go to the following Knowl-

edge Base authors whose expertise was used in the

development of this book:

Oracle DBA Checklists Pocket Reference

Michael R. Ault is an OCP-certified Oracle7, Oracle8, and

Oracle8 i DBA with over 15 years of experience. He has

participated in the Oracle8 and Oracle8 i beta programs. Mike

is the author of Oracle8i Administration and Manage- ment

( John Wiley & Sons) as well as several other Oracle books and

numerous articles on Oracle. He is a partner in

The DBAGroup LLC, a consulting firm providing DBA and

training services on Oracle projects. He is also the Sysop for

the RevealNet DBA Pipeline ( http://www.revealnet.com ). He

is a frequent contributor to DBMS , Oracle , DBPD , and other

magazines, as well as a frequent presenter at Oracle Open World,

IOUG-A, and ECO.

Thomas B. Cox is a former Oracle employee and author of the

Oracle Workgroup Server Handbook (Oracle Press), as well as

the Low Administration Oracle Specification , the Oracle DBA

Checklist , the DBA Maturity Model , and many other white

papers and articles. He now works for

PricewaterhouseCoopers.

Jonathan Gennick is an Oracle Certified Professional and

writer. Jonathan has written or coauthored a number of Oracle

books, including Oracle SQL*Plus: The Definitive Guide

(O’Reilly), Oracle Net8 Configuration and Trouble- shooting

(O’Reilly), and Oracle SQL*Loader: The Definitive Guide

(O’Reilly). He recently joined O’Reilly as an associ- ate editor

specializing in Oracle books.

Jim Lopatosky is an Information Technology Consultant for

the Maine State Government’s Bureau of Information Services

(Augusta, ME), specializing in Oracle database administration.

Jim has been involved actively with Oracle User Groups. He

took office as President of the Northeast Oracle Users Group

(NOUG) in October of 1999. Previously

he founded, and presided for three years over, Maine’s Oracle

Users Group (MSOUG).

Hugo Toledo is Director of Engineering at DaVinci Soft-

ware in Chicago. Hugo has worked extensively with

Introduction

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: