Contents

Title and Copyright Information

Preface

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

1 Release Notes

• 1.1 Oracle Database Editions for BS2000/OSD
• 1.2 Options Not Supported
• 1.3 Features not Supported
• 1.4 Known Restrictions, Problems, and Workarounds
  • 1.4.1 General Notes
  • 1.4.2 Oracle Spatial
  • 1.4.3 Oracle Real Application Testing
  • 1.4.4 ALTER DATABASE … RESIZE
  • 1.4.5 IEEE Standard Floating Point Number Restrictions
  • 1.4.6 SQL*Loader
  • 1.4.7 Oracle Scheduler
  • 1.4.8 INIT.ORA Parameters
  • 1.4.9 Archiving to Tape
  • 1.4.10 Import and Export
  • 1.4.11 Oracle Data Pump Import and Oracle Data Pump Export
  • 1.4.12 Globalization Support
  • 1.4.13 Oracle Call Interface
  • 1.4.14 SQL*Plus
  • 1.4.15 ADRCI
  • 1.4.16 Connecting from Oracle Database 10g clients
  • 1.4.17 Utilities in the POSIX environment
  • 1.4.18 Oracle Net Services
  • 1.4.19 Oracle Net BEQ Protocol
  • 1.4.20 Oracle Protocol Support for TCP/IP
  • 1.4.21 POSIX Subsystem

2 Architecture and Implementation

• 2.1 Operating System Environment
  • 2.1.1 File Systems
  • 2.1.2 POSIX Shell
  • 2.1.3 Processes
• 2.2 Basic Structures
  • 2.2.1 Database Files and Log Files
  • 2.2.2 Other Oracle Database Files
    • 2.2.2.1 Initialization File
    • 2.2.2.2 Server Parameter File
    • 2.2.2.3 ORAENV File
    • 2.2.2.4 Control Files
    • 2.2.2.5 Message Files
  • 2.2.3 Oracle-Managed Files
  • 2.2.4 Bigfile Tablespaces
• 2.3 Two-Task Mode
• 2.4 Address Space Planning
  • 2.4.1 Oracle Database Data Area Placement
• 2.5 Oracle Database Environment Definition File
  • 2.5.1 Generating ORAENV
  • 2.5.2 Oracle Environment Variables
  • 2.5.3 Running ORAENV
  • 2.5.4 POSIX Environment and ORAENV File
• 2.6 The ORALOAD Library
• 2.7 The ORAMESG library
• 2.8 User ID Requirements
  • 2.8.1 Installation User ID (ORAUID)
    • 2.8.1.1 Authorizations and File Access Rights
    • 2.8.1.2 Default Name
  • 2.8.2 DBA User ID
    • 2.8.2.1 Authorizations and File Access Rights
    • 2.8.2.2 Default Name
  • 2.8.3 User IDs for Oracle users
    • 2.8.3.1 Authorizations and File Access Rights

3 Oracle Database Installation and Deinstallation

• 3.1 Overview of Oracle Database Installation
• 3.2 Planning the Installation
• 3.3 Oracle Database Preinstallation Requirements
  • 3.3.1 Checking Hardware Requirements
    • 3.3.1.1 Memory Requirements
    • 3.3.1.2 System Architecture
    • 3.3.1.3 Disk Space Requirements
    • 3.3.1.4 Display Requirements
  • 3.3.2 Checking Software Requirements
    • 3.3.2.1 Operating System and Communication System Requirements
    • 3.3.2.2 POSIX Parameters
    • 3.3.2.3 Package Requirements
    • 3.3.2.4 Additional BS2000 Software Components
    • 3.3.2.5 Compiler and CRTE Requirements for Oracle Database Applications
    • 3.3.2.6 Additional Software Requirements
  • 3.3.3 Checking Network Setup
    • 3.3.3.1 Checking Sockets subsystem
    • 3.3.3.2 Checking BCAM Timer
    • 3.3.3.3 Checking LWRESD
    • 3.3.3.4 Checking Loopback Address
    • 3.3.3.5 Checking the Configuration Files in the POSIX File System
  • 3.3.4 Creating Required Operating System Users and Groups
    • 3.3.4.1 Creating the BS2000 Installation User ID
    • 3.3.4.2 Creating the POSIX System Group
    • 3.3.4.3 Initializing the POSIX User
    • 3.3.4.4 Creating Users and Groups for Oracle Databases
  • 3.3.5 Identify Required Directories in POSIX
    • 3.3.5.1 Oracle Base Directory
    • 3.3.5.2 Oracle Inventory Directory
    • 3.3.5.3 Oracle Home Directory
  • 3.3.6 Identifying or Creating Oracle Base Directory in POSIX
    • 3.3.6.1 Identifying an Existing Oracle Base Directory in POSIX
    • 3.3.6.2 Create or Expand a File System for the Oracle Base Directory
