Table 3 Variable or Parameter Name in haoracle.conf file (continued)
MAINTENANCE_FLAG | This variable will enable or disable maintenance mode for the Oracle database |
| package. By default this is set to "yes". In order to disable this feature |
| MAINTENANCE_FLAG should be set to "no". When Oracle Database or ASM needs |
| to be maintained, then a "<package directory>/Oracle.debug" file needs to be |
| touched. During this maintenance period Oracle database or ASM instance's process |
| monitoring is paused. Even if an Oracle instance is brought down, its package will |
| not be failed over to the standby node. To continue monitoring and come back from |
| the maintenance mode, remove the Oracle.debug file. It is the user's responsibility |
| to ensure that Oracle instance is properly running after the maintenance phase. |
| NOTE: Setting MAINTENANCE_FLAG to "yes" and touching the Oracle.debug |
| file in the package directory will put the package in toolkit maintenance mode. |
| Serviceguard A.11.19 release has a new feature which allows individual components |
| of the package to be maintained while the package is still up. This feature is called |
| Package Maintenance mode and is available only for modular packages. For more |
| information using Package Maintenance mode, see Modular package support in |
| Serviceguard for Linux and ECM Toolkits available at http://www.hp.com/go/ |
| |
| If the Oracle database package is dependent on the SGeRAC clusterware package |
| (OC MNP), then the Oracle database package will automatically go into toolkit |
| maintenance mode if the SGeRAC OC MNP is put into toolkit maintenance mode. To |
| put the SGeRAC OC MNP into toolkit maintenance mode, its MAINTENANCE_FLAG |
| attribute must be set to 'yes' and a file oc.debug must be created manually in the |
| OC MNP working directory on that node. More details about how to put the SGeRAC |
| OC MNP package in toolkit maintenance mode can be found in the SGeRAC toolkit |
| user guide. If the MAINTENANCE_FLAG attribute of the SGeRAC OC MNP is set to |
| 'yes', this parameter must also be set to 'yes' in the |
| package. |
ORA_CRS_HOME | This parameter must be set only in case where Oracle database packages created |
| using ECMT Oracle toolkit and SGeRAC packages run in the same cluster. This |
| parameter must be set to the Oracle Clusterware home directory. |
MONITOR_INTERVAL | The time interval script (in seconds) will wait between checks to ensure that the Oracle |
| instance is running. Default value is 30 seconds. |
TIME_OUT | The amount of time, in seconds, to wait for the Oracle abort to complete before killing |
| the Oracle processes defined in MONITOR_PROCESSES. The TIME_OUT variable is |
| used as protection against a |
| package halt script from completing, therefore preventing the standby node from |
| starting the instance. The value of TIME_OUT must be less than the |
| HALT_SCRIPT_TIMEOUT value set in the package configuration file. If |
| HALT_SCRIPT_TIMEOUT is not defined then, it is the sum of all the |
| SERVICE_HALT_TIMEOUT defined in the package. This variable has no effect on |
| the package failover times. |
PARENT_ENVIRONMENT | This is used to mention if the Oracle user's shell should be invoked as a new shell or |
| as a subshell that inherits the variables set in the parent shell. This can be set to only |
| yes or no. Set to 'yes' if the Oracle user's shell should be invoked as a subshell. Set |
| to 'no' if the Oracle user's shell should be invoked as a new shell. If set to no, the |
| Oracle user's profile file is executed and the variables set in this profile file are available |
| to the new shell. |
CLEANUP_BEFORE_STARTUP This parameter indicates whether 'shutdown abort' needs to be executed before the startup of the Oracle or ASM instance. 'shutdown abort' ensures the cleanup of uncleared shared memory or semaphores. This parameter can be set to only 'yes' or 'no'. Default value is no.
USER_SHUTDOWN_MODE | This parameter is used to specify the database shutdown mode only when a shutdown |
| is initiated by the user and not due to a failure of a service. This parameter can take |
| values "abort" or "immediate" only. If "abort" is specified, the database is shutdown |
| using the abort option. If "immediate" is specified, the database is shutdown using |
| the immediate option. |
ALERT_MAIL_ID | This parameter is used to specify the |