Contents

List of Figures

Title and Copyright Information

Preface

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

Part I Concepts

1 Concepts and Architecture

• About the BS2000 Operating System
• About File Systems
• About Processes
• Memory Architecture
• BS2000 User Ids
  • Installation User ID for Fujitsu BS2000/OSD Systems
  • DBA User ID for Fujitsu BS2000/OSD Systems
  • Client User IDs for Fujitsu BS2000/OSD Systems
• Oracle Database Programs
  • Program Libraries
  • Program Environment
    • Oracle Environment Variables
    • Setting Variables in the BS2000 Program Environment
    • Setting Variables in the POSIX Program Environment
• Physical Storage Structures
  • Files of an Oracle Database
  • Oracle Managed Files
  • Files of a Bigfile Tablespace
• Parameter Files

Part II Installation and Database Creation

2 Oracle Database Installation and Deinstallation

• Overview of Oracle Database Installation
• Planning the Installation
• Oracle Database Preinstallation Requirements
  • Checking Hardware Requirements
    • Fujitsu BS2000 Server Lines
    • Memory Requirements
    • Disk Space Requirements
    • Display Requirements
  • Checking Software Requirements
    • Operating System and Communication System Requirements
    • POSIX Parameters
    • Package Requirements
    • Additional BS2000 Software Components
    • Compiler and CRTE Requirements for Oracle Database Applications
    • Additional Software Requirements
  • Checking Network Setup
    • About Checking Sockets Subsystem
    • About Checking BCAM Timer
    • About Checking LWRESD
    • About Checking Loopback Address
    • About Checking the Configuration Files in the POSIX File System
  • Creating Required Operating System Users and Groups
    • About Creating the BS2000 Installation User ID
    • About Creating the POSIX System Group
    • About Initializing the POSIX User
    • About Creating Users and Groups for Oracle Databases
  • Identify Required Directories in POSIX
    • About Oracle Base Directory
    • About Oracle Inventory Directory
    • About Oracle Home Directory
  • Identifying or Creating Oracle Base Directory in POSIX
    • About Identifying an Existing Oracle Base Directory in POSIX
    • Expanding a File System for the Oracle Base Directory
    • Creating a File System for the Oracle Base Directory
• Installing Oracle Database
• Oracle Database Postinstallation Tasks
• About Installing Multiple Oracle Databases
• About Removing Oracle Database Software

3 About Creating a Database

• Prerequisites for Database Creation
• About Creating a Non-CDB
  • Creating a Database Automatically
  • Creating a Database Manually
    • Creating Parameter Files for a Non-CDB
    • Creating the Database
      • About Modifying the Initialization File for a Non-CDB
      • About Modifying the ORAENV File for a Non-CDB
      • About Using SQL*Plus to Create the Database
    • About Installing Data Dictionary Views
    • About Installing Online Help Messages
    • About Installing Demo Tables
    • About Installing Sample Schemas
    • About Verifying Database Creation
    • About Installing Oracle Text
    • About Installing Java
• About Creating a Multitenant Container Database
  • Creating Parameter Files for a CDB
  • About Creating a CDB
    • About Modifying the Initialization File for a CDB
    • About Modifying the ORAENV File for a CDB
    • Using SQL*Plus to Create a CDB

4 About Upgrading a Database

• Performing Preupgrade Procedures
• Performing Upgrade Procedures
• Performing Postupgrade Procedures

Part III Database Administration

5 Administering Oracle Database

• Using the SQL*Plus Utility
• Startup and Parameter Files
  • The Environment Definition File ORAENV
  • The Initialization File INIT.ORA
  • The Server Parameter File SPFILE
  • About Using the Initialization File
• Preparing a Remote Startup of a Database Instance Using SQL*Plus
• Automatic Diagnostic Repository
  • Automatic Diagnostic Repository Directories and Files
  • ADR Command Interpreter Utility

6 Oracle Database Utilities

• Basics of Oracle Database Utilities
  • The Oracle Database Environment-Definition File
    • Generating the Environment-Definition File
    • Calling the Environment Definition File
    • Specifying the Environment Variables
  • The ORALOAD Library
  • Starting Oracle Utilities in the BS2000 Program Environment
  • Starting Oracle Utilities in the POSIX Program Environment
  • Connecting to an Oracle Database Instance
    • Default Connections
    • Accessing an Oracle Database Instance
  • Using BS2000 Files for Input and Output
    • Text Files
    • Binary Files
    • Default File Name Extensions
    • Using Link Names
    • Fixed Link Names
• SQL*Plus
  • Using SQL*Plus in the BS2000 Environment
    • Starting SQL*Plus in the BS2000 Environment
    • Interrupting a SQL*Plus Command in the BS2000 Environment
    • Running BS2000 Commands from SQL*Plus
    • Starting the BS2000 Editor
    • Spooling SQL*Plus Output
    • Specifying the Search Path for SQL Scripts in the BS2000 Environment
    • Starting SQL*Plus in a BS2000 command procedure
  • Using SQL*Plus in the POSIX environment
    • Starting SQL*Plus in the POSIX Environment
    • Interrupting a SQL*Plus Command in the POSIX Environment
    • Running Shell Commands From SQL*Plus
    • Using an Editor in SQL*Plus
    • Spooling SQL*Plus Output in the POSIX Environment
    • Specifying the Search Path for SQL Scripts in the POSIX Environment
  • SQL*Plus User Profiles
    • The glogin.sql Global Setup File
    • The login.sql User Setup File
  • Using SQL*Plus Symbols
  • Sample Schemas and SQL*Plus
  • SQL*Plus Limits
