Oracle9
i
Enterprise Edition System Administration Guide
Release 1 (9.0.1) for OS/390
Part Number A89899-01
Library
Product
Index
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
Oracle9
i
Data Guard
7 Oracle9
i
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 Oracle9
i
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 Oracle9
i
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 Oracle9
i
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
Copyright © 2001 Oracle Corporation.
All Rights Reserved.
Library
Product
Index