User`s guide

Creating a Database
Creating and Upgrading a Database 4-5
/CALL-PROCEDURE $ORAC1120.INSTALL.P.DBA
This procedure prompts you for the following information:
Parameter Value
DBASID Enter the 1 - 4 character system ID of the database you are
installing.
JOBCLASS Enter the BS2000 jobclass to be used for background and server
t
asks.
You can also modify the following keyword parameters when invoking this
procedure:
Parameter Value
LOG Enter WRITE-TEXT
(the BS2000 command name) if you want to
have install actions listed.
UPDATE Enter YES/NO to indicate whether existing files are to be
updated. The default is NO.
The $ORAC1120.INSTALL.P.DBA procedure copies the following files into the DBA
User ID
account:
■ sid.P.ORAENV : Oracle Database environment definition file
■ sid.DBS.INIT.ORA : Oracle Database initialization file
where
sid is the database ID for the database being installed.
4.1.3.2 Creating the Database
After installing the DBA procedures, you must create the database. This section
describes the procedure for creating the database, and for allocating the database file
and the log files.
4.1.3.2.1 Pre-Allocating the Files You can place the database file and the log files on the
defau
lt volume set for the
DBA account, another Public Volume Set (PVS), or a specific
private volume.
To create a database file or a log file on a private disk, you
must first allocate the file
using the BS2000
/FILE command as shown:
/FILE sid.DBS.DATABASE1.DBF,SPACE=filesize -
/[,DEVICE=dev
ice,VOLUME=volser]
/FILE sid.DBS.SYSAUX.DBF,SPACE=filesize -
//[,DEVICE=de
vice,VOLUME=volser]
/FILE si
d.DBS.LOG1.DBF,SPACE=filesize -
/[,DEVICE=device, VOLUME=volser]
/FILE si
d.DBS.LOG2.DBF,SPACE=filesize -
/[,DEVICE=dev
ice, VOLUME=volser]
where:
sid identifies the database that you are installing.
filesize is the size of the file in PAM blocks. The file size specified in the /FILE
command must match the size specified to SQL*Plus in the
CREATE DATABASE
statement when creating the database, plus 1 extra Oracle Database block used as an
extra header. The size of this block is 1 to 16 PAM pages depending on the Oracle