Go to main content
1/24
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 Variants for Fujitsu BS2000/OSD
1.2
Unsupported Options
1.3
Unsupported Features
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 10
g
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 Online Redo 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
Fujitsu BS2000 Server Lines
3.3.1.2
Memory Requirements
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
Expanding a File System for the Oracle Base Directory
3.3.6.3
Creating 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 Online Help Messages
4.1.3.5
Installing Demo Tables
4.1.3.6
Installing Sample Schemas
4.1.3.7
Verifying Database Creation
4.1.3.8
Installing Oracle Text
4.1.3.9
Installing Java
4.2
Upgrading a Database
4.2.1
Upgrading from Oracle Database Release 9
i
4.2.2
Upgrading from Oracle Database Release 10
g
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 Database for Fujitsu BS2000/OSD (SQ Series)
15.1
Concepts
15.2
Product Set
15.3
Hardware Requirements
15.4
Software Requirements
15.5
Address Space Limit
15.6
Installing Oracle Database Software
15.7
Database Creation
15.8
Upgrade and Migration
15.9
Administration
15.10
Oracle Application Programs
15.11
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_DEST
D
Troubleshooting
D.1
Problems Installing Oracle Database 11
g
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 11
g
Trace Files
D.3.3
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.