User`s guide

DBA Startup Variables
Oracle Environment Variables B-5
Format:
ORASID
=
sid
(
sid
is a characterstring where 1 <= length <= 4)
Classification:
USER, DBA
B.3.10 PRINTPAR
This variable specifies optional variables for the
/PRINT
command issued for
SPOOL
OUT
spool files. Using this variable, the user can modify the spooled job, and, for
example, route the job to a remote printer, add print options for laser printers, and so
on. The BS2000
/PRINT
command for spool files is issued as follows:
/PRINT temp.spoolfile,&PRINTPAR
Format:
PRINTPAR
=
print-options
Classification:
USER
B.3.11 SQLPATH
This variable specifies a path where SQL*Plus looks for command files. Elements of
the path are separated by semicolons (;). For example:
SQLPATH=PRIVATE;$ORAC1120
This assignment will cause SQL*Plus to look for filename.SQL, then for
PRIVATE
.
filename
.
SQL
, and finally for
$ORAC1120
.
filename
.
SQL
.
Format:
SQLPATH
=
search-path
Classification:
USER, DBA
B.3.12 SSSIDPWF
This variable specifies the password file for remote instance start. For further
information, refer to "Administering Oracle Database" in Oracle Database Installation
and Administration Guide for Fujitsu BS2000/OSD.
Format:
SSSIDPWF
=
password-file
Classification:
DBA
B.4 DBA Startup Variables
The following variables are used during database and network startup. They
supplement (and in some cases provide defaults for) variables contained in the
initialization file.
Oracle recommends that database startup and shutdown, background jobs, and
network jobs should all refer to the same
ORAENV
file to ensure that the variables are
consistent.
Note that the default values listed in the following section are built-in defaults, most of
them are over-ridden by settings in the shipped
DEMO
.
P
.
ORAENV
.
B.4.1 Address and Size Specification
Several of the variables described in this section define memory addresses and sizes.
The notation used to specify these items is as follows:
Note: Oracle recommends that you use the
ORACLE_SID
variable.