User`s guide

Configuring the Network
9-8 Oracle Database Installation and Administration Guide
The following example of an ORAENV file configured for a central listener process
shows how the parameters work. The listener can share this
ORAENV file with an
instance, which runs under the same user ID. For a better understanding, we
assume that the listener and the instances
DEMO and DEM1 are running under the
user ID
ORACDEM1 while the instance DEM2 is running under the user ID ORACDEM2 .
We define the following parameters:
BGJPAR=J-C=JCBORA,START=IMME,CPU-LIMIT=NO,LOGGING=*NO
DEM1_BGJPAR=J-C=JCBDEM1,START=IMME,CPU-LIMIT=NO
DEM2_USER=ORACDEM2
ORACDEM2_ACCOUNT=O1234
ORACDEM2_PASSWORD=ORACLE
The listener always runs the same sequence to look up the parameters sid_BGJPAR
and
sid_USER . If no value for sid_BGJPAR is found, then the listener uses the value
given by the parameter
BGJPAR . If a user ID is given by sid_USER , then the listener
tries to get the processing admission from the parameters
user_ACCOUNT and user_
PASSWORD
. For the given ORAENV we get the following scenarios for the listener:
■ The listener should start a server for the instance DEMO . Because the parameters
DEMO_BGJPAR and DEMO_USER are not defined the listener starts the server for
the instance
DEMO under the user ID ORACDEM1 with the start parameters
defined by
BGJPAR .
■ If a server for the instance DEM1 must be started, then the listener looks for the
parameters
DEM1_BGJPAR and DEM1_USER . In this case the parameter DEM1_
BGJPAR
can be evaluated, whereas, the evaluation of DEM1_USER failed because
this parameter is not defined. Therefore, the listener adds the start parameters
"
J-C=JCBDEM1,START=IMME,CPU-LIMIT=NO " to the ENTER-PROCEDURE command
and starts the job under the user ID
ORACDEM1 .
■ Now a server for instance DEM2 must be started. The listener looks for the
parameters
DEM2_BGJPAR and DEM2_USER . The parameter DEM2_BGJPAR is not
defined so that the listener uses the start parameters defined by
BGJPAR . On
the other hand the parameter
DEM2_USER can be evaluated successfully and
returns the value
ORACDEM2 . Now the listener tries to get the processing
admission by evaluating the parameters
ORACDEM2_ACCOUNT and ORACDEM2_
PASSWORD
. The listener starts the server job under the user ID ORACDEM2 with
the
ENTER-PROCEDURE parameters " J-C=JCBORA,
START=IMME,CPU-LIMIT=NO,LOGGING=*NO
".
Start the listener using the Listener Control Utility LSNRCTL :
/CALL-PROCEDURE sid.P.ORAENV
/START-PROGRAM $ORAC1120.LSNRCTL
When the enter options prompt is displayed, press ENTER to get to the LSNRCTL
prompt. Enter the following command to start the Listener:
LSNRCTL> START listener-name
sid_BGJPAR parameters for ENTER jobs identified by SID
sid_USER the user ID under which the job should run
user_ACCOUNT Account of the target user ID
user_PASSWORD Password of the target user ID
Parameter Meaning