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:// | ||
+ | ^ Mirror | http:// | ||
+ | ^ Last Update | 2012-04-25 | | ||
+ | ===== Description ===== | ||
+ | Fork of deadcat' | ||
+ | |||
+ | Tested with Oracle 11G (al releases) | ||
+ | ===== Installation ===== | ||
+ | === 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' | ||
+ | |||
+ | 4. Configure hobbit client to make the test, add this content to clientlaunch.cfg: | ||
+ | |||
+ | < | ||
+ | [oracle] | ||
+ | ENVFILE $HOBBITCLIENTHOME/ | ||
+ | CMD $HOBBITCLIENTHOME/ | ||
+ | LOGFILE $HOBBITCLIENTHOME/ | ||
+ | INTERVAL 5m | ||
+ | </ | ||
+ | |||
+ | 5. Edit this parameters at bb-moracle_def.sh with your oracle' | ||
+ | |||
+ | < | ||
+ | ORACLE_HOME=YOUR_ORACLE_HOME; | ||
+ | ORACLE_SIDS=" | ||
+ | DB_PASSWORD=" | ||
+ | </ | ||
+ | |||
+ | 6. Edit this parameter at bb-moracle.sh with your hobbit client settings: | ||
+ | |||
+ | < | ||
+ | BBHOME=/ | ||
+ | </ | ||
+ | |||
+ | 7. Restart your hobbit client | ||
+ | |||
+ | |||
+ | * NOTE: To enable or disable oracle sub-tests go to bb-moracle_def.sh and change " | ||
+ | |||
+ | < | ||
+ | LISTENER_CHECK=" | ||
+ | LISTENER_CHECK_VERBOSE=" | ||
+ | DATABASE_CHECK=" | ||
+ | TABLESPACE_CHECK=" | ||
+ | EXTENT_CHECK=" | ||
+ | SHADOW_CHECK=" | ||
+ | USER_CHECK=" | ||
+ | USER_CHECK_VERBOSE=" | ||
+ | USER_PASSWD_EXPIRE=" | ||
+ | INVALID_OBJECTS_CHECK=" | ||
+ | RMAN_NEED_BACKUP=" | ||
+ | RECOVERY_AREA=" | ||
+ | </ | ||
+ | |||
+ | === Server side === | ||
+ | None | ||
+ | |||
+ | ===== Source ===== | ||
+ | |||
+ | There' | ||
+ | |||
+ | ===== 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 " | ||
+ | ===== 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:// | ||
+ | ===== 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 |