User`s guide

vi
4.2.1 Upgrade from Version 9 ..................................................................................................... 4-8
4.2.2 Upgrade from Version 10 ................................................................................................... 4-8
4.2.3 Postupgrade Activities........................................................................................................ 4-9
5 Administering Oracle Database
5.1 Using the SQL*Plus Utility........................................................................................................ 5-1
5.1.1 Starting the SQL*Plus Utility in BS2000 ........................................................................... 5-1
5.1.2 Calling SQL*Plus from a Procedure.................................................................................. 5-2
5.1.3 Using SQL*Plus in the POSIX shell................................................................................... 5-2
5.1.4 Running System Commands from SQL*Plus.................................................................. 5-2
5.1.5 Using an Editor in SQL*Plus.............................................................................................. 5-3
5.1.6 Customizing SQL*Plus Profiles......................................................................................... 5-3
5.2 Startup and Parameter Files ...................................................................................................... 5-3
5.2.1 The Environment Definition File ORAENV.................................................................... 5-4
5.2.2 The Initialization File INIT.ORA....................................................................................... 5-4
5.2.3 The Server Parameter File SPFILE..................................................................................... 5-4
5.2.4 Using the Correct Initialization File.................................................................................. 5-4
5.3 Remote Startup of a Database Instance ................................................................................... 5-5
5.4 Automatic Diagnostic Repository ............................................................................................ 5-6
5.4.1 Automatic Diagnostic Repository Directories and Files................................................ 5-6
5.4.2 ADR Command Interpreter ............................................................................................... 5-7
5.5 Checking the Integrity of the Physical Data Structure.......................................................... 5-8
6 Backing Up and Recovering a Database
6.1 Backing Up an Oracle Database................................................................................................ 6-1
6.1.1 Using BS2000 Utilities to Back Up an Oracle Database.................................................. 6-1
6.1.2 Online Backup...................................................................................................................... 6-2
6.2 Recovering Databases................................................................................................................. 6-2
6.3 Recovery Manager...................................................................................................................... 6-3
7 Tuning Oracle Database
7.1 BS2000/OSD-Specific Parameters ............................................................................................ 7-1
7.1.1 Task Priority ......................................................................................................................... 7-1
8 openUTM Product Set
8.1 Operation of Oracle Database Using openUTM Programs .................................................. 8-1
8.2 Distributed openUTM Files....................................................................................................... 8-1
8.3 Installing....................................................................................................................................... 8-2
8.4 Developing an Oracle Database/openUTM Application..................................................... 8-2
8.4.1 Defining an Open String..................................................................................................... 8-4
8.4.1.1 Required Fields............................................................................................................. 8-5
8.4.1.2 Optional Fields.............................................................................................................. 8-5
8.4.1.3 Examples........................................................................................................................ 8-6
8.4.2 Using Precompilers with openUTM................................................................................. 8-7
8.4.2.1 Using Pro*C with the Default Database.................................................................... 8-7
8.4.2.2 Using Pro*C with a Named Database ...................................................................... 8-7