Oracle8i Parallel Server Setup and Configuration Guide
Release 2 (8.1.6)







Title and Copyright Information

Send Us Your Comments


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
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
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
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
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

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
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
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



Copyright © 1999 Oracle Corporation.

All Rights Reserved.