User`s guide

v
3.3.2.3 Package Requirements................................................................................................. 3-6
3.3.2.4 Additional BS2000 Software Components................................................................ 3-7
3.3.2.5 Compiler and CRTE Requirements for Oracle Database Applications................ 3-7
3.3.2.6 Additional Software Requirements ........................................................................... 3-8
3.3.3 Checking Network Setup ................................................................................................... 3-8
3.3.3.1 Checking Sockets subsystem ...................................................................................... 3-8
3.3.3.2 Checking BCAM Timer ............................................................................................... 3-8
3.3.3.3 Checking LWRESD....................................................................................................... 3-8
3.3.3.4 Checking Loopback Address...................................................................................... 3-9
3.3.3.5 Checking the Configuration Files in the POSIX File System.................................. 3-9
3.3.4 Creating Required Operating System Users and Groups.............................................. 3-9
3.3.4.1 Creating the BS2000 Installation User ID.................................................................. 3-9
3.3.4.2 Creating the POSIX System Group............................................................................ 3-9
3.3.4.3 Initializing the POSIX User ...................................................................................... 3-10
3.3.4.4 Creating Users and Groups for Oracle Databases ................................................ 3-10
3.3.5 Identify Required Directories in POSIX ........................................................................ 3-11
3.3.5.1 Oracle Base Directory................................................................................................ 3-11
3.3.5.2 Oracle Inventory Directory ...................................................................................... 3-12
3.3.5.3 Oracle Home Directory............................................................................................. 3-13
3.3.6 Identifying or Creating Oracle Base Directory in POSIX............................................ 3-13
3.3.6.1 Identifying an Existing Oracle Base Directory in POSIX..................................... 3-13
3.3.6.2 Create or Expand a File System for the Oracle Base Directory........................... 3-14
3.4 Installing the Oracle Database Software............................................................................... 3-15
3.5 Oracle Database Postinstallation Tasks ................................................................................ 3-17
3.6 Installing Multiple Oracle Systems ....................................................................................... 3-18
3.7 Removing Oracle Database Software.................................................................................... 3-18
4 Creating and Upgrading a Database
4.1 Creating a Database.................................................................................................................... 4-1
4.1.1 Pre-Creation Activities........................................................................................................ 4-1
4.1.2 Creating a Database Automatically .................................................................................. 4-2
4.1.3 Creating a Database Manually........................................................................................... 4-4
4.1.3.1 Copying the DBA Procedures..................................................................................... 4-4
4.1.3.2 Creating the Database.................................................................................................. 4-5
4.1.3.2.1 Pre-Allocating the Files ........................................................................................ 4-5
4.1.3.2.2 Modifying the Initialization File ......................................................................... 4-6
4.1.3.2.3 Modifying the ORAENV File .............................................................................. 4-6
4.1.3.2.4 Using SQL*Plus to Create the Database............................................................. 4-6
4.1.3.3 Installing Data Dictionary Views............................................................................... 4-7
4.1.3.4 Installing Data Dictionary Views for PL/SQL......................................................... 4-7
4.1.3.5 Installing Online Help Messages................................................................................ 4-7
4.1.3.6 Installing the Demo Tables.......................................................................................... 4-7
4.1.3.7 Installing the Sample Schemas ................................................................................... 4-7
4.1.3.8 Verifying Successful Creation of the Database ........................................................ 4-7
4.1.3.9 Installing Oracle Text................................................................................................... 4-8
4.1.3.10 Installing Java................................................................................................................ 4-8
4.2 Upgrading a Database................................................................................................................ 4-8