Differences

This shows you the differences between two versions of the page.

Link to this comparison view

monitors:bb-moracle [2012/04/25 11:40] (current)
Line 1: Line 1:
 +====== 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
  • monitors/bb-moracle.txt
  • Last modified: 2012/04/25 11:40
  • (external edit)