Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Introduction to Installing Oracle Parallel Server

1 Introduction to the Installation and Configuration Process

Introduction to Oracle Parallel Server

Oracle Parallel Server Software Components

Operating System Dependent Layer

Installation Overview

Database Configuration Overview

Selecting a Database Creation Method

Using Oracle Database Configuration Assistant

Advantages of Using Oracle Database Configuration Assistant

Identifying Your Database Environment

Selecting a Database Creation Method

Looking at a Database Created by Oracle Database Configuration Assistant

Using Manual Methods

Part II Installing and Configuring Oracle Parallel Server

2 Pre-Installation

System Installation Requirements

Hardware and Software Requirements for Oracle8i Parallel Server Nodes

Hardware and Software Requirements for Oracle Enterprise Manager

Shared Disk Subsystem

Setting Up Raw Devices

UNIX

Windows NT

Pre-Installation Steps

3 Installing and Creating an Oracle Parallel Server Database

Installation Types

Installation Procedure

Typical Installation

Custom Installation

Net8 Configuration Assistant During Installation

Oracle Database Configuration Assistant During Installation

Understanding the Installed Configuration

Optimal Flexible Architecture

Operating-System Specific Configuration

Initialization Parameter Files (initsid.ora and initdb_name.ora files)

Listener (listener.ora file)

Directory Server Access (ldap.ora file)

Net Service Names (tnsnames.ora file)

Profile (sqlnet.ora file)

Migrating or Upgrading to Release 8.1

Coexistence

Rolling Upgrades

Multiple Oracle Homes

Creating the Database After Installation

Use Oracle Database Configuration Assistant in Stand-Alone Mode

Use Manual Methods

Starting the Database in Parallel Mode

Verifying Instances Are Running

Deleting the Database

4 Additional Configuration Issues

Configuring Clients for Oracle Parallel Server

Implementation

Testing Net8 Configuration

Understanding the Initialization Parameter Files

Purpose of initsid.ora

Purpose of initdb_name.ora

Configuring Recovery Manager for Backup and Recovery

Configuring Directories for RMAN

Configuring the Archiver to Write to Multiple Log Destinations

Making a Consistent Backup

5 Configuring High-Availability Features

Transparent Application Failover

Primary and Secondary Instances

Overview

Initialization File Configuration

Client Configuration

Listener Configuration

Connecting to Secondary Instances

Part III Installing and Using Oracle Parallel Server Management

6 Installing and Configuring Oracle Parallel Server Management

Oracle Parallel Server Management Architecture

Oracle Parallel Server Management Requirements

Understanding Oracle Enterprise Manager Setup

Installing Oracle Enterprise Manager

Configuring Oracle Enterprise Manager

Task 1: Configure Repository

Task 2: Start Oracle Enterprise Manager Components

Task 3: Discover Nodes

Task 4: Specify Preferred Credentials for Nodes and Oracle Parallel Server Database

Configuring Oracle Performance Manager

Task 1: Start Oracle Performance Manager Components

Task 2: Accessing Oracle Parallel Server Charts

Additional Notes for DBA Studio

7 Administering Oracle Parallel Server with Oracle Parallel Server Management

Overview

Starting the Console

Displaying Oracle Parallel Server Objects in the Navigator Window

Using the Right-Mouse Menu

Starting an Oracle Parallel Server Database

Shutting Down an Oracle Parallel Server Database

Viewing the Parallel Server Operation Results

Status Details Tab

Output Tab

Viewing Oracle Parallel Server Status

General Tab

Status Details Tab

Creating a Job for a Parallel Server or Parallel Server Instance

Specifying Job Details

General Tab

Tasks Tab

Parameters Tab

Parameters for the Parallel Server Shutdown Task

8 Monitoring Performance with Oracle Performance Manager

Oracle Performance Manager Overview

Starting Oracle Performance Manager

Displaying Charts

Parallel Server Block Ping Chart

Parallel Server Data Block Ping by Tablespace Chart

Parallel Server Data Block Ping by Instance Chart

Parallel Server File I/O Rate Chart

Parallel Server File I/O Rate by Object Chart

Parallel Server File I/O Rate by Instance Chart

Parallel Server Lock Activity Chart

Parallel Server Sessions Chart

Parallel Server Users Logged On Chart

Parallel Server Users Logged On by Instance Chart

Parallel Server Active Users Chart

Parallel Server Active Users by Instance Chart

OPS Overview Chart

Part IV Adding Instances and Nodes

9 Adding Instances and Nodes

Moving from a Single Instance to Parallel Server

Deciding to Convert

Preparing to Convert

Converting the Database from Single- to Multi-instance

Adding Additional Nodes to a Cluster

Part V Reference

A Directory Structure

Understanding the Oracle Parallel Server Directory Structure

UNIX

Windows NT

B Oracle Parallel Server Management on UNIX Reference

OPSCTL Utility

Creating the db_name.conf File

Parameter Syntax

Parameter Expansion

Parameter Descriptions

Parameter Node Overrides

Oracle Parallel Server Instances

Listeners

Sample of db_name.conf File

Oracle Intelligent Agent Configuration

Non-shared Oracle Home

Shared Oracle Home

C Troubleshooting

Resolving Service Discovery Failures

Understanding Discovery

Discovery Results

Troubleshooting Discovery

Using Trace Files

Background Thread Trace Files

User Thread Trace Files

Alert File

Error Call Trace Stack

Contacting Oracle Worldwide Customer Support

Severe Errors

Glossary

Index