3.1.1 MxDB-Oracle-HiAv Installation and Administration Guide

Chapter 3: Operations 43

Supplemental Startup Scripts

MxDB-Oracle-HiAv supports site-customizable startup and shutdown

scripts. The Solution Pack ensures that the database instance and

SQL*Net listener processes are available in the matrix. You might also

want supplemental processes to be started and stopped each time the

database is restarted or failed over to another node. For example, if you

want the Intelligent Agent to start each time the database instance is

started, a supplemental script is required.

Configuring a supplemental startup script is a simple administrative task.

However, the functionality of the script is the responsibility of the

administrator. That is, the Solution Pack will call the script, but it cannot

ensure that the script will succeed because the code is site-customized. To

that end, the Solution Pack treats the execution of the supplemental script

with the following caveats:

• Return Codes. The supplemental script can return success or failure

codes; however, the Solution Pack ignores them. This ensures that the

database instance and SQL*Net listeners start even if the

supplemental script fails.

• Timeout. The supplemental startup script is allocated a maximum of

20 seconds execution. If the supplemental script is still executing code

after 20 seconds, it will be terminated by the Solution Pack. This

should not be a concern because any process spawned by the

supplemental script will likely be daemon in nature (e.g., Intelligent

Agents). That is, spawning daemon processes such as the Intelligent

Agent is a nearly immediate task.

• SHELL. Supplemental scripts will be interpreted by the bash shell.

• Execution Environment. The supplemental script is executed with the

Linux su(1) command, switching user to the Oracle user that was

established at configuration time with the Configuration GUI. The

su(1) command is not invoked with the full login option. The

invocation method is as follows:

/bin/su - ${ORACLE_OWNER} -c "ORACLE_SID=${DBNAME};bash

${PRODHOME}/etc/custom_${DBNAME}.sh\ [start|stop]"