User`s guide
Note: The value of
ADDRSPACE
must be at least 512 MB.
Creating a Database
4-2 Oracle Database Installation and Administration Guide
3. Oracle recommends that the BS2000 System Administrator should define a
separate job class for the background tasks. This job class should have the
following characteristics:
TP-ALLOWED=YES
NO-CPU-LIMIT=YES
JOB-TYPE=BATCH
4.1.2 Creating a Database Automatically
Complete the following steps to create a database automatically:
1. Log in using the DBA user ID.
2. To start the automatic creation procedure,
INSTALL.P.SUPER
, enter the following
command:
/CALL-PROCEDURE $ORAC1120.INSTALL.P.SUPER
When running
INSTALL.P.SUPER
procedure, you can specify the value of the
following keyword parameters (the default values are used if you choose not to
modify the values):
Parameter Value
BATCH Enter YES to r
un the procedure in batch mode. The default is set to
YES
, so by default the procedure is run in batch mode.
CPULIMIT Sets the time limit for batch jobs. The default is NO.
PLSQL Enter NO to suppress automatic installation of the basic PL/SQL
package. The default is
YES
.
VIEWS Enter NO to su
ppress automatic installation of the basic views
(catalog, import/export, and so on). The default is
YES
.
3.
Answer the prompts for the following information (if you enter nothing, the
default shown on the screen are used):
Parameter Value
DBASID Enter the 1 - 4 character system-id of
the database you are installing.
This is a mandatory parameter.
JOBCLASS Enter the jobclass to be used for Oracle Database 11g Release 2
background jobs. This is mandatory.
UPDATE Enter YES if you have existing files for this
SID
and you want to
update them.
SYSPW Enter the desired password for the Oracle Database user
SYS
.
Note:
By default the
SYS
user has the password
CHANGE_ON_INSTALL
.
For security reasons, Oracle recommends that you change this
password immediately after installation.
SYSTEMPW Enter the desired password for the Oracle Database user
SYSTEM
.
Note:
By default the
SYSTEM
user has the password
MANAGER
. For
security reasons, Oracle recommends that you change this password
immediately after installation.