This appendix describes each variable that can be specified in the ORAENV
file.
The variables fall into the following three classes:
Class | Description |
---|---|
DBA |
These variables are for database administration purposes. Most DBA variables are evaluated only during database startup. |
USER |
These variables can be specified by ordinary users as well as by the DBA. When these variables are specified in a particular user's ORAENV file, they modify that user's environment only. |
NET |
These variables apply to Oracle Net Services components. These variables should be included in the ORAENV file of the DBA. |
The class (or classes) to which a variable belongs is noted in the variable descriptions in this appendix.
Any DBA
or NET
variables specified in an ordinary user's ORAENV
file are ignored.
You should consider the following general rules when writing ORAENV
files:
All lines which begin with a slash or asterisk ('/' or '*') are ignored.
All variable names must be written in uppercase.
Spaces must not be included immediately before and after the equals sign ('=').
Do not enclose values in quotation marks unless you want the quotation marks to be part of the value.
As the variable list is conceptually open ended, errors in variable names are not recognized. This means that the value of any variable whose name is mis-typed is not modified.
There is only limited checking of variable assignments. An incorrect value may generate an error message, but may also be interpreted as a null value.
When variable assignments refer to other variables, BS2000 command file substitution syntax applies. Substitution takes place when a variable is actually used, not when it is read from the ORAENV
file.
For example:
ORAUID=$ORAC1020 SQLPATH=&ORAUID..RDBMS.ADMIN
This assigns the value $ORAC1020.RDBMS.ADMIN
to the variable SQLPATH
. If ORAUID
is changed, then SQLPATH
will automatically reflect the new value.
The sequence of items in the ORAENV
file is not generally significant. If an item occurs more than once, then the last occurrence is used.
If no value is given for a variable, then the default value is used, if it exists.
The following variables are always defined, and may be referenced in other variable assignments:
The LOGNAME
variable always contains the current BS2000 user ID. You cannot alter the value of this variable by assigning a different value to it in the ORAENV
file.
This variable specifies the BS2000 user ID where the Oracle Database programs, installation and demonstration files are installed. The initial value is derived from the ORALOAD
link name (the user ID part of the ORALOAD
library name). This value is usually correct, but if necessary, you can override it by assigning a different value to it in the ORAENV
file.
ORAUID=$userid or ORAUID=/BS2/$userid
The PGM
variable always contains the last part of the current START_PROGRAM
program name. You cannot alter the value of this variable by assigning a different value to it in the ORAENV
file.
The variables described in the following sections are for general, day-to-day use by Oracle database administrators and users.
This variable specifies the address of the shared code pool of customer written database applications for CORE
, NLS
, and NET
.
CLN_BASE=address
USER
CLN_BASE=37M
This variable specifies the identification of the shared code pool of customer written database applications for CORE
, NLS
, and NET
.
CLN_MPID=sid
USER
CLN_MPID=&ORASID
This variable provides a default host string for connect requests where no host string is specified. If you always connect to the same database, then it may be convenient to specify this. This value should contain everything you would otherwise specify after the at character (@).
DEFAULT_CONNECTION=host-string
USER
DEFAULT_CONNECTION=TNS: (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=MADRID) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD)))
This variable should be set to FALSE
when you use the Export utility to overcome a problem with the C library functions when an export file is written to tape.
EXP_CLIB_FILE_IO=FALSE
USER
EXP_CLIB_FILE_IO=TRUE
This variable should be set to FALSE
when you use the Import utility to overcome a problem with the C library functions when an import file is read from tape.
IMP_CLIB_FILE_IO=FALSE
USER
IMP_CLIB_FILE_IO=TRUE
This variable specifies the default language and character set. For example:
NLS_LANG=GERMAN_GERMANY.D8BS2000
NLS_LANG=language_territory.character-set
USER
, DBA
NLS_LANG=AMERICAN_AMERICA.WE8BS2000
This variable is used for concatenation with the OS_AUTHENT_PREFIX
see initialization parameter. The default value concatenates the value of the parameter OS_AUTHENT_PREFIX
with the BS2000 user ID. Using OPS_JID
, you can specify that the BS2000 job name (/.jobname LOGON...
) is used instead. This is useful when many users are sharing one BS2000 user ID.
OPS_JID=userid/jobname
DBA
userid
This variable specifies the dump file for the Oracle Database and user trace output.
ORADUMP=dump-file
USER
, DBA
ORADUMP=OTRC.?.&TSN..&PGM..TRC
Example:
ORADUMP=(SYSOUT)
This assignment redirects the trace output to SYSOUT
.
This variable defines the database that will be used if no database identification is given at connect time.
ORASID=sid (sid is a characterstring where 1 <= length <= 4)
USER
, DBA
Note:
This variable is mandatory for the Oracle Database tasks, the background tasks, and the network tasks - it defines the database on which they are operating. It is not essential that a user setsORASID
, because the required database can always be specified in the connect string.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
PRINTPAR=print-options
USER
This variable specifies a path where SQL*Plus will look for command files. Elements of the path are separated by semicolons (;).
For example,
SQLPATH=PRIVATE;$ORAC1020
This assignment will cause SQL*Plus to look for filename
.SQL
, then for PRIVATE
.filename
.SQL
, and finally for $ORAC1020.
filename
.SQL
.
SQLPATH=search-path
USER
, DBA
This variable specifies the password file for remote instance start. For further information, refer to Chapter 5, "Administering the Oracle Database"in the Oracle Database Installation and Administration Guide for Fujitsu Siemens BS2000/OSD .
SSSIDPWF=password-file
DBA
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.
It is recommend 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 sections are built-in defaults; most of them are over-ridden by settings in the shipped DEMO.P.ORAENV
.
Several of the variables described in this section define memory addresses and sizes. The notation used to specify these items is as follows:
a number with no modifiers is interpreted as a decimal number
a number followed by K or M is interpreted as a decimal number multiplied by 1024 or 1048576 (1024*1024) respectively
a number enclosed in single quotation marks and preceded by the letter X is interpreted as a hexadecimal number
For example, the following all set the KNL_BASE
variable to 8M:
KNL_BASE=8M KNL_BASE=8388608 KNL_BASE=X'800000'
This variable specifies the parameters for the ENTER-PROCEDURE
command used when starting background jobs. The ENTER-PROCEDURE
command is used to submit jobs as follows:
.jobname ENTER-PROCEDURE jobfile, &BGJPAR
BGJPAR=parameters
DBA
Note:
TheBGJPAR
variable is usually set up by the installation procedure.These variables specify the user ID and orasid of the file for the background enter jobs. If the use of a special enter job file is desired, then the parameters must be set to the desired userid
and orasid
.
BGJPRC_UID=$userid BGJPRC_SID=sid
DBA
, NET
BGJPRC_UID=&ORAUID BGJPRC_SID=DEMO
This variable specifies whether the operating system message that a new job was accepted should be logged on SYSOUT or not.
BGJ_LOG_JOBSTART=Y/N
DBA
, USER
, NET
BGJ_LOG_JOBSTART=N
This variable specifies the parameters, which will be used by the ENTER-PROCEDURE
command to start a server process for the instance specified by sid
.
sid _BGJPAR=parameters
sid
, a string of at most 4 alphanumeric characters
parameters
, parameters for the ENTER-PROCEDURE
command as described in the BS2000/OSD commands
DBA
, USER
, NET
This variable specifies the USER-ID where the instance assigned by sid
resides.
sid _USER=userid
sid
, a string of at most 4 alphanumeric characters
userid
, a string of at most 8 alphanumeric characters which follows the rules of a BS2000/OSD USER-ID.
DBA
, USER
, NET
These parameters define credentials of a USER-ID
, which will be used by the ENTER-PROCEDURE
command to start a process.
user _ACCOUNT=account user _PASSWORD=password
user
, a string of at most 8 alphanumeric characters which follows the rules of a BS2000/OSD USER-ID and must match a USER-ID defined by the parameter sid
_USER
.
account
, a string of at most 8 alphanumeric characters which follows the rules for a BS2000/OSD account number.
password
, a string of at most 8 alphanumeric characters which follows the rules for a BS2000/OSD password.
DBA
, NET
This parameter specifies the identification of the shared code pool of the Oracle instance for CORE
, NLS
, NET
.
COM_MPID=sid
USER
, DBA
COM_MPID=&ORASID
This parameter specifies the address of the shared code pool of the Oracle instance for CORE
and NLS
COM_BASE=address
DBA
COM_BASE=37M
This variable specifies if the instance can run in RAC mode (Refer to Oracle Database Installation and Administration Guide for Fujitsu Siemens BS2000/OSD).
ENABLE_RAC=TRUE/FALSE
DBA
ENABLE_RAC=FALSE
This variable is used internally in identifying the background tasks and generating task-specific names. You will see it in some places, but you should never specify it yourself.
DBA
This variable gives the base address where the shared memory pool is mapped in memory. This must be an integral number of megabytes.
KNL_BASE=address
DBA
KNL_BASE=72M
This parameter specifies a directory in the POSIX file system which is used for installation and operation purposes of Java and Oracle Intelligent Agent (for more information refer to "Installation and Administration Guide".)
ORACLE_HOME=/path-name
DBA
ORACLE_HOME=/orac1020
This variable specifies the base address of the fixed part of the PGA. The PGA is task-specific, but must be located at a fixed memory address so that the kernel can access it. The base address must lie on a 64Kb boundary.
PGA_BASE=address
DBA
PGA_BASE=189M
Note:
The value ofPGA_BASE
is taken from the kernel if the shared kernel is already loaded.This variable specifies the size of the fixed part of the PGA. This variable should not be changed from its default value.
PGA_SIZE=size
DBA
PGA_SIZE=64K
Note:
The value ofPGA_SIZE
is taken from the kernel if the shared kernel is already loaded.This variable specifies the physical block size of redo log files.
SF_PBLKSIZE=2K|4K
DBA
2K
Note:
This variable cannot be changed after database creation. Once you specify a value different from the default, you must specify it in all future calls.This variable gives the address where the SGA is mapped into memory, and must represent a megabyte-boundary.
SGA_BASE=address
DBA
SGA_BASE=190M
Note:
The value ofSGA_BASE
is read from the kernel if the shared kernel is already loaded. There is no corresponding SGA_SIZE
variable; the size of the SGA memory pool is calculated when the database is started.The following are the Oracle Net Services variables:
This variable deactivates the signal routine for user interrupts, which sends a break over the network. An interrupt can be released by pressing the [K2] key.
BREAK_HANDLING=ON|OFF
DBA
, USER
, NET
BREAK_HANDLING=ON
This variable specifies the user ID of the Oracle Net Services configuration files. For example, LISTENER.ORA
, TNSNAMES.ORA
, and SQLNET.ORA
. If TNS_ADMIN
is not defined, then the configuration files are searched under the local user ID with the prefix NETWORK.ADMIN
.
TNS_ADMIN=$userid.
USER
, DBA
, NET