3.5.1 MxDB-Oracle-HiAv Installation and Administration Guide

Chapter 2: Operations 45

values are naturally returned from select statements executed against the

internal V$ views of the database. The default probe script

(mxdb_probe.sql) already includes this infrastructure.

Be advised that copying the mxdb_probe.sql script to the

ORACLE_BASE}/admin/<DBNAME>/scripts directory will cause the scripts

to go into immediate use if there is a Virtual Oracle Service for that

database executing.

It is advisable to copy the default scripts to a working directory before

deploying them into the ${

ORACLE_BASE}/admin/<DBNAME>/scripts

directory. Once you are ready to deploy your custom scripts, simply

move them into the ${

ORACLE_BASE}/admin/<DBNAME>/scripts directory

and the very next probe cycle will use the scripts—if the Virtual Oracle

Service is already running. The mxdb_probe.sql script is well

documented with pointers on where to place any desired custom probe

actions.

Support of Custom Start/Stop and Probe Scripts

Support for custom start/stop and probe scripts is limited to the

infrastructure that calls the custom scripts. Customers assume

responsibility for custom start/stop and probe actions since there is an

endless amount of functionality that can be placed into a custom script.

Security with Custom Start/Stop and Probe Scripts

Care should be taken to ensure that modification privileges are limited on

the custom start/stop and probe scripts. Whereas the default scripts

included in the solution pack reside in a directory writable only by root,

custom scripts reside under ${ORACLE_BASE}/admin. It is possible that

DBAʹs without the intended level of security may impact a Virtual Oracle

Service that uses custom scripts—whether intentionally or

unintentionally—by modifying or deleting these scripts.

Custom Probes and Probe Timeouts

If significant probe actions are added to a custom probe, it may be

necessary to increase the value of the

MxDB_PROBE_CORE_TIMEOUT

parameter. This parameter is used by MxDB-Oracle-HiAv to limit the