Contents

Title and Copyright Information

Preface

• Audience
• Using Oracle Database Documentation
• Documentation Accessibility
• Related Documents
• Conventions Used in this Manual

1 Release Notes

• Oracle Database Editions for BS2000/OSD
• Hardware Requirements
  • CPU
  • Memory
  • Terminal
  • Disk Space
  • Database Space
• Software Requirements
  • Operating System
  • Communication System
  • Language Compilers and Run-Time Environment for Oracle Applications
  • openUTM Software
  • Other Software
• Address Space Limit
• Features Supported
• Features not Supported
• Known Restrictions, Problems, and Workarounds
  • General Notes
  • Oracle Spatial Data Option
  • Oracle Real Application Clusters (Oracle RAC)
  • Native Compilation of PL/SQL and Java
  • ALTER DATABASE … RESIZE
  • IEEE Standard Floating Point Number Restrictions
  • Datatypes FLOAT and DOUBLE of SQL*Loader and External Tables
  • Oracle Scheduler
  • Oracle JDBC OCI Drivers
  • XML Database (XML DB)
  • Oracle XML Developers Kit (XDK)
  • BS2000/OSD file types of spool files
  • INIT.ORA parameters
  • Archiving to Tape
  • SQL*Loader
  • Import and Export
  • Datapump Import and Datapump Export
  • Globalization Support
  • Oracle Call Interface
  • SQL*Plus
  • Oracle Net Services
  • Oracle Net BEQ Protocol
  • Oracle Protocol Support for TCP/IP
  • POSIX Subsystem
• Incompatibilities
  • New Common Pool for Applications
  • Subsystem POSIX Required
  • ALTER DATABASE … RESIZE
  • Datatypes FLOAT and DOUBLE of SQL*Loader and External Tables
  • Default value of STATISTICS_LEVEL
  • Obsolete ORAENV Variables

2 Architecture and Implementation

• Basic Structures
  • Database Files and Log Files
  • Other Oracle Database Files
    • Initialization File
    • Server Parameter File
    • ORAENV File
    • Control Files
    • Message Files
  • Oracle-Managed Files
  • Bigfile Tablespaces
• Two-Task Mode
• Address Space Planning
  • Oracle Database Data Area Placement
• Oracle Database Environment Definition File
  • Generating ORAENV
  • ORAENV VARIABLES
  • Running ORAENV
• The ORALOAD Library
• The ORAMESG library
• User ID Requirements
  • Installation User ID (ORAUID)
    • Authorizations and File Access Rights
    • Default Name
  • DBA User ID
    • Authorizations and File Access Rights
    • Default Name
  • User IDs for Oracle users
    • Authorizations and File Access Rights

3 Installing Oracle Database Software

• Overview of Oracle Database Installation
• Installing the Oracle Database Software
• Installing Multiple Oracle Systems

4 Creating and Upgrading a Database

• Creating a Database
  • Pre-Creation Activities
  • Creating a Database Automatically
  • Creating a Database Manually
    • Copying the DBA Procedures
    • Creating the Database
    • Installing Data Dictionary Views
    • Installing Data Dictionary Views for PL/SQL
    • Installing Online HELP Messages
    • Installing the SQL*Plus Demonstration Database
    • Installing the Sample Schemas
    • Verifying Successful Creation of the Database
    • Installing Oracle Text
    • Installing Java
• Upgrading a Database
  • Upgrade from Version 8
  • Upgrade from Version 9
  • Post-Upgrade activities

5 Administering Oracle Database

• Using the SQL*Plus Utility
  • Invoking the SQL*Plus Utility
  • Calling SQL*Plus from a Procedure
  • Running BS2000 Commands from SQL*Plus
• Startup and Parameter Files
  • The Environment Definition File ORAENV
  • The Initialization File INIT.ORA
  • The Server Parameter File SPFILE
  • Using the Correct Initialization File
• Remote Startup of a Database Instance
• Checking the Integrity of the Physical Data Structure
• Customizing SQL*Plus Profiles

6 Backing Up and Recovering a Database

• Backing Up an Oracle database
  • Using BS2000 Utilities to Back Up an Oracle Database
  • Online Backup
• Recovering Databases
  • Restoring from Backups
• Recovery Manager

7 Tuning the Oracle Database

• BS2000/OSD-Specific Parameters
  • Task Priority

8 openUTM Product Set

• Operation of Oracle Database Using openUTM Programs
• Distributed openUTM Files
• Installing
• Developing an Oracle Database/openUTM 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 Database SYS Account Tables
• Upgrading an existing Oracle Database / openUTM application from Oracle9i

