Oracle9i Enterprise Edition System Administration Guide
Release 1 (9.0.1) for OS/390

Part Number A89899-01
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction to OSDI Architecture

Overview
Benefits of OSDI
OSDI Architecture

2 Configuring and Initializing the Subsystem

Overview
Choosing a Subsystem Name and Command Prefix
The Subsystem Parameter File
OSDI Commands in the Subsystem Parameter File
Initializing the Subsystem
Examples
After Initializing the Subsystem

3 Configuring a Database Service and Creating a New Database

Overview
Database Service Definition
Database Region JCL
Database Region Parameters
Oracle Initialization Parameter Considerations
Database Logical Blocksize
Pre-Allocating Database Files
Configuring OS/390 Security
Creating the Database
Configuring a Database Service Using ISPF Panels

4 Defining OS/390 Data Sets for the Oracle Database

Oracle Database Files
Tablespaces and OS/390 Space Management
Server File Name Syntax
Server File Management Parameters
Pre-allocating Database Files
Oracle Managed Files on OS/390

5 Operating a Database Service

Starting and Stopping the Database Service
Oracle Database Instance Startup and Shutdown
Other Database Service Commands

6 Database Backup and Recovery

Overview
Logging and Recovery
Backup and Recovery without Recovery Manager
Recovery Manager on OS/390
Tablespace Point-in-Time Recovery
Oracle9i Data Guard

7 Oracle9i Utilities

Introduction
General Considerations
SQL*Plus on OS/390
Recovery Manager (RMAN) on OS/390
Oracle Password Utility (ORAPWD) on OS/390
Offline Database Verification Utility (DBV) on OS/390

8 Security Considerations

Overview
Controlling Access to OSDI Subsystem Commands
Controlling Access to OSDI Services
Controlling Access to Database SYSDBA and SYSOPER Privileges
Database Service Actions Subject to OS/390 Authorization
External Data Mover Actions Subject to OS/390 Authorization
Oracle Net Actions Subject to OS/390 Authorization
Authorizing Oracle Logon

9 Oracle SMF Data

Preparing to Record SMF Information
Events that Generate SMF Records
SMF Recording under CICS
Interpreting an Oracle SMF Record
Oracle Net Network Information Vector Overview
Sample Formatting Program for SMF Records
Auditing Database Use

10 Oracle Net

Oracle Net Overview
Oracle Net for OS/390 Architecture
Oracle Net TCP/IP
Oracle Net for OS/390 Filenames
Configuring Network Service
Operating the Network Service
Formatting Oracle Net Trace Files
Oracle Advanced Security Option Encryption

11 Oracle Access Manager for CICS

Overview
Oracle Access Manager for CICS Applications
Oracle Access Manager for CICS Configuration
Configuration Steps
Post-Configuration Steps
Multiple Versions in the Same CICS Region
Recovery Considerations
Two-Phase Commit Processing under CICS
Shutting Down Oracle Access Manager for CICS with FORCE
CEDF Support
Oracle Net Tracing from the CICS Access Manager
Oracle Access Manager for CICS Command Usage
DISPLAY
START
STOP

12 Oracle Access Manager for IMS TM

Oracle Access Manager for IMS TM Applications
Integration with IMS
Configuration Overview
Configuring Oracle Access Manager for IMS TM
Configuration Steps
IMS External Subsystems
Starting and Stopping Oracle Access Manager for IMS TM
Failures and Recovery

13 Oracle Enterprise Manager Intelligent Agent and Data Gatherer

Introduction
Running the Customization Script
Updating the Parameter Files

14 Oracle9i Real Application Clusters

Introduction
Setting Up Real Application Clusters
Cross System Communication Facility (XCF)
OS/390 Resource Name Usage

15 Oracle Programmatic Interfaces

Oracle Programmatic Interfaces INCLUDE Files
ASID and Task Considerations
Program Status Word Protect Key
PSW State
Multiple Executions under a TCB
Cross Memory Mode
APF Authorization

16 Configuring the Listener for External Routines

Overview
Create and Modify the Tnsnames.ora File
Create and Modify the Listener.ora File
Start the Listener

17 Oracle9i Performance

CPU Usage
Memory Requirements
Oracle Server Storage Requirements
Oracle Tuning
Minimizing I/O Bottlenecks
OS/390 Tuning
PL/SQL and Java
Oracle Parallel Execution
Applications Performance Diagnosis
Oracle Access Manager for CICS
Oracle Access Manager for IMS

18 Error Diagnosis and Reporting

Oracle Support Services
Providing Error Documentation
General Documentation Requirements
Error Diagnosis
System Dumps
GTF

19 Migration and Upgrade Considerations

Overview
OSDI Differences
Summary of Changes
Configuring and Initializing an OSDI Subsystem
Configuring a Database Service
Database File Processing Considerations
Operating a Database Service
Database Backup and Recovery
Server Manager and SQL*Plus
Security Considerations
Oracle SMF Processing
Database Auditing
Oracle Net or Network Service
Migration and Upgrade
Migration and Upgrade Steps
MPM/TNS and OSDI Coexistence

A OSDI Subsystem Command Reference

OSDI Command Reference
Command Types and Processing
System Symbols in Commands
Definition Commands
Structures
Service Group Definition Commands
Service Definition Commands
Operating Commands
Available Commands
Commands
OSDI Command Keyword Abbreviations

B Operating System Dependent Variables

Initialization Parameters with OS/390-Specific Defaults or Limits
Database Limits
SQL Language Parameters
Storage Parameters

C Oracle9i for OS/390 System Symbols

System Symbols

D National Language Support

Overview
Supported Languages
Overview of Character Set Support
Server-Side NLS
Default Character Set Changed
Client-Side NLS
Message Availability
Customized Character Sets (LXINST)
NLS Calendar Utility (LXEGEN)

Index


Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index