• 3.4 Installing the Oracle Database Software
• 3.5 Oracle Database Postinstallation Tasks
• 3.6 Installing Multiple Oracle Systems
• 3.7 Removing Oracle Database Software

4 Creating and Upgrading a Database

• 4.1 Creating a Database
  • 4.1.1 Pre-Creation Activities
  • 4.1.2 Creating a Database Automatically
  • 4.1.3 Creating a Database Manually
    • 4.1.3.1 Copying the DBA Procedures
    • 4.1.3.2 Creating the Database
    • 4.1.3.3 Installing Data Dictionary Views
    • 4.1.3.4 Installing Data Dictionary Views for PL/SQL
    • 4.1.3.5 Installing Online Help Messages
    • 4.1.3.6 Installing the Demo Tables
    • 4.1.3.7 Installing the Sample Schemas
    • 4.1.3.8 Verifying Successful Creation of the Database
    • 4.1.3.9 Installing Oracle Text
    • 4.1.3.10 Installing Java
• 4.2 Upgrading a Database
  • 4.2.1 Upgrade from Version 9
  • 4.2.2 Upgrade from Version 10
  • 4.2.3 Postupgrade Activities

5 Administering Oracle Database

• 5.1 Using the SQL*Plus Utility
  • 5.1.1 Starting the SQL*Plus Utility in BS2000
  • 5.1.2 Calling SQL*Plus from a Procedure
  • 5.1.3 Using SQL*Plus in the POSIX shell
  • 5.1.4 Running System Commands from SQL*Plus
  • 5.1.5 Using an Editor in SQL*Plus
  • 5.1.6 Customizing SQL*Plus Profiles
• 5.2 Startup and Parameter Files
  • 5.2.1 The Environment Definition File ORAENV
  • 5.2.2 The Initialization File INIT.ORA
  • 5.2.3 The Server Parameter File SPFILE
  • 5.2.4 Using the Correct Initialization File
• 5.3 Remote Startup of a Database Instance
• 5.4 Automatic Diagnostic Repository
  • 5.4.1 Automatic Diagnostic Repository Directories and Files
  • 5.4.2 ADR Command Interpreter
• 5.5 Checking the Integrity of the Physical Data Structure

6 Backing Up and Recovering a Database

• 6.1 Backing Up an Oracle Database
  • 6.1.1 Using BS2000 Utilities to Back Up an Oracle Database
  • 6.1.2 Online Backup
• 6.2 Recovering Databases
• 6.3 Recovery Manager

7 Tuning Oracle Database

• 7.1 BS2000/OSD-Specific Parameters
  • 7.1.1 Task Priority

8 openUTM Product Set

• 8.1 Operation of Oracle Database Using openUTM Programs
• 8.2 Distributed openUTM Files
• 8.3 Installing
• 8.4 Developing an Oracle Database/openUTM Application
  • 8.4.1 Defining an Open String
    • 8.4.1.1 Required Fields
    • 8.4.1.2 Optional Fields
    • 8.4.1.3 Examples
  • 8.4.2 Using Precompilers with openUTM
    • 8.4.2.1 Using Pro*C with the Default Database
    • 8.4.2.2 Using Pro*C with a Named Database
• 8.5 Troubleshooting
  • 8.5.1 Trace Files
    • 8.5.1.1 Trace File Examples
  • 8.5.2 Debugging
  • 8.5.3 In-Doubt or Pending Transactions
  • 8.5.4 Oracle Database SYS Account Tables

9 Oracle Net Services

• 9.1 Introducing Oracle Net Services
  • 9.1.1 IPC Protocol Support
    • 9.1.1.1 Overview of IPC
    • 9.1.1.2 Using the IPC Protocol
  • 9.1.2 TCP/IP Protocol Support
    • 9.1.2.1 Overview of TCP/IP
  • 9.1.3 Using the TCP/IP Protocol
  • 9.1.4 Bequeath Protocol
    • 9.1.4.1 Overview of the Bequeath Protocol
