User`s guide

The Oracle Database Environment-Definition File
1-2 Oracle Database User's Guide
/CALL-PROCEDURE $ORAC1120.INSTALL.P.USER
where $ORAC1120 is the name of Oracle Database 11g Release 2 (11.2) installation
user ID.
You are prompted for the database system identifier, known as the SID .
2. Enter the SID . If you do not know what the SID is, then consult the database
administrator.
1.1.2 Calling the Environment-Definition File
Call the ORAENV file ( sid.P.ORAENV ) by entering the CALL-PROCEDURE command on the
ORAENV file. For example, to call the example ORAENV file for the database DEMO , enter
the following command:
/CALL-PROCEDURE DEMO.P.ORAENV
1.1.3 Specifying the Environment Variables
The following is the content of the ORAENV file available with Oracle Database:
/SET-PROC-OPT DATA-ESCAPE=*STD
/DECL-PAR (SYSCMD(INI-VAL='DEMO.P.ORAENV'))
/ REMARK * SYSCMD must be name of this file
/ WRITE-TEXT ' '
/ WRITE-TEXT ' +----------------------------------------+ '
/ WRITE-TEXT ' I Oracle Database 11g Release 2 (11.2) I '
/ WRITE-TEXT ' I environment setup I '
/ WRITE-TEXT ' +----------------------------------------+ '
/ WRITE-TEXT ' '
/ SET-FILE-LINK ORAENV,&SYSCMD
/ SET-FILE-LINK ORALOAD,$ORAC1120.ORALOAD.LIB
/ SET-FILE-LINK ORAMESG,$ORAC1120.ORAMESG.LIB
/&* MOD-SDF $ORAC1120.SYSSDF.ORACLE.USER
/&* *** if SYSOUT protocol is desired set BGJOUT='KEEP' ***
/&* SET-VAR BGJOUT='DEL'
/ EXIT-PROCEDURE
*
* parameters for users:
*
ORAUID=/BS2/$ORAC1120
ORASID=DEMO
NLS_LANG=German_Germany.D8BS2000
* PRINTPAR=
/END-PROCEDURE
If you want, you can change Oracle Database 11g Release 2 (11.2) working
environment by editing the user variables in this file. The
Appendix B, "Oracle
Environment Variables" contains a list of the variables you can specify in the ORAENV
file. The values you assign to user variables are specific to your task only. The
database administrator can also set other variables that affect the whole database
instance. If you try to set values for the DBA-specific variables in the
ORAENV file, then
they are ignored.