Table of Contents
- Title and Copyright Information
- Preface
- Part I Concepts
-
Part II Installation and Database Creation
-
2
Oracle Database Installation and Deinstallation
- 2.1 Overview of Oracle Database Installation
- 2.2 Planning the Installation
- 2.3 Oracle Database Preinstallation Requirements
- 2.4 About Read-Only Oracle Homes in the POSIX File System
- 2.5 Installing Oracle Database
- 2.6 Oracle Database Postinstallation Tasks
- 2.7 About Installing Multiple Oracle Databases
- 2.8 About Removing Oracle Database Software
-
3
About Creating a Database
- 3.1 Prerequisites for Database Creation
-
3.2
About Creating a Non-CDB
- 3.2.1 Creating a Database Automatically
-
3.2.2
Creating a Database Manually
- 3.2.2.1 Creating Parameter Files for a Non-CDB
- 3.2.2.2 Creating the Database
- 3.2.2.3 About Installing Data Dictionary Views
- 3.2.2.4 About Installing Online Help Messages
- 3.2.2.5 About Installing Demo Tables
- 3.2.2.6 About Installing Sample Schemas
- 3.2.2.7 About Verifying Database Creation
- 3.2.2.8 About Installing Oracle Text
- 3.2.2.9 About Installing Java
- 3.3 About Creating a Multitenant Container Database
- 4 About Upgrading a Database
- 5 About Upgrading Applications
-
2
Oracle Database Installation and Deinstallation
-
Part III Database Administration
- 6 Administering Oracle Database
-
7
Oracle Database Utilities
-
7.1
Basics of Oracle Database Utilities
- 7.1.1 The Oracle Database Environment-Definition File
- 7.1.2 Oracle Runtime Libraries
- 7.1.3 Starting Oracle Utilities in the BS2000 Program Environment
- 7.1.4 Starting Oracle Utilities in the POSIX Program Environment
- 7.1.5 Connecting to an Oracle Database Instance
- 7.1.6 Using BS2000 Files for Input and Output
-
7.2
SQL*Plus
-
7.2.1
Using SQL*Plus in the BS2000 Environment
- 7.2.1.1 Starting SQL*Plus in the BS2000 Environment
- 7.2.1.2 Interrupting a SQL*Plus Command in the BS2000 Environment
- 7.2.1.3 Running BS2000 Commands from SQL*Plus
- 7.2.1.4 Starting the BS2000 Editor
- 7.2.1.5 Spooling SQL*Plus Output
- 7.2.1.6 Specifying the Search Path for SQL Scripts in the BS2000 Environment
- 7.2.1.7 Starting SQL*Plus in a BS2000 command procedure
-
7.2.2
Using SQL*Plus in the POSIX environment
- 7.2.2.1 Starting SQL*Plus in the POSIX Environment
- 7.2.2.2 Interrupting a SQL*Plus Command in the POSIX Environment
- 7.2.2.3 Running Shell Commands From SQL*Plus
- 7.2.2.4 Using an Editor in SQL*Plus
- 7.2.2.5 Spooling SQL*Plus Output in the POSIX Environment
- 7.2.2.6 Specifying the Search Path for SQL Scripts in the POSIX Environment
- 7.2.3 SQL*Plus User Profiles
- 7.2.4 Using SQL*Plus Symbols
- 7.2.5 Sample Schemas and SQL*Plus
- 7.2.6 SQL*Plus Limits
-
7.2.1
Using SQL*Plus in the BS2000 Environment
- 7.3 The SQL*Loader
- 7.4 The Export Utility
- 7.5 The Import Utility
- 7.6 The Data Pump Export Utility
- 7.7 The Data Pump Import Utility
- 7.8 Recovery Manager on BS2000
- 7.9 Checking the Integrity of the Physical Data Structure
- 7.10 Workload Replay Client
- 7.11 The Oracle Text Loader
-
7.1
Basics of Oracle Database Utilities
- 8 Backing Up and Recovering a Database
- 9 About Unified Auditing
- 10 Java in the Database
- 11 Oracle Text
- 12 XML
- 13 Oracle Net Services
-
Part IV Application Development
-
14
Database Applications
- 14.1 Overview of Database Applications
- 14.2 Precompiler Applications
- 14.3 Oracle Call Interface Applications
- 14.4 The Object Type Translator
- 14.5 Oracle Database Applications in POSIX Program Environment
-
14.6
openUTM Database Applications
- 14.6.1 Operation of Oracle Database Using openUTM Programs
- 14.6.2 Distributed openUTM Files
- 14.6.3 DBA Responsibilities
- 14.6.4 Developing an Oracle Database/openUTM Application
- 14.6.5 Troubleshooting
- 15 External Procedures
- 16 Globalization Support
-
14
Database Applications
-
Appendices
- A Oracle Error Messages for BS2000
-
B
Oracle Environment Variables
- B.1 ORAENV Rules
- B.2 Built-in Variables
- B.3 General Variables
-
B.4
DBA Startup Variables
- B.4.1 Address and Size Specification
- B.4.2 BGJPAR
- B.4.3 BGJ_PROCEDURE
- B.4.4 BGJPRC_UID / BGJPRC_SID
- B.4.5 BGJ_LOG_JOBSTART
- B.4.6 sid_BGJPAR
- B.4.7 sid_USER
- B.4.8 user_ACCOUNT/ user_PASSWORD
- B.4.9 COM_MPID
- B.4.10 COM_BASE
- B.4.11 COM_SCOPE
- B.4.12 JOBID
- B.4.13 KNL_BASE
- B.4.14 ORACLE_HOME
- B.4.15 PGA_BASE
- B.4.16 PGA_SIZE
- B.4.17 SF_PBLKSIZE
- B.4.18 SGA_BASE
- B.5 Oracle Net Services Variables
- C Initialization Parameters and the Parameter File
- D Troubleshooting
- E File Types and Names Used by Oracle