Monitoring Oracle

[o_dupuis]

Hi,

Here are the first XML Files I made to monitor our Oracle Server (8.1.7.2 under Solaris).

To be able to use those template you will have to have the following agent working on the Oracle server :

- Oracle peer Master agent
- Oracle peer encapsulator
- An standard snmp agent, net-snmp for instance.

(I might post a procedure if someone is interested)


The list of template is the following :

The first two of them are based on the infos found here :
http://www-rohan.sdsu.edu/doc/oracle/se ... 01/ch3.htm

* cacti_graph_template_application_oracle_physical_access.xml
This template gives the physical access (block/sec read and write) for each database. This is an overview of the I/O activity of the database. This is not an absolute measurement because of possible OS disk cache.

(see graph 1)

* cacti_graph_template_application_oracle_cache_hit_ratio.xml
This template gives the cache hit ratio for each database. No need to explain this one, on our server it is always above 95% because of the large amount of RAM.

(see graph 2)

* cacti_graph_template_application_oracle_filetable_tablespace_size.xml
This template gives for each TableSpace of each Database, the space used/space allocated in octets. Useful to see if the space allocated is still enough.

(see graph3)

* cacti_graph_template_application_oracle_file_table_physical_access.xml
This template gives for each File (.dbf) of each Database, the block read/sec and block write/sec. This could be useful to optimize the location of files accross the different file systems.

(see graph4)

After you import the templates, you will have 3 more Data queries available for your host :


SNMP - ORACLE - DbSysTable : For graph 1 and 2 (this query gathers infos about the Databases)

SNMP - ORACLE- TableSpace : For graph 3 (this query gathers infos about the tablespaces of the Databases)

SNMP - ORACLE - DbDataFileTable : For the Graph 4 (this query will gather infos about the dbf files)


I am still working on other monitors I will post later on.
I think those informations could still be relevant to other version of Oracle server, but the OID may (or not, I didn't check) have changed.


Feedback appreciated.


Olivier

[o_dupuis]

Here is the graph 4.

[fmangeant]

Thanks for the templates

Some how-to have been posted here in the past : http://forums.cacti.net/viewtopic.php?t=829 and http://forums.cacti.net/viewtopic.php?t=6209

[Suzumushi]

i can't see any templates to download....
only jpg files

where i can download them?

best regards

[o_dupuis]

Oops, I forgot the most important, silly me...

[o_dupuis]

The last template.

Thanks Suzumushi

[doucetp]

Hello,

Thank's for the template, but how can i fill Index Type and Index values ? Can you explain it ?

Pierre

[kevinchang]

thank first.
today i try to import template of oracle xml files, there is no any error information , and i cannot see any template at cacti, In the other xml template case , i can import success,

would u give me a hand , or someone know why ? thank a lot ,

[o_dupuis]

Hi,


doucetp :
Could you be a bit more precise about the problem you have with the index type and Index value, I can't figure out where you need to fill this (screenshot welcome ).

kevinchang:
Could you tell me which template gives you trouble, it will be easier to help you.

Olivier

[naska]

Hi!

Can you post de Data queries for Oracle templates¿¿

Thanks.

[o_dupuis]

Yes, of course without the data queries, it won't work . Sorry I thought it was exported via the Export command.

Here they are :

1st :
oracle_DataFileTable.xml
associated with graph : Application - Oracle - File Table - Physical Access

2nd :
oracle_Table.xml
associated with graph :
Application - Oracle - Block Get Rate
Application - Oracle - Block Visit per transaction
Application - Oracle - Cache Hit Ratio
Application - Oracle - Physical Access
Application - Oracle - Redo Logs Wait Ratio

3rd :
oracle_TableSpaceTable.xml
associated with graph :
Application - Oracle - TableSpace Size



Sorry, it must have been confusing for people who tried to use the graph templates.

[proxyo]

I have any question with your template...

first, can you post the procedure you asked in your first post ?
installation of the oracle software, and configuration frighten me a little...

and are these template can run under windows????


thanks in advance....

ProxyO

[o_dupuis]

Hi,

I have no time at the moment to make a procedure (sorry), the links fmangeant posted are very well documented :

http://forums.cacti.net/viewtopic.php?t=829
http://forums.cacti.net/viewtopic.php?t=6209

I think you will find all the infos to make oracle agent work.

About working under Win32, these templates are based on SNMP, not scripts run by the "cacti server" so it should work without problem.

Olivier

[doucetp]

Thank's olivier,


Now with Data Queries, all info are being graphed except "Cache It Ratio".
I think something is missing for this graph .

Bye
Pierre

[o_dupuis]

Hi Pierre,

Do you use the Create->New Graph menu on the left handside of the screen ? If not, have a try. This Cache Hit Ratio template works exactly the same way the others do, so if you get "Application - Oracle - Block Get Rate", or "Application - Oracle - Physical Access" working, you 'should' also get the cache hit ratio.


Olivier