Oracle Monitor

Author	Javier Blanco Morcillo
Compatibility	Hobbit & Xymon servers
Requirements	Linux, sh, ksh, oracle
Download	http://sourceforge.net/projects/xymoracle/files/xym-oracle-1.0.tar.gz
Mirror	http://newbye.net/reposoft/xym-oracle-1.0.tar.gz
Last Update	2012-04-25

Description

Fork of deadcat's bb-moracle.sh. Adapted to hobbit & xymon server new versions and improved with new added features.

Tested with Oracle 11G (al releases)

Client side

1. Create an oracle user for hobbit monitoring:

SQL> create user check_bb identified by my_passwd
  2  default tablespace users;
User created.
SQL>

2. Grant to check_bb user these rol and permissions:

grant connect to check_bb;
grant alter session, create session, select any table to check_bb;
grant select on sys.dba_data_files to check_bb;
grant select on sys.dba_free_space to check_bb;
grant select on sys.dba_segments to check_bb;
grant select on sys.v_$backup to check_bb;
grant select on sys.v_$datafile to check_bb;
grant select on sys.v_$process to check_bb;
grant select on sys.v_$session to check_bb;
grant select on sys.v_$recovery_file_dest to check_bb;
grant select on sys.v_$sql to check_bb;
grant select on dba_users to check_bb;
grant select on dba_objects to check_bb;

3. Copy bb-moracle.sh and bb-moracle_def.sh files to hobbit extensions' directory, usually “$HOBBITCLIENTHOME/ext/”.

4. Configure hobbit client to make the test, add this content to clientlaunch.cfg:

[oracle]
        ENVFILE $HOBBITCLIENTHOME/etc/hobbitclient.cfg
        CMD $HOBBITCLIENTHOME/ext/bb-moracle.sh
        LOGFILE $HOBBITCLIENTHOME/logs/hobbitclient.log
        INTERVAL 5m

5. Edit this parameters at bb-moracle_def.sh with your oracle's settings:

ORACLE_HOME=YOUR_ORACLE_HOME; export ORACLE_HOME
ORACLE_SIDS="YOUR_ORACLE_SID OR SIDS WITH SPACES"; export ORACLE_SIDS 
DB_PASSWORD="YOUR_CHECK_BB_ORACLE_PWD"; export DB_PASSWORD

6. Edit this parameter at bb-moracle.sh with your hobbit client settings:

BBHOME=/usr/lib/hobbit/client; export BBHOME

7. Restart your hobbit client

* NOTE: To enable or disable oracle sub-tests go to bb-moracle_def.sh and change “Y” to “N” or “N” to “Y”:

LISTENER_CHECK="Y"; export LISTENER_CHECK
LISTENER_CHECK_VERBOSE="Y"; export LISTENER_CHECK_VERBOSE
DATABASE_CHECK="Y"; export DATABASE_CHECK
TABLESPACE_CHECK="Y"; export TABLESPACE_CHECK
EXTENT_CHECK="Y"; export EXTENT_CHECK
SHADOW_CHECK="Y"; export SHADOW_CHECK
USER_CHECK="Y"; export USER_CHECK
USER_CHECK_VERBOSE="Y"; export USER_CHECK_VERBOSE
USER_PASSWD_EXPIRE="Y"; export USER_PASSWD_EXPIRE
INVALID_OBJECTS_CHECK="Y"; export INVALID_OBJECTS_CHECK
RMAN_NEED_BACKUP="Y"; export RMAN_NEED_BACKUP
RECOVERY_AREA="Y"; export RECOVERY_AREA

Server side

None

There's a link to the extention at the top of the page!

* Oracle test with all tests enabled each 5 minutes could be heavy to some oracle servers, in this case you can change the execution time to 10m.

* If Oracle has usually many open sessions and “USER_CHECK_VERBOSE” is set to “Y” can appears purple reports in oracle test. It happens 'case the output's monitor is too big to hobbit. I suggest to disable this sub-test in this scenario.

I'm working in a subtest to monitoring oracle blocked sessions.

This development is under fsf gnu 3.0 licence or better if exists.

More info at http://www.gnu.org/licenses/gpl-3.0.html