Documentation

First you need to install rrdtool on you machine.
For information how to do that go to the homepage of Tobi.
You also need to have some kind of webserver (Apache for example) running on your server.
Finally you need to have Oracle client software installed on your Unix server.

Download the tar.gz file rrdora.1.0.tar.gz and unpack it somewhere on your Unix server.

gunzip rrdora.1.0.tar.gz
tar xvf rrdora.1.0.tar

First you must edit the file rrdora.env.
Put in the correct directories for your environment.

After this you must edit the file rrdora.dblist.
For every database put in a line according to the sample.
Also you need to run the scripts create_user.sql and grant_user.sql on every database
that is in the dblist file. Run the sql-scripts as Oracle SYS user.
Finally edit the three shellscripts named :

• rrdora.rrd.sh
• rrdora.img.sh
• rrdora.get.sh

Change the line :  . <fill in directory name>/rrdora.env
You must change the directory name to the directory where the env-file is placed.

So now you are ready to start RRDORA.

First you need to run the following command once :

rrdora.rrd.sh rrdora.dblist

This will create the rrdfiles for every database in your dblist-file.
Check in the logs directory the logfile for any errors.
When you add another database to you dblist file you must rerun rrdora.rrd.sh again.

Now you can start colecting data from your databases.
I use crontab to do that for me.
Run every 5 minutes the following command :

rrdora.get.sh rrdora.dblist

Check in the logs directory the logfile for any errors.
After collecting two samples of data (10 minutes) you can start generating
the images and index.html file.

rrdora.img.sh rrdora.dblist

The images will be generated in the directory GIF in the rrdora.env file.
Also an index.html is generated. Configure your webserver so to use this as the documentroot.

Questions and remarks can be send to me by email

Raymond Vermeer
r.vermeer@wanadoo.nl