• The SQL*Loader
  • Starting the SQL*Loader Utility
  • Using the SQL*Loader Demonstration Files
• The Export Utility
  • Starting the Export Utility
  • Exporting to Foreign Systems
    • Exporting Data to Tape
    • Transferring Data by File Transfer
• The Import Utility
  • Starting the Import Utility
  • Importing from Foreign Systems
    • Importing File with Non-Standard Block Size
    • Importing Data from Tape
    • Transferring Data by File Transfer
• The Data Pump Export Utility
  • Starting the Data Pump Export Utility
• The Data Pump Import Utility
  • Starting the Data Pump Import Utility
• Recovery Manager on BS2000
• Checking the Integrity of the Physical Data Structure
• Workload Replay Client
  • About Running Workload Replay Client
  • About Troubleshooting Workload Replay Client
• The Oracle Text Loader

7 Backing Up and Recovering a Database

• Backing Up an Oracle Database
  • Using BS2000 Utilities to Back Up an Oracle Database
  • Performing Online Backup
• Restoring an Oracle Database
• About Using the Recovery Manager

8 About Unified Auditing

• Enabling Unified Auditing
• Disabling Unified Auditing

9 Java in the Database

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

10 Oracle Text

• Installing Oracle Text
• Restrictions of Oracle Text on BS2000

11 XML

• About XDK Installation
• Features and Restrictions of XML Features on BS2000 Systems

12 Oracle Net Services

• Introducing Oracle Net Services
  • About Bequeath Protocol
    • Overview of the Bequeath Protocol
  • About IPC Protocol Support
    • Overview of IPC
    • Using the IPC Protocol
  • About TCP/IP Protocol Support
    • Overview of TCP/IP
    • Using the TCP/IP Protocol
  • About TCP/IP with SSL Protocol
  • About Oracle Advanced Security
• Shared Server Architecture
• Configuring the Network
  • About Using Easy Connect Naming Method
  • About Using the Local Naming Method
  • About Using the Directory Naming Method
  • Customizing Oracle Net Listener Configuration
  • Configuration on the Client
  • Testing the Configuration on the Client
• Troubleshooting Oracle Net Services

Part IV Application Development

13 Database Applications

• Overview of Database Applications
  • Architecture of the Programmatic Interfaces
  • PL/SQL Support
  • Building and Running a Programmatic Interface Application
• Precompiler Applications
  • About Using Precompilers
    • Include Files
    • User-Specific Configuration Files
    • Input, Output, and List-files
    • Additional Remarks
  • Precompiler Pro*C/C++
    • Starting Pro*C
    • Pro*C Include, System Configuration and Demo Files
    • SQLLIB Calls
    • Linking Pro*C Programs
    • The Pro*C SQLCPR.H Header File
    • UTM Applications
  • Precompiler Pro*COBOL
    • Starting Pro*COBOL
    • Pro*COBOL Include, System Configuration, and Demo Files
    • SQLLIB Calls
    • Linking Pro*COBOL Programs
    • openUTM Applications
• Oracle Call Interface Applications
  • Linking OCI Applications
• The Object Type Translator
  • Starting Object Type Translator
  • OTT System Configuration File
• Oracle Database Applications in POSIX Program Environment
• openUTM Database Applications
  • Operation of Oracle Database Using openUTM Programs
  • Distributed openUTM Files
  • DBA Responsibilities
  • 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
    • SQL Operations
      • CONNECT
      • COMMIT
      • ROLLBACK
      • SAVEPOINT
      • Cursor Operations
      • Dynamic SQL
      • PL/SQL
      • Autocommit
    • openUTM Operations
      • RSET and PEND RS
      • PEND ER and PEND FR
      • PEND KP, PEND PR, and PEND PA
      • PEND RE, PEND FI, PEND SP, and PEND FC
  • Troubleshooting
    • Trace Files
      • Trace File Examples
    • About Debugging
    • In-Doubt or Pending Transactions
    • Oracle Database SYS Account Tables

14 External Procedures

• Loading External Procedures

15 Globalization Support

• Language, Territory, and Character Set
  • Oracle Database
  • Other Oracle Database Products
• Supported Language Conventions
• Supported Territories
• Supported Character Sets
• Location of Message Files
• Linguistic Definitions

Appendices

A Oracle Error Messages for BS2000

B Oracle Environment Variables

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

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_DEST

D Troubleshooting

• Problems Creating Oracle Database 12c
• Problems Starting an Oracle Database Instance
• Problems When Starting the Background Tasks
• Problems Accessing Database and Log Files
• Oracle Database Trace Files

E File Types and Names Used by Oracle

Index