====== Oracle Monitor ======

^ Author | [[ therebelcode@gmail.com | 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)
===== Installation =====
=== Client side ===
1. Create an oracle user for hobbit monitoring:

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

2. Grant to check_bb user these rol and permissions:

<code>
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;

</code>

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:

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

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

<code>
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
</code>

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

<code>
BBHOME=/usr/lib/hobbit/client; export BBHOME
</code>

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":

<code>
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
</code>

=== Server side ===
None

===== Source =====

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

===== Known  Bugs and Issues =====

* 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.
===== To Do =====
I'm working in a subtest to monitoring oracle blocked sessions.
===== Credits =====
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
===== Changelog =====

  * **2011-03-08**
    * version 2.1.1
      * Recovery Area test bug solved

  * **2011-08-12**
    * version 2.0
      * All test reports in english
      * Design changes to simplify how the information is shown

  * **2011-06-08**
    * version 1.9
      * remove german languaje
      * new test: recovery area occupation

  * **2011-04-07**
    * version 1.8
      * minor code changes
      * new test: rman need backup