Skip Headers

Oracle9i Installation and Database Administration Guide
Release 2 (9.2.0.2.10) for Fujitsu Siemens Computers BS2000/OSD

Part Number B12034-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

B
ORAENV Variables

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.

ORAENV Rules

You should consider the following general rules when writing ORAENV files:

Built-in Variables

The following variables are always defined, and may be referenced in other variable assignments:

LOGNAME

The LOGNAME variable always contains the current BS2000 userid. You cannot alter the value of this variable by assigning a different value to it in your ORAENV file.

ORAUID

This variable specifies the BS2000 userid where the Oracle Server programs, installation and demonstration files are installed. The initial value is derived from the ORALOAD linkname (the userid 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 your ORAENV file.

Format:

PGM

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 your ORAENV file.

TERM

The TERM variable contains the terminal type, and defaults to 'SNI9750'. This default value is usually correct, but if necessary, you can override it by assigning a different value to it in your ORAENV file.

TSN

The TSN variable contains the task sequence number of the current task. You cannot alter the value of this variable by assigning a different value to it in your ORAENV file.

General Variables

The variables described below are for general, day-to-day use by Oracle Server DBAs and users.

DEFAULT_CONNECTION

This variable provides a default host string for connect requests where no host string is specified. If you always connect to the same database, it may be convenient to specify this. This value should contain everything you would otherwise specify after the "@" character.

Format:
Classification:
Example:

EXP_CLIB_FILE_IO

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.

Format:
Classification:
Default:

IMP_CLIB_FILE_IO

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.

Format:
Classification:
Default:

IMP_USERID_IGNORE

This variable is used by the Import utility for full database imports. When set to "Yes", the Import utility will strip the BS2000 userid from the tablespace filenames contained in the export dump file. This value must only be specified when importing full database exports created on a BS2000/OSD system.

Format:
Classification:
Default:

NLS_LANG

This variable specifies the default language and character set. For example:

NLS_LANG=GERMAN_GERMANY.D8BS2000 
Format:
Classification:
Default:

OPS_JID

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 userid. Using OPS_JID, you can specify that the BS2000 jobname (/.jobname LOGON...) is used instead. This is useful when many users are sharing one BS2000 userid.

Format:
Classification:
Default:

ORADUMP

This variable specifies the dump file for the Oracle Server and user trace output.

Format:
Classification:
Default:

Example:

ORASID

This variable defines the database that will be used if no database identification is given at connect time.

Format:
Classification:

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:
Classification:

SQLPATH

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;$ORACL920 

This assignment will cause SQL*Plus to look for filename.SQL, then for PRIVATE.filename.SQL, and finally for $ORACL920.filename.SQL.

Format:
Classification:

SSSIDPWF

This variable specifies the password file for remote instance start. For further information, see Chapter 5, "Administering the Oracle Server".

Format:
Classification:

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.

We 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 below are "built-in" defaults; most of them are over-ridden by settings in the shipped DEMO.P.ORAENV.

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:

For example, the following all set the KNL_BASE variable to 8M:

KNL_BASE=8M
KNL_BASE=8388608
KNL_BASE=X'800000'

ALARM_TIMER_LIMIT

This variable specifies if a precise method for handling of timeouts should be used. The parameter is important for RAC (see chapter "Real Application Cluster (RAC)").

Format:
Classification:
Default:

BGJPAR

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
Format:
Classification:

Go to previous page Go to next page
Oracle
Copyright © 2003 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index