Oracle8i Parallel Server Setup and Configuration Guide
Release 8.1.5

A67439-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introducing Oracle Parallel Server

Introduction
Oracle Parallel Server and the Optimal Flexible Architecture
Oracle Parallel Server Software Components
Operating System Dependent Layer
Oracle Parallel Server Instances
Unique Identification of Instances
Data Files
Oracle Parallel Server Features
Integrated Distributed Lock Manager
Parallel Cache Management
Oracle Parallel Query
Oracle Parallel Query Statement

2 Pre-Installation

System Installation Requirements
Hardware and Software Requirements for Oracle8i Parallel Server Node
Hardware and Software Requirement for Oracle Enterprise Manager
Shared Disk Subsystem
Setting Up Raw Devices
Identifying Raw Devices
Pre-Installation Steps

3 Installation

Installation Types
Installation Procedure
Migrating or Upgrading to Release 8.1
Multiple Oracle Homes

4 Configuring Oracle Parallel Server

Configuration Options
Creating the Database
Step 1: Create and Identify Raw Partitions
Step 2: Create the Database
Starting the Database in Parallel Mode
Verifying Instances Are Running
Configuring Net8 for Nodes
Step 1: Configure the Listener
Step 2: Configure Net Service Names
Step 3: Configure SQLNET.ORA
Configuring Net8 for Clients
Configuring Net8 with Failover
Configure the Listener
Configuring the TNSNAMES.ORA File for Failover
Testing the Net8 Configuration

5 Installing and Configuring Oracle Parallel Server Management

Oracle Parallel Server Management Architecture
Oracle Parallel Server Requirements
Understanding Oracle Enterprise Manager Setup
Installing Oracle Enterprise Manager
Configuring Oracle Enterprise Manager
Step 1: Configure Net8
Step 2: Configure OPSCTL for UNIX Platforms
Step 3: Configure Repository
Step 4: Start Oracle Enterprise Manager Components
Step 5: Discover Nodes
Step 6: Specify Preferred Credentials for Nodes and Oracle Parallel Server Database
Installing Oracle Performance Manager
Configuring Oracle Performance Manager
Step 1: Configure Net8
Step 2: Start Oracle Performance Manager Components
Step 3: Accessing Oracle Parallel Server Charts

6 Administering Oracle Parallel Server

Understanding the Initialization Files
Purpose of INITSID.ORA
Purpose of INITDB_NAME.ORA
Setting Initialization Parameters
GC_* Global Constant 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 Oracle Parallel Server Management
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
Viewing Oracle Parallel Server Status
Creating a Job for a Parallel Server or Parallel Server Instance
Specifying Job Details

7 Monitoring Performance with Oracle Parallel Server Management Charts

Oracle Performance Manager Overview
Starting the 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

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: Create Raw Devices
Step 4: Export Data from Old Database
Step 5: Install Operating System Dependent Files
Step 6: Install Oracle8i Enterprise Edition and Oracle8i Parallel Server Option
Step 7: Create the Database
Step 8: Transfer Data From Old Data to Empty Database
Step 9: Start the Database
Adding Additional Nodes to a Cluster

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

Cleaning Up the Registry After an Oracle Database Configuration Assistant Failure on Windows NT
Handling Auto-Discovery Failures
Understanding Auto-Discovery
Auto-Discovery Results
Troubleshooting Auto-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



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index