• 9.2 Shared Server Architecture
• 9.3 Oracle Advanced Security
• 9.4 Configuring the Network
  • 9.4.1 Using Easy Connect Naming Method
  • 9.4.2 Using the Local Naming Method
  • 9.4.3 Using the Directory Naming Method
  • 9.4.4 Configuration on the Server
  • 9.4.5 Configuration on the Client
  • 9.4.6 Testing the Configuration on the Client
• 9.5 Troubleshooting Oracle Net Services

10 Oracle Text

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

11 External Procedures

• 11.1 Loading External Procedures

12 Java in the Database

• 12.1 Installation of a Java Enabled Database
• 12.2 Database character sets and Java Encodings
• 12.3 Java Demonstration Files

13 XML

• 13.1 Installation of Xdk
• 13.2 Features and Restrictions

14 Oracle Management Agent

• 14.1 Preinstallation Issues
• 14.2 Running the Installation Script
• 14.3 Running the Agent
• 14.4 Restrictions
• 14.5 Troubleshooting

15 Oracle on SQ Server

• 15.1 Concepts
• 15.2 Definitions
• 15.3 Product Set
• 15.4 Hardware Requirements
• 15.5 Software Requirements
• 15.6 Address Space Limit
• 15.7 Installing Oracle Database Software
• 15.8 Database Creation
• 15.9 Upgrade and Migration
• 15.10 Administration
• 15.11 Oracle application programs
• 15.12 openUTM Product Set

A Oracle Error Messages for BS2000/OSD

B Oracle Environment Variables

• B.1 ORAENV Rules
• B.2 Built-in Variables
  • B.2.1 LOGNAME
  • B.2.2 ORAUID
  • B.2.3 PGM
  • B.2.4 TERM
  • B.2.5 TSN
• B.3 General Variables
  • B.3.1 CLN_BASE
  • B.3.2 CLN_MPID
  • B.3.3 DEFAULT_CONNECTION
  • B.3.4 EXP_CLIB_FILE_IO
  • B.3.5 IMP_CLIB_FILE_IO
  • B.3.6 NLS_LANG
  • B.3.7 OPS_JID
  • B.3.8 ORASID
  • B.3.9 PRINTPAR
  • B.3.10 SQLPATH
  • B.3.11 SSSIDPWF
• B.4 DBA Startup Variables
  • B.4.1 Address and Size Specification
  • B.4.2 BGJPAR
  • B.4.3 BGJPRC_UID / BGJPRC_SID
  • B.4.4 BGJ_LOG_JOBSTART
  • B.4.5 sid_BGJPAR
  • B.4.6 sid_USER
  • B.4.7 user_ACCOUNT/ user_PASSWORD
  • B.4.8 COM_MPID
  • B.4.9 COM_BASE
  • B.4.10 JOBID
  • B.4.11 KNL_BASE
  • B.4.12 ORACLE_HOME
  • B.4.13 PGA_BASE
  • B.4.14 PGA_SIZE
  • B.4.15 SF_PBLKSIZE
  • B.4.16 SGA_BASE
• B.5 Oracle Net Services Variables
  • B.5.1 BREAK_HANDLING
  • B.5.2 TNS_ADMIN
  • B.5.3 TNS_BEQ_TIMEOUT
  • B.5.4 TNS_UPDATE_IPNODE

C Initialization Parameters and the Parameter File

• C.1 Example Parameter File
• C.2 Unsupported Parameters
• C.3 Additional Notes on Initialization Parameters
  • C.3.1 BACKGROUND_DUMP_DEST
  • C.3.2 USER_DUMP_DEST
  • C.3.3 AUDIT_FILE_DEST
  • C.3.4 DB_BLOCK_SIZE
  • C.3.5 DB_FILE_MULTIBLOCK_READ_COUNT
  • C.3.6 DB_FILES
  • C.3.7 LOCK_SGA
  • C.3.8 SGA_MAX_SIZE
  • C.3.9 LOG_ARCHIVE_BUFFER_SIZE
  • C.3.10 LOG_ARCHIVE_DEST

D Troubleshooting

• D.1 Problems Installing Oracle Database 11g
  • D.1.1 Problems Creating a Database
• D.2 Problems Starting a Database
  • D.2.1 Problems Starting a Database
  • D.2.2 Problems with Tasks
• D.3 Problems Accessing the Database
  • D.3.1 Problems with Database and Log files
  • D.3.2 Oracle Database 11g Trace Files
  • D.3.3 Oracle Database-Level Error Information

E File Types and Names Used by Oracle

Index