Skip Headers

Table of Contents Image Oracle8i Server Installation and Database Administration Guide
Release 3 (8.1.7) for Fujitsu Siemens Computers BS2000/OSD

Part Number A95466-01
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Release Notes

Oracle8i Release 3 Server Product Set
Tape Description
Tape Contents
Hardware Requirements
CPU
Terminal
Tape Drive or Magnetic Tape Cartridge Unit
Disk Space
Database Space
Software Requirements
Operating System
Communication System
Language Compilers and Runtime Environment for Oracle Applications
UTM Software
Other Software
Address Space Limit
New Features
Changes since release 8.1.5
Restrictions
Known Problems, Restrictions and Workarounds
General Notes
Oracle Server
Archiving to Tape
SQL*Loader
The Import and Export Utilities
National Language Support
Server Manager
DB-Verify
Oracle Call Interface
SQL*Plus
Net8
Net8 TCP/IP
Net8 MTT
Single-Task Mode - Two-Task Mode
POSIX and UFS

2 Oracle8i Release 3 Server Architecture and Implementation

Basic Structures
Database Files
Other Oracle Server Files
Initialization File
ORAENV File
Control Files
Message Files
Oracle Server Implementation
Single-Task Mode
Two-Task Mode
Address Space Planning
Oracle Server Data Area Placement
Oracle Server Environment Definition File
Generating ORAENV
ORAENV Variables
Running ORAENV
The ORALOAD Library
The ORAMESG library
Userid Requirements
Installation Userid (ORAUID)
Authorizations and File Access Rights
Default Name
DBA Userid
Running Server Manager on the Local Machine
Authorizations and File Access Rights
Default Name
Oracle Server-User Userids
Authorizations and File Access Rights
Remote Access

3
Installing/Upgrading
Oracle Server Software

Overview of Oracle Server Installation
Installing the Oracle Server Software Under a New Userid
Installing Multiple Oracle Systems

4 Creating/Migrating a Database

Creating a Database
Pre-creation Activities
Creating a Database Automatically
Creating a Database Manually
Copying the DBA Procedures
Creating the Database
Pre-allocating the Files
Modifying the Initialization File
Modifying the ORAENV File
Using Server Manager to Create the Database
Installating Data Dictionary Views
Installing Data Dictionary Views for PL/SQL
Installing Data Dictionary Views for Replication
Installing Online HELP Messages
Installing the SQL*Plus Demonstration Database
Verifying Successful Creation of the Database
Installing Resource Manager
Installing interMedia Text
Installing Java
Setting Up UTM on the Oracle Server
Migrating from Version 7
Prepare the Version 7 Source Database for Migration
Migrate the Version 7 Source Database
Upgrade from Version 8.1.5
Post-Upgrade and Post-migration activities
Re-compilation of C and COBOL Programmatic Interface Programs
Re-Linking Programmatic Interface Programs
Rebuilding Oracle Server (UTM) Applications
Updating ORAENV Files

5 Administering the Oracle Server

Using the Oracle Server Manager Utility
Oracle Server Manager Modes of Operation
Invoking the Oracle Server Manager Utility
Calling the Oracle Server Manager from a Procedure
Issuing BS2000 Commands from the Oracle Server Manager
Startup and Background Tasks
Startup and Parameter Files
The Environment Definition File ORAENV
The Initialization File INIT.ORA
Using the Correct Initialization File
Starting a Database Instance from a Remote Machine
Security Considerations
Checking the Integrity of the Physical Data Structure
Customizing Your Oracle Server System
Creating a Global SQL*Plus Profile
Adding Database Files
Setting Access Rights
Accessing the Oracle Server in Single-Task under the DBA Userid
Accessing the Oracle Server Through Several Different Userids

6 Backing Up and Recovering a Database

Backing Up Databases
Backing up Using the Export Utility
Using BS2000 Utilities to Back Up an Oracle Server System
Online Backup
Recovering Databases
Restoring from a Full Database Export
Restoring from Disk-File Backups
Log Archiving
Enabling Archiving
Automatic Archiving
Recovery Manager

7 Tuning the Oracle Server

BS2000/OSD-Specific Parameters
Task Priority
Initialization Parameters

8 UTM Product Set

