Go to main content
1/25
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
open
UTM 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
open
UTM Product Set
Operation of Oracle Database Using
open
UTM Programs
Distributed
open
UTM Files
Installing
Developing an Oracle Database/
open
UTM Application
Defining an Open String
Required Fields
Optional Fields
Examples
Using Precompilers with
open
UTM
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 /
open
UTM 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
open
UTM 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 10
g
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 10
g
Trace Files
Trace File names
Oracle Database-Level Error Information
E
File Types and Names Used by Oracle
Index
Scripting on this page enhances content navigation, but does not change the content in any way.