Table of Contents
- List of Figures
- 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 Installing Oracle Database
- 2.5 Oracle Database Postinstallation Tasks
- 2.6 About Installing Multiple Oracle Databases
- 2.7 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
-
2
Oracle Database Installation and Deinstallation
-
Part III Database Administration
- 5 Administering Oracle Database
-
6
Oracle Database Utilities
-
6.1
Basics of Oracle Database Utilities
- 6.1.1 The Oracle Database Environment-Definition File
- 6.1.2 Oracle Runtime Libraries
- 6.1.3 Starting Oracle Utilities in the BS2000 Program Environment
- 6.1.4 Starting Oracle Utilities in the POSIX Program Environment
- 6.1.5 Connecting to an Oracle Database Instance
- 6.1.6 Using BS2000 Files for Input and Output
-
6.2
SQL*Plus
-
6.2.1
Using SQL*Plus in the BS2000 Environment
- 6.2.1.1 Starting SQL*Plus in the BS2000 Environment
- 6.2.1.2 Interrupting a SQL*Plus Command in the BS2000 Environment
- 6.2.1.3 Running BS2000 Commands from SQL*Plus
- 6.2.1.4 Starting the BS2000 Editor
- 6.2.1.5 Spooling SQL*Plus Output
- 6.2.1.6 Specifying the Search Path for SQL Scripts in the BS2000 Environment
- 6.2.1.7 Starting SQL*Plus in a BS2000 command procedure
-
6.2.2
Using SQL*Plus in the POSIX environment
- 6.2.2.1 Starting SQL*Plus in the POSIX Environment
- 6.2.2.2 Interrupting a SQL*Plus Command in the POSIX Environment
- 6.2.2.3 Running Shell Commands From SQL*Plus
- 6.2.2.4 Using an Editor in SQL*Plus
- 6.2.2.5 Spooling SQL*Plus Output in the POSIX Environment
- 6.2.2.6 Specifying the Search Path for SQL Scripts in the POSIX Environment
- 6.2.3 SQL*Plus User Profiles
- 6.2.4 Using SQL*Plus Symbols
- 6.2.5 Sample Schemas and SQL*Plus
- 6.2.6 SQL*Plus Limits
-
6.2.1
Using SQL*Plus in the BS2000 Environment
- 6.3 The SQL*Loader
- 6.4 The Export Utility
- 6.5 The Import Utility
- 6.6 The Data Pump Export Utility
- 6.7 The Data Pump Import Utility
- 6.8 Recovery Manager on BS2000
- 6.9 Checking the Integrity of the Physical Data Structure
- 6.10 Workload Replay Client
- 6.11 The Oracle Text Loader
-
6.1
Basics of Oracle Database Utilities
- 7 Backing Up and Recovering a Database
- 8 About Unified Auditing
- 9 Java in the Database
- 10 Oracle Text
- 11 XML
- 12 Oracle Net Services
-
Part IV Application Development
-
13
Database Applications
- 13.1 Overview of Database Applications
- 13.2 Precompiler Applications
- 13.3 Oracle Call Interface Applications
- 13.4 The Object Type Translator
- 13.5 Oracle Database Applications in POSIX Program Environment
-
13.6
openUTM Database Applications
- 13.6.1 Operation of Oracle Database Using openUTM Programs
- 13.6.2 Distributed openUTM Files
- 13.6.3 DBA Responsibilities
- 13.6.4 Developing an Oracle Database/openUTM Application
- 13.6.5 Troubleshooting
- 14 External Procedures
- 15 Globalization Support
-
13
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
- Index