
Table 6 Variables or Parameters in haoracle.conf file (continued)
Parameter Name | Description |
ASM_DISKGROUP | This parameter gives the list of all ASM disk groups used by the database |
| instance. This parameter must be set only for the ASM database instance |
| package. |
| NOTE: For ASM instance package, no value must be set for this parameter. |
ASM_VOLUME_GROUP | This parameter gives the list of volume groups used in the disk groups for the |
| ASM database instance. This parameter must be set only for the ASM database |
| instance package. |
| NOTE: For ASM instance package, no value must be set for this parameter. |
ASM_HOME | The home directory where ASM is installed. This parameter must be set for both |
| the ASM and the ASM database instance packages. |
ASM_USER | The user name of the Oracle ASM administrator. This parameter must be set |
| for both ASM instance and ASM database instance packages. |
ASM_SID | The ASM session name. This uniquely identifies an ASM instance. If the database |
| instance package depends on the ASM MNP package, then this parameter |
| needs to be set for both the ASM and the database instance packages. This |
| parameter need not be set in case the database instance package depends on |
| the SGeRAC clusterware package (OC MNP). This parameter is set to "+ASM" |
| by default. |
PFILE | Oracle database /ASM parameter file. If not specified, Oracle picks this up |
| from the Oracle configuration directory $ORACLE_HOME/dbs or |
| $ASM_HOME/dbs depending on the INSTANCE_TYPE. |
SPFILE | This parameter, when configured, overrides the default file or location. If both |
| PFILE and SPFILE are present and this parameter is not specified, then the Oracle |
| scripts will make use of PFILE as the parameter file. To make use of SPFILE in |
| the scripts, do not configure this parameter and remove the default PFILE from |
| its default location. This parameter must be set for both the ASM and the |
| database instance packages. |
| NOTE: For Oracle 11gR2, by default, the spfile of the ASM instance is stored |
| on the ASM diskgroup. This is true only for the ASM instance and not for the |
| database instance that uses the ASM diskgroup.For an ASM instance, the ECM |
| Toolkit cannot verify the existence of the spfile on the ASM diskgroup. So, it is |
| mandatory that a pfile is created from the spfile on the local disk, at a location |
| that ECMT can access. For 11gR2 ASM instance, the value of the PFILE attribute |
| must point to the pfile that is created on the local disk. |
LISTENER | Set to "yes" if you want the scripts to start and stop the Oracle Listener. This |
| parameter must be set only in the database instance package. |
LISTENER_NAME | The name of the listener process. This parameter must be set only in the database |
| instance package. |
LISTENER_PASS | The password of the listener process. This parameter must be set only in the |
| database instance package. |
MONITOR_PROCESSES | The names of all processes that should be executing. This parameter must be |
| set for the ASM and the database instance packages. The description of this |
| attribute in the package configuration file has a sample of processes that must |
| be monitored for ASM and database instances. |