How To Configure VCS To Noify (or Take Action) When A DB Conifugration Has Changed?
An Oracle DB is part of a resource group along with all the filesystems it needs to start. Someone logs in to a db and sets an initiization parameter to point to a filesystem that is not part of the RG, for example, to address a log destination full. When a failover happens, db fails to come up because its log destination is pointing to a non-existent path on failover node.
I want to develope a script that checks these parameter settings and verifies. if one exists, that it is identical on all nodes e.g. the directory path is vallid on all.
Having skimmed through the VCS user guide, it appeas it can be one either using VCS events or notifier framework..
1) I couldn't find an event to capture this e.g. postonline, post offline. Ideally, I want this check to run regularly, may be, once a day.
2) If db runs on node 1, my script will retrieve these parameter settings e.g. directory path, Can it, however, check presence of this directory on all nodes of the cluster?
Thanks in advance.