User`s guide
Note: The Oracle variable
BGJPAR
is not set after running the
.profile.oracle.
If you do not set this variable, then the default
value
, BGJPAR=START=IMME,CPU-LIMIT=NO,LOGGING=*NO,
is used by
Oracle utilities.
Oracle Database Environment Definition File
2-8 Oracle Database Installation and Administration Guide
You can change the default value of a variable by setting this variable in the POSIX
environment. For example:
$ NLS_LANG=German_Germany.WE8BS2000
$ export NLS_LANG
Oracle also provides the opportunity to use the
ORAENV
file which you created in the
BS2000 file system. In this case, you must create a file
oraenvsid
in the directory
$ORACLE_HOME/dbs
that describes the location and name of the
ORAENV
file.
Let us assume that you want to use the
ORAENV
file
$ORADATA.ORCL.P.ORAENV
. Create
an
oraenvORCL
file in
$ORACLE_HOME/dbs
that contains the name of the BS2000
ORAENV
file as follows:
$ ORACLE_HOME=/u01/app/orac1120/db11g
$ export ORACLE_HOME
$ echo '$ORADATA.ORCL.P.ORAENV' > $ORACLE_HOME/dbs/oraenvORCL
Set the Oracle environment variable
ORACLE_SID
and call the utility:
$ ORACLE_SID=ORCL
$ export ORACLE_SID
$ $ORACLE_HOME/bin/sqlplus /nolog
Oracle utilities running in the POSIX shell handle the variables of the BS2000
ORAENV
file as lower-ranking variables. If a variable is set in the POSIX environment and the
same variable is defined in the
ORAENV
file, then the POSIX variable is not overwritten
by the
ORAENV
variable. For example, if the variable
NLS_LANG
is set to
German_
Germany.WE8BS2000
in the POSIX environment and
NLS_LANG
is also defined as
American_America.WE8BS2000
in the BS2000
ORAENV
file, then the variable keeps the
value
German_Germany.WE8BS2000
in the program environment of the Oracle utility
running in the POSIX shell.
Note:
■ The variables
ORACLE_HOME
and
ORACLE_SID
must be set.
■ The
ORAENV
file in the BS2000 file system must be accessible for the
utility.
■ In a POSIX environment, the variables of the BS2000
ORAENV
file
are handled as subordinated variables.
■ To access a BS2000
ORAENV
file, you must create a file
oraenvsid
in
the
ORACLE_HOME/dbs
directory that contains the fully qualified
name of your BS2000
ORAENV
file.
■ The
SID
in the file name
oraenvsid
is case sensitive and must
match the
SID
specified in
ORACLE_SID
.