Monitoring Oracle

[tapufd]

Hi, have downloaded the 7 files, but only 3 of them can be imported :
The graph templates :
* cacti_graph_template_application_oracle_cache_hit_ratio.xml --> OK
* cacti_graph_template_application_oracle_file_table_physical_access.xml --> OK
* cacti_graph_template_application_oracle_filetable_tablespace_size --> OK
* cacti_graph_template_application_oracle_physical_access --> gives an XML parse error
The data queries :
* oracle_datafiletable.xml --> isn't imported because I think it isn't an exported data query but just a copy of your local file. Can you do an export in cacti from the data query?
* oracle_table.xml --> same thing here
* oracle_tablespacetable.xml --> same thing here

Many thanks for providing us your expertise!

/tapufd

[doucetp]

Hello,

data queries are scripts, not templates. They must be in <path_cacti>/resource/snmp_queries/ for example...

Pierre

[tapufd]

Thanks, will try it later. What Data Input Method should be used? (think if you do a export, nothing has to be done manually anymore; is easier for the lazy people like me )

Do you know why I get an XML parse error with the 4th XML?
cacti_graph_template_application_oracle_physical_access.xml

/tapufd

[doucetp]

Do you know why I get an XML parse error with the 4th XML?
cacti_graph_template_application_oracle_physical_access.xml
/tapufd

I have no parse error. What is your cacti version ?

[tapufd]

I use 0.8.6d (+ all patches).

/tapufd

[doucetp]

I use 0.8.6d without patche.

[dattatrayb]

Hi Olivier,

I have downloaded all those xml files now you are saying that we to import those xml files.

What do you mean by this ?? importing those xml file to MySQL database OR just copy those xml file to apache/htdocs/cacti/resource/snmp_queries folder ??

Can you please five me detail steps ???

Please help me in monitoring oracle with cacti

Regards,

Dattatray

[Sem]

I try to use oracle_tablespacetable.xml to create a data queries.
When I add a query to device, I get the messages:

Notice: Undefined index: query_name in /usr/local/share/cacti/lib/data_query.php on line 109

Notice: Undefined index: script_path in /usr/local/share/cacti/lib/data_query.php on line 109

[many times]

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/share/cacti/lib/data_query.php:98) in /usr/local/share/cacti/host.php on line 129

What's wrong?

[Sem]

Looks like OIDs for Oracle 9 are differ.

[eyechart]

Oracle has stopped supporting SNMP as a way of monitoring Oracle databases. I don't think that it is supported in 9.2.x and newer.



-ec

[gentle]

Hi, all ,please tell me what a solution for this problem? thank's

See attachements below. Must I fill -> Index Type -> Index value and Output type Id ??

Can you give me an example, please, if you have alredy successfully graph something with Oracle.

Thank's

[gentle]

Hi, all ,please tell me what a solution for this problem? thank's

See attachements below. Must I fill -> Index Type -> Index value and Output type Id ??

Can you give me an example, please, if you have alredy successfully graph something with Oracle.

Thank's

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

thanks

[TheWitness]

If Oracle stopped supporting snmp, what is the alternative?

TheWitness

[missg]

I try the template and all templates imported ok except the cacti_graph_template_application_oracle_physical_access --> gives an XML parse error
and also i cannot see the cache_hit_ratio for my database. the graph is blank with NAN message. How am i suppose to do? thanks

[pierre.hoffmann]

For information : configure Oracle Agent with Net-Snmp

1) In net-snmp configuration file :
* Activate "SMUX":
smuxpeer 0.0
* Activate Oracle OID :
view systemview included .1.3.6.1.2.1.1
view systemview included .1.3.6.1.2.1.2
view systemview included .1.3.6.1.2.1.3
view systemview included .1.3.6.1.2.1.4
view systemview included .1.3.6.1.2.1.5
view systemview included .1.3.6.1.2.1.6
view systemview included .1.3.6.1.2.1.7
view systemview included .1.3.6.1.2.1.8
view systemview included .1.3.6.1.2.1.8.25
view systemview included .1.3.6.1.2.1.8.39
view systemview included .1.3.6.1.2.1.8.2021
view systemview included .1.3.6.1.4.1.11.2
view systemview included .1.3.6.1.2.1.39
view systemview included .1.3.6.1.4.1.111

2) Starting Net-snmp
/usr/sbin/snmpd -C -c /etc/snmp/snmpd.conf

3) We start Oracle Intelligent Agent
* Oracle 8
su - oracle
lsnrctl dbsnmp_start
* Oracle 9
su - oracle
agentctl start

Connexion was establish with Oracle Agent and Net-Snmp:

#cat /var/log/snmpd.log:

NET-SNMP version 5.0.8
[smux_accept] accepted fd 10 from 128.1.1.146:1935
accepted smux peer: oid SNMPv2-SMI::zeroDotZero, password , descr dbsnmp

# netstat -anp

Internet connexion actives
Proto Recv-Q Send-Q Adresse locale Adresse distante Etat PID/Program name
[...]
tcp 0 0 0.0.0.0:199 0.0.0.0:* LISTEN 27408/snmpd
tcp 0 0 128.1.1.146:1808 0.0.0.0:* LISTEN 27448/dbsnmp
tcp 0 0 128.1.1.146:1809 0.0.0.0:* LISTEN 27448/dbsnmp
tcp 0 0 128.1.1.146:1748 0.0.0.0:* LISTEN 27448/dbsnmp
tcp 0 0 128.1.1.146:1754 0.0.0.0:* LISTEN 27448/dbsnmp
tcp 0 0 128.1.1.146:2039 128.1.1.146:199 ESTABLISHED 27448/dbsnmp
tcp 0 0 128.1.1.146:199 128.1.1.146:2039 ESTABLISHED 27408/snmpd
udp 0 0 128.1.1.146:161 0.0.0.0:* 27408/snmpd