Oracle-DB-parameter-monitor

Puppet fact based web tool written in PHP for monitoring:

Oracle Database parameter changes
Oracle Database FRA usage
Oracle Database Switchover/Failover

Word of caution

Oracle Parameter Monitor is at a very early step and there a many things witch still needs to be improved.

The application should just give a first approch how Data from Oracle Database can be visualised with the use of Puppet Facts.

At the moment no framework, expect JQuery is used, therefore MVC and UI frameworks needs to be implemented. The projects needs also improvment on cronjob handling and support for other databases expect MySQL.

Installation

Download the folder 'oracle-parameter-monitor' and extract it to your webserver. Atleast PHP 5.3 is needed.

Application database

The application supports at the moment of writing only MySQL/MariaDB 5. Please create here a new user/schema.

For importing the defualt structure and data please execute first mysql_structure.sql (install folder), then mysql_settings.sql and mysql_parameter.sql.

At last step please configure the database settings inside /includes/templates/configuration.php on the webserver

Puppet Fact definition

Oracle database related facts should have the following naming convention:

Database related facts:

ora_<database sid>_<parameter name>=<value>

Server related facts:

ora_system_<parameter name>=<value>

Script for collection can be found in the folder puppet_fact_collection. One of the possiblities would be to configure the shell script as cronjob and pipe the stdout to a puppet watched definition file:

*/15 * * * * /u01/app/admindb/bin/collect_ora_parameter.sh > /etc/puppetlabs/facter/facts.d/oracle_facts.txt

Cronjobs

The tool has two scripts which need to be called regularly as cronjob.

For authentication a token needs to be provieded on each call, which can be configured in /includes/templates/configuration.php.

Cronjob for importing Fact changes:

*/30 * * * * wget -qO- <webserver>/collect_parameter/includes/windows/input.php?token=6vbxSuwqJme5N724dH18309 &> /dev/null

Cronjob checking for notifications:

25,55 * * * * wget -qO- <webserver>/collect_parameter/includes/windows/notification.php?token=6vbxSuwqJme5N724dH18309 &> /dev/null

Authentication

Authentication works per default through LDAP. In /includes/templates/configuration.php you can specify LDAP groups which are allowed to access the tool.

You need also to specify a LDAP server, DN and uer domain.

General Confgiuration

The following settings are necessary and can be configured in /includes/templates/configuration.php on the webserver.

URL to PuppetDB webservice:

$GLOBALS['config']['puppet_db_url'] = '';

Prefix for Puppet facts, the tool works at the moment only if all your SIDs have the same beginning or all puppet facts starts with the same prefix. Per default ora_p is set:

$GLOBALS['config']['puppet_fact_db_prefix'] = 'ora_p';

If you want to recieve mails on swithover/failover or critical FRA situation you have to configure mail addresses for that:

$GLOBALS['config']['fra_notification_mail'] = '';
$GLOBALS['config']['switchover_notification_mail'] = '';

marius-meissner/Oracle-DB-parameter-monitor