Contents

Title and Copyright Information

Contact Us!

How to Contact Oracle Technical Publications

How to Contact Oracle Support Services

Resources for Oracle Partners and Developers

Preface

Intended Audience

Prerequisites

Structure

Conventions

Types of Documentation

Related Documents

1 Overview of Oracle Parallel Server

Introduction

Oracle Parallel Server Software Components

Group Membership Service

Operating System Dependent Layer

OSD Components

Cluster Manager

Inter-Process Communication (Node-to-Node)

Input/Output

Startup

Performance and Management

Oracle Parallel Server Instances

Database Files

Oracle Parallel Server Features

Integrated Distributed Lock Manager

Interaction with PGMS

Parallel Cache Management

PCM Lock Implementation

Choosing a Lock

Oracle Parallel Query

Architectural Overview

OPQ on Oracle Parallel Server

OPQ Statement

2 System Requirements

Hardware Requirements

Each Oracle8 Parallel Server Node

Oracle Enterprise Manager Repository Database

Oracle Enterprise Manager Console

Software Requirements

Each Oracle8 Parallel Server Node

Oracle Enterprise Manager Repository Database

Oracle Enterprise Console

Shared Disk Subsystem

3 Performing Pre-Installation Tasks

Raw Partition Overview

Raw Partition

Extended Partition

Disk Definition

Raw Partition Definition

Physical Disk

Logical Partition

Physical Disk and Logical Partition Considerations

Frequently Asked Questions

Compatibility Issues

Step 1: Create an Extended Partition

Step 2: Create Logical Partitions In an Extended Partition

Step 3: Unassign Drive Letters

4 Installing Oracle Parallel Server

Oracle Parallel Server and Multiple Oracle Homes

Step 1: Install Oracle8 Enterprise Edition and Oracle Parallel Server on Nodes

Step 2: Install OSD Files

5 Configuring Oracle Parallel Server

Step 1: Copy Initialization Files

Step 2: Assign Symbolic Links to Each Logical Partition

Removing or Ignoring Links

Step 3: Configure OSD Layer

Step 4: Create Services

Step 5: Add the ORACLE_SID Entry to the Registry

Step 6: Configure the Network

Step 6a: Stop the Network Listener

Step 6b: Configure the Service Names

Step 6c: Start the Network Listener

Step 6d: Test the Configuration

Step 7: Create an Oracle Parallel Server Database

Step 8: Start the Database in Parallel Mode

Step 9: Verify InstancesAre Running

6 Installing and Configuring Oracle Parallel Server Manager

Overview of OPSM

OPSM Requirements

Understanding Oracle Enterprise Manager Console Setup

Step 1: Install Oracle Enterprise Manager

Step 1a: Install Repository Database on Windows NT

Step 1b: Install Oracle Enterprise Manager on Console Workstation

Step 2: Configure Oracle Enterprise Manager

Step 2a: Start Oracle Services

Step 2b: Create a Repository User Account

Step 2c: Create a Windows NT User Account

Step 2d: Create Configuration Files

Step 2e: Create the Repository and DiscoverServices

Step 3: Configure Oracle Performance Manager

Accessing Oracle Performance Manager

7 Administering Multiple Instances

Understanding the Initialization Files

Purpose of INITSID.ORA

Purpose of INIT_COM.ORA

Setting Initialization Parameters for the Oracle Parallel Server

GC Global Cache Parameters

Parameter Notes for Multiple Instances

Identical Parameters on Each Instance

Setting LM Parameters

Parameter Descriptions

Location of Initialization Files

Editing Initialization Files

Managing Instances Using OPSM

Using OPSM from the Oracle Enterprise Manager Console

Using OPSM from OPSCTL

Understanding OPSCTL Requirements

Startup

Shutdown

8 Adding Instances and Nodes

Moving from a Single Instance to Parallel Server

Step 1: Configure Hardware

Step 2: Evaluate Tablespaces and Log Files of Single Instance

Step 3: CreateRaw Partitions

Step 4: Install Oracle8 Enterprise Edition and Oracle Parallel Server Option

Step 5: Install OSD Files

Step 6: Move Initialization Files

Step 7: Export Data from Old Database

Oracle Data Manager

Export Utility

Step 8: Prepare CREATE DATABASE Script

Step 9: Configure OSD Layer, Create Services, and Configure Network

Step 10: Create an Oracle Parallel Server Database

Step 11: Transfer Data From Old Data to Empty Database

Oracle Data Manager

Import Utility

Step 12: Start the Database

Adding Additional Nodes to a Cluster

Assign Symbolic Links to Each Logical Partition

Shut Down Services

Create Rollback Segments For Additional Nodes

9 Backing Up and Recovering

Backup and Recovery

A Directory Structure

Oracle Parallel Server Directory Structure

B Troubleshooting

Cluster Configuration Tips

Cluster Software

CM Configuration

Cluster Configuration Verification

CM Troubleshooting

CM Secondary Backup

CM Error Log File Specification

Performance and Manager Configuration Tips

ORA-29702

Starting Services

DYNAMIC RESOURCES ALLOCATED or DYNAMIC LOCKS ALLOCATED

Understanding the Trace Files

Background Thread Trace Files

User Thread Trace Files

Alert File

Error Call Trace Stack

Cluster Tracing

PGMS Tracing

CM Tracing

Using PhysicalDrive for Raw Partitions

SHUTDOWN ABORT

Contacting Oracle Worldwide Customer Support

Severe Errors

Glossary

Index