Page History

What is already available in the Shinken Installation

To make your life a bit easier, a few configuration tasks have already been done for you:

1. Installation of Oracle instant Client
2. Installation of check_oracle_health plugin : /var/lib/shinken/libexec/check_oracle_health
3. Several host templates are ready to be used

Setup the oracle user account

Create the database user
 

Connect to your database as sysadmin on the oracle server :

srv-lin-1:oracle# sqlplus "/ as sysdba"

And then create your shinken account on the database:

CREATE USER shinken IDENTIFIED BY shinkenpassword;
GRANT CREATE SESSION TO shinken;
GRANT SELECT any dictionary TO shinken;
GRANT SELECT ON V_$SYSSTAT TO shinken;
GRANT SELECT ON V_$INSTANCE TO shinken;
GRANT SELECT ON V_$LOG TO shinken;
GRANT SELECT ON SYS.DBA_DATA_FILES TO shinken;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO shinken;

And for old 8.1.7 database only:

---- if somebody still uses Oracle 8.1.7...
GRANT SELECT ON sys.dba_tablespaces TO shinken;
GRANT SELECT ON dba_temp_files TO shinken;
GRANT SELECT ON sys.v_$Temp_extent_pool TO shinken;
GRANT SELECT ON sys.v_$TEMP_SPACE_HEADER TO shinken;
GRANT SELECT ON sys.v_$session TO shinken;

Test the connection

To see if the connection to the database named PROD is ok, just launch :

/var/lib/shinken/libexec/check_oracle_health --connect "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = srv-lin-1)(PORT = 1521)))(CONNECT_DATA =(SID = PROD)))" --user "shinken" --password "shinkenpassword" --mode connection-time

Attach an oracle template to you host

Clic on Hosts in the Elements menu
Add the Oracle choosen host template to the Host Templates to inherit field. For example the Oracle host template.
Clic on the Data tab
Look for the field DATABASES in the From templates datas
Type the name of the database to be monitoring
Check if the Following data are ok

• Clic on Data tab
• Look for the field DATABASES in the From templates datas
• Type the name of the database to be monitoring
• If not configured in the Oracle-connection-method host template
  • Type the oracle user in the ORACLE_USER field (shinken in the previous example)
  • Type the oracle password in the ORACLE_USER field (shinkenpassword in the previous example)

What is checked with the templates

Public templates

Oracle

This is the very basic Oracle template allowing to know if your Oracle database is running and usable.

Oracle-full

Contains all Oracle host templates listed in the Shinken Adminstrators templates.

Shinken Administrator templates

Oracle-connection-method

This template describes the method to connect to an Oracle database. Every Oracle templates use it as a parent template.

Oracle-datafile

 This template gives informations about the datafile availability.

Oracle-enqueue

This template gives informations about enqueue and possible problem related to un-indexed forein keys.

Oracle-events

This template give informations about event waiting (typically session in waiting status).

Oracle-flash-recovery-area

This template allow to know about the used diskspace in the flash recovery area.

Oracle-latch

This template gives informations about latches. Latches are low level serialization mechanisms used to protect shared data structures in the SGA.

Oracle-pga

This template allows to know the percentage of sorts that are done to disk vs. in-memory.

Oracle-redo

This template gives complete informations about the redolog.

Oracle-rman

This template indicates if there are any RMAN backup problem in the last 3 days.

Oracle-rollback-segment

This template gives informations about the Rollback segment. Rollback segment record the actions of transactions in the event that a transaction is rolled back.

Oracle-sga

This template gives complete information about the SGA (System Global Area).

Oracle-soft-parse

This template gives information about soft parse. It can give you an idea if an application and corresponding SQL statements are being used inefficiently

Oracle-stale-statistics

This template allows to know about stale statistics.

Oracle-sysstat

This template allows you know the change of sysstat values over time.

Oracle-tablespace

This template gives informations about tablespace such as fragmentation, if it's possible to allocate the next extent and potentially when a tablespace will be full.

Oracle-top10-stats

This template give global statistics.

Oracle-usage

This template indicates the percentage of maximum possible sessions and how many users are connected.

How to 

Configuration of Oracle-connection-method host template

• Select the Oracle-connection-method host template
• Clic on Data tab

You can setup the following DATA : 

• DATABASES : the name(s) of the Oracle SID database(s) to be monitored
• ORACLE_CONNECTION_STRING : this is the Oracle connection string which allow to connect and do request toward the databases.
  Unless you know what your doing, you will rarely have the need to modify it.
• ORACLE_PASSWORD : the oracle password of the user used to connect to database
• ORACLE_USER : the oracle user name used to connect to database
• ORACLE_PORT : the listening port of the Oracle database server

The parameters specifics to each server, such as database name (AKA SID) for example, has to be done in the host's data itself.

Configuring host for monitoring

How to create you own template

create you own pack!

Use your own plugin