monitors:bb-moracle

no way to compare when less than two revisions

Differences

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


—monitors:bb-moracle [2012/04/25 11:40] (current) – created - external edit 127.0.0.1
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
  • by 127.0.0.1