Operation of Oracle Server Databases Using UTM Programs
Distributed UTM Files
Installing
Developing an Oracle Server/UTM Application
Defining an Open String
Required Fields
Optional Fields
Examples
Using Precompilers with openUTM
Using Pro*C with the Default Database
Using Pro*C with a Named Database
Troubleshooting
Trace Files
Trace File Examples
Debugging
In-Doubt or Pending Transactions
Oracle Server SYS Account Tables
Warm-Start Problem Under UTM-D

9 Net8

Net8 Products
Introducing Net8
Oracle Protocol Adapters
Overview
IPC Adpater
Overview of IPC
Using the IPC Adapter
TCP/IP Adapter
Overview of TCP/IP
Using the Oracle TCP/IP Adapter
OSI4 Adapter
Overview of OSI4
Using the Oracle OSI4 Adapter
Example of a PROTOCOL.ORA File
MTT Adapter
Overview of MTT
Using the MTT Adapter
Bequeath Adapter
Overview of the Bequeath Adapter
Using the Bequeath Adapter
Multi-threaded Server Architecture
Configuring the Network
Using the Local Naming Method
Using the Centralized Naming Method
Configuration on the Server
Configuration on the Client
Testing the Configuration on the Client
Migrate to Net8
Compatibility Issues
TCP/IP
MTT
Troubleshooting Net8

10 interMedia Text

Installing interMedia Text
Starting interMedia Text utilities
Restrictions of interMedia Text on BS2000/OSD

11 External Procedures

Loading External Procedures

12 Java in the Database

Installation of a Java Enabled Database
Where can files related to Java reside and how should they be encoded?
Database character sets and Java encodings
Loadjava
Java Demonstration Files
Restrictions

13 XML

Installation
Features and Restrictions

14 Oracle Server on SR2000

Concepts
Definitions
Product Set
Hardware requirements
Software requirements
Address Space Limit
Installing Oracle Server Software
Database Creation
Upgrade/Migration
Administration
Oracle application programs
/390 mode applications
RISC mode applications
UTM Product Set

A Oracle Messages

B ORAENV Variables

ORAENV Rules
Built-in Variables
LOGNAME
ORAUID
PGM
TERM
TSN
General Variables
DEFAULT_CONNECTION
EXP_CLIB_FILE_IO
IMP_CLIB_FILE_IO
IMP_USERID_IGNORE
NLS_CONVERSION
NLS_LANG
OPS_JID
ORADUMP
ORASID
PRINTPAR
SQLPATH
SSSIDPWF
DBA Startup Variables
Address and Size Specification
BGJPAR
BGJPRC_UID / BGJPRC_SID
COM_MPID
COM_BASE
ENABLE_JAVA
JVM_BASE
JAVA_HOME
JOBID
KNL_BASE
PGA_BASE
PGA_SIZE
SF_PBLKSIZE
SGA_BASE
SGA_ROUND
Net8 Network Management Variables
TNS_ADMIN
TNS_BEQ_TIMEOUT
TNS_KEEP_SYSOUT
TNS_LOG_JOBSTART
TNS_MTT_TIMEOUT

C Initialization Parameters and the
Parameter File

Example Parameter File
Unsupported Parameters
Additional Notes on Initialization Parameters
DB_BLOCK_SIZE
DB_FILE_MULTIBLOCK_READ_COUNT
DB_FILES
DISTRIBUTED_TRANSACTIONS
LOG_ARCHIVE_BUFFER_SIZE
TIMED_STATISTICS
LOG_ARCHIVE_DEST

D Problem Solving

Problems Installing Oracle8i
Problems Creating a Database
Problems Starting a Database
Problems Starting the Database
Problems with Tasks
Problems Accessing the Database
Problems with Database and Log files
Oracle8i Trace Files
Trace Filenames
OS-Level Error Information

E File Types and Names Used by Oracle

sid.DBS.xxx.DBF
sid.DBS.INIT.ORA
sid.P.ORAENV
sid.T.E.xxxx.ORA
S.OUT.tsn.YYYY-MM-DD.hhmmss
L.sid.xxxx.SYSOUT L.sid.xxxx.SYSOUT.OLD
L.sid.xxxx.SYSOUT.tsn
Net8 LOG files
ALERT.sid.LOG
T.sid.INSTALL.E.SUPER T.sid.INSTALL.E.SUPER.80
L.sid.xxx.LOG
ORAXALOG.tsn-NULL-YYMMDD.TRC
OTRC.sid.tsn.program.TRC

Index


Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Index
Index