Skip Headers

Oracle8i Server User's Guide
Release 3 (8.1.7) for Fujitsu Siemens Computers BS2000/OSD

Part Number A95463-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.

NET8

These variables apply to two-task and Net8 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:

Default behaviour for DEFAULT_CONNECTION variable has changed since version 8.0.4.

Since Oracle8i you have to indicate DEFAULT_CONNECTION=S: to choose single task mode. When DEFAULT_CONNECTION parameter does not exist or is empty, two task mode with the bequeath adapter is used. This means the Oracle requests of your application are executed by a seperate server task without having to start a listener and provide the Net8 control files. For further information see Chapter Net8 in Oracle8i Installation and Database Administration Guide.

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_CONVERSION

This variable specifies whether the conversion between different character sets is done at the client side(the default) or at the server side. Performing the conversion at the server side (NLS_CONVERSION=SERVER) may improve preformance at the client side. You can specify server side conversion only in a two-task environment and if the server knows the session character set of the client.


Note:

Specifying server side NLS conversion in single-task mode results in an endless loop.


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

This assignment will cause SQL*Plus to look for filename.SQL, then for PRIVATE.filename.SQL, and finally for $ORACL817.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"in the Oracle8i Server for Fujitsu Siemens Computers BS2000/OSD Installation and Database Administration Guide.

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'

BGJPAR

This variable specifies the variables which will be used by the ENTER command used when starting background jobs. The ENTER command is used to submit jobs as follows:

.jobname ENTER jobfile, &BGJPAR 
Format:
Classification:

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

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