9 Oracle Net Services

• Introducing Oracle Net Services
  • What's New in Oracle Net Services?
  • IPC Protocol Support
    • Overview of IPC
    • Using the IPC Protocol
  • TCP/IP Protocol Support
    • Overview of TCP/IP
  • Using the TCP/IP Protocol
  • Bequeath Protocol
    • Overview of the Bequeath Protocol
• Shared Server Architecture
• Oracle Advanced Security
• Configuring the Network
  • Using the Local Naming Method
  • Using the Directory Naming Method
  • Configuration on the Server
  • Configuration on the Client
  • Testing the Configuration on the Client
• Troubleshooting Oracle Net Services

10 Oracle Text

• Installing Oracle Text
• Starting Oracle Text utilities
• Restrictions of Oracle Text on BS2000/OSD

11 External Procedures

• Loading External Procedures

12 Java in the Database

• Installation of a Java Enabled Database
• Database character sets and Java Encodings
• Loadjava
• Java Demonstration Files
• Restrictions

13 XML

• Installation of Xdk
• Features and Restrictions
• Database XML support (Oracle XML DB)

14 Oracle Real Application Clusters (Oracle RAC)

• BS2000 prerequisites for Oracle RAC
• Installation of Oracle RAC
• Creation and Configuration of a Database
  • Placement of Files
  • Options in the CREATE DATABASE Statement
  • Additional Threads of Redo Log Files
  • Additional Undo Tablespaces
  • Oracle RAC- related views
  • Initialization Parameters
  • Creating Password Files
  • Configuring Oracle Net Services
• Restrictions

15 Oracle Management Agent

• Preinstallation Issues
• Running the Installation Script
• Running the Agent
• Restrictions
• Troubleshooting

16 Oracle on SX Server

• Concepts
• Definitions
• Product Set
• Hardware Requirements
• Software Requirements
• Address Space Limit
• Installing Oracle Database Software
• Database Creation
• Upgrade and Migration
• Administration
• Oracle application programs
• openUTM Product Set

A Oracle Error Messages for BS2000/OSD

B ORAENV Variables

• ORAENV Rules
• Built-in Variables
  • LOGNAME
  • ORAUID
  • PGM
  • TERM
  • TSN
• General Variables
  • CLN_BASE
  • CLN_MPID
  • DEFAULT_CONNECTION
  • EXP_CLIB_FILE_IO
  • IMP_CLIB_FILE_IO
  • IMP_USERID_IGNORE
  • NLS_LANG
  • OPS_JID
  • ORADUMP
  • ORASID
  • PRINTPAR
  • SQLPATH
  • SSSIDPWF
• DBA Startup Variables
  • Address and Size Specification
  • ALARM_TIMER_LIMIT
  • BGJPAR
  • BGJPRC_UID / BGJPRC_SID
  • BGJ_LOG_JOBSTART
  • sid_BGJPAR
  • sid_USER
  • user_ACCOUNT/ user_PASSWORD
  • COM_MPID
  • COM_BASE
  • ENABLE_RAC
  • JOBID
  • KNL_BASE
  • ORACLE_HOME
  • PGA_BASE
  • PGA_SIZE
  • SF_PBLKSIZE
  • SGA_BASE
  • SGA_ROUND
• Oracle Net Services Variables
  • BREAK_HANDLING
  • TNS_ADMIN
  • TNS_BEQ_TIMEOUT
  • TNS_UPDATE_IPNODE

C Initialization Parameters and the Parameter File

• Example Parameter File
• Unsupported Parameters
• Additional Notes on Initialization Parameters
  • BACKGROUND_DUMP_DEST
  • USER_DUMP_DEST
  • AUDIT_FILE_DEST
  • DB_BLOCK_SIZE
  • DB_FILE_MULTIBLOCK_READ_COUNT
  • DB_FILES
  • LOCK_SGA
  • SGA_MAX_SIZE
  • LOG_ARCHIVE_BUFFER_SIZE
  • LOG_ARCHIVE_DEST

D Troubleshooting

• Problems Installing Oracle Database 10g
  • Problems Creating a Database
• Problems Starting a Database
  • Problems Starting a Database
  • Problems with Tasks
• Problems Accessing the Database
  • Problems with Database and Log files
  • Oracle Database 10g Trace Files
  • Trace File names
  • Oracle Database-Level Error Information

E File Types and Names Used by Oracle

Index