Installation
Hardware Requirement
- Pentium III or equivalent processor
- 512 MB Physical RAM
- 1 GB Swap
Software Requirement
- Linux 32 or 64 bit
- Apache 1.3 or higher
- PHP 5 or higher
- Oracle Client 9i or higher
Installation Procedure
Oracle PHP setup
1. Compile PHP with Oracle: You can use the article mentioned below to
compile PHP with Oracle.
http://www.dbapool.com/articles/1227051.html
Note: This software uses sqlplus and tnsping utilities to monitor the
database so make sure select these option when installing Oracle client.
Oramon User Setup
Add a OS user called "oramon"
# adduser oramon -c "oramon user"
2. Set the password for the 'oramon' user
# passwd oramon
3. Login as 'oramon' user and Setup oramon profile to use sqlplus
e.g.
ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1; export ORACLE_HOME
ORACLE_SID=oramon; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
4. It is recommended to have a small separate database for monitoring purpose
only. If you don't want to create separate database then create at least a
separate tablespace and create a oracle user 'oramon'.
5. Make sure oramon user has access to write in the www root dir.
Command to create the oramon database user:
SQL> Create user oramon identified by oramon default tablespace oramon_tbs
temporary tablespace temp quota 50m on oramon_tbs;
6. Grant following privileges to oramon.
SQL> grant SELECT_CATALOG_ROLE, CREATE SEQUENCE, CONNECT to oramon ;
Installing Oramon Software
1. Download latest version of oramon from http://oramon.dbapool.com/download.asp
to /tmp dir.
2. Copy this file in your web server directory
e.g.
# cd /var/www/html/
# cp /tmp/oramon_vxx.tar.gz .
Note: you can also download oramon_vxx.tar.gz file directly to /var/www/html/
directory also. But to keep one original copy of the software, I used tmp dir.
3. untar this file
tar -xvzf oramon_vxx.tar.gz
This will create a oramon directory folder and other files and directory
inside it.
4. Point your browser to
http://localhost/oramon/installer.php
Edit the information as per your env. The oramon installer creates a file called oramon.ini in config dir and conn.php in lib dir.
If required then edit this file to correct the settings.
5. Connect as oramon database user and run the omdb.sql script from admin dir to create
required database objects.
SQL> connect oramon/oramon@db
SQL>@path_to_oramon_software/omdb.sql
6. Point your browser to
http://localhost/oramon/index.php
7. Create htpasswd file and users inside admin dir to use oramon admin
section. (Optional)
Setting up alerts
The new version of oramon run agent in the background to collect the
database informatoon on periodic intervals. You can use crontab file to
schedule oramon agent. Below are the necessory steps to set these alerts.
1. Add the email address in the email.txt file located in the /oramon/agents/db/
location.
2. Add the agents in the cron deamon. An example of crontab file is shown
below.
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * (cd /var/www/html/oramon/agents/bin;
./dbstatus.sh monitor) > log/agent.log > /dev/null 2>&1
0,15,30,45 * * * * (cd /var/www/html/oramon/agents/bin; ./tbsagent.sh monitor)
> log/tbsagent.log > /dev/null 2>&1
0,15,30,45 * * * * (cd /var/www/html/oramon/agents/bin; ./invalidobj.sh
monitor) > log/invalidobj.log > /dev/null 2>&1
In the above file, database status is monitored every 3 munites. Other two
agents are running every 15 minutes.
Support
Discussion Forum
Report a Bug
