<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Monitorizar_BDs_v%C3%ADa_ODBC</id>
	<title>Monitorizar BDs vía ODBC - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Monitorizar_BDs_v%C3%ADa_ODBC"/>
	<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Monitorizar_BDs_v%C3%ADa_ODBC&amp;action=history"/>
	<updated>2026-11-21T23:13:02Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.46.2</generator>
	<entry>
		<id>https://www.zabbix-es.com.es/index.php?title=Monitorizar_BDs_v%C3%ADa_ODBC&amp;diff=991&amp;oldid=prev</id>
		<title>Unknown user: Created page with &quot;==Instalas el InstantClient de Oracle en el Zabbix Server== ==Configuras el /etc/odbcinst.ini==  [Oracle 11g ODBC driver]  Description     = Oracle ODBC driver for Oracle 11g...&quot;</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Monitorizar_BDs_v%C3%ADa_ODBC&amp;diff=991&amp;oldid=prev"/>
		<updated>2020-10-09T18:36:00Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;==Instalas el InstantClient de Oracle en el Zabbix Server== ==Configuras el /etc/odbcinst.ini==  [Oracle 11g ODBC driver]  Description     = Oracle ODBC driver for Oracle 11g...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==Instalas el InstantClient de Oracle en el Zabbix Server==&lt;br /&gt;
==Configuras el /etc/odbcinst.ini==&lt;br /&gt;
 [Oracle 11g ODBC driver]&lt;br /&gt;
 Description     = Oracle ODBC driver for Oracle 11g&lt;br /&gt;
 Driver          = /oracle/instantclient_11_2/libsqora.so.11.1&lt;br /&gt;
 Setup           =&lt;br /&gt;
 FileUsage       =&lt;br /&gt;
 CPTimeout       =&lt;br /&gt;
 CPReuse         =&lt;br /&gt;
&lt;br /&gt;
==Configuras el /etc/odbc.ini==&lt;br /&gt;
 ###############################&lt;br /&gt;
 ## CONEXIONES ORACLE&lt;br /&gt;
 ###############################&lt;br /&gt;
 [NOMBRE_DE_LA_BBDD]&lt;br /&gt;
 Application Attributes = T&lt;br /&gt;
 Attributes = W&lt;br /&gt;
 BatchAutocommitMode = IfAllSuccessful&lt;br /&gt;
 BindAsFLOAT = F&lt;br /&gt;
 CloseCursor = F&lt;br /&gt;
 DisableDPM = F&lt;br /&gt;
 DisableMTS = T&lt;br /&gt;
 Driver = Oracle 11g ODBC driver&lt;br /&gt;
 Servername = [SERVER_NAME]&lt;br /&gt;
 XECSchemaOpt =&lt;br /&gt;
 EXECSyntax = T&lt;br /&gt;
 Failover = T&lt;br /&gt;
 FailoverDelay = 10&lt;br /&gt;
 FailoverRetryCount = 10&lt;br /&gt;
 FetchBufferSize = 64000&lt;br /&gt;
 ForceWCHAR = F&lt;br /&gt;
 Lobs = T&lt;br /&gt;
 Longs = T&lt;br /&gt;
 MaxLargeData = 0&lt;br /&gt;
 MetadataIdDefault = F&lt;br /&gt;
 QueryTimeout = T&lt;br /&gt;
 ResultSets = T&lt;br /&gt;
 ServerName =&lt;br /&gt;
 SQLGetData extensions = F&lt;br /&gt;
 Translation DLL =&lt;br /&gt;
 Translation Option = 0&lt;br /&gt;
 DisableRULEHint = T&lt;br /&gt;
 UserID =&lt;br /&gt;
 StatementCache=F&lt;br /&gt;
 CacheBufferSize=20&lt;br /&gt;
 UseOCIDescribeAny=F&lt;br /&gt;
 MaxTokenSize=8192&lt;br /&gt;
&lt;br /&gt;
==Desde Zabbix utilizas el item &amp;quot;Database Monitor&amp;quot;==&lt;br /&gt;
 Name      : Realiza un select en OracleDB&lt;br /&gt;
 Type      : Database monitor&lt;br /&gt;
 Key       : db.odbc.select[selec_generico_{$SID},{$DSN}]&lt;br /&gt;
 User name : {$USER_DB}&lt;br /&gt;
 Password  : {$PASSWD_DB}&lt;br /&gt;
 SQL query : SELECT 1 FROM DUAL&lt;br /&gt;
&lt;br /&gt;
==Links utiles==&lt;br /&gt;
 https://docs.oracle.com/database/121/ADFNS/adfns_odbc.htm#ADFNS1112&lt;br /&gt;
 https://www.zabbix.com/documentation/current/manual/config/items/itemtypes/odbc_checks&lt;/div&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
</feed>