<?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=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC</id>
	<title>Monitorizacion de Bases de Datos vía UnixODBC - 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=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC"/>
	<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC&amp;action=history"/>
	<updated>2026-11-21T22:38:44Z</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=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC&amp;diff=1167&amp;oldid=prev</id>
		<title>Unknown user: /* Errores postibles */</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC&amp;diff=1167&amp;oldid=prev"/>
		<updated>2021-11-21T16:53:40Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;Errores postibles&lt;/span&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw-interface=&quot;&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 16:53, 21 November 2021&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l200&quot;&gt;Line 200:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 200:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  [ISQL]ERROR: Could not SQLConnect&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  [ISQL]ERROR: Could not SQLConnect&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt; &lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-added&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle/instantclient_18_5&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;  # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle/instantclient_18_5&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;

&lt;!-- diff cache key wiki:diff:1.41:old-1166:rev-1167:php=table --&gt;
&lt;/table&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
	<entry>
		<id>https://www.zabbix-es.com.es/index.php?title=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC&amp;diff=1166&amp;oldid=prev</id>
		<title>Unknown user: Created page with &quot;=Preparación del entorno= ==Instalación de Oracle 18c con Dockers==  &#039;&#039;&#039;InfoDoc:&#039;&#039;&#039; https://www.oracle.com/lad/technical-resources/articles/database-performance/imagen-odb18...&quot;</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Monitorizacion_de_Bases_de_Datos_v%C3%ADa_UnixODBC&amp;diff=1166&amp;oldid=prev"/>
		<updated>2021-11-21T16:52:13Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;=Preparación del entorno= ==Instalación de Oracle 18c con Dockers==  &amp;#039;&amp;#039;&amp;#039;InfoDoc:&amp;#039;&amp;#039;&amp;#039; https://www.oracle.com/lad/technical-resources/articles/database-performance/imagen-odb18...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;=Preparación del entorno=&lt;br /&gt;
==Instalación de Oracle 18c con Dockers==&lt;br /&gt;
 &amp;#039;&amp;#039;&amp;#039;InfoDoc:&amp;#039;&amp;#039;&amp;#039; https://www.oracle.com/lad/technical-resources/articles/database-performance/imagen-odb18c-en-docker.html&lt;br /&gt;
          https://soajp.blogspot.com/2019/03/instalar-oracle-database-18c-con-docker.html&lt;br /&gt;
&lt;br /&gt;
  # docker pull dockerhelp/docker-oracle-ee-18c&lt;br /&gt;
  $ docker run -it -p 1521:1521 dockerhelp/docker-oracle-ee-18c bash&lt;br /&gt;
  $ sh post_install.sh&lt;br /&gt;
  $ sqlplus&lt;br /&gt;
  user: sys as sysdba&lt;br /&gt;
  pass: oracle&lt;br /&gt;
&lt;br /&gt;
  SQL&amp;gt; alter session set &amp;quot;_ORACLE_SCRIPT&amp;quot;=true;&lt;br /&gt;
  Session altered.&lt;br /&gt;
  SQL&amp;gt; create user zabbix identified by zabbix1234;&lt;br /&gt;
  User created.&lt;br /&gt;
  SQL&amp;gt; grant dba to zabbix;&lt;br /&gt;
  Grant succeeded.&lt;br /&gt;
&lt;br /&gt;
  SQL&amp;gt; select value from v$parameter where name=&amp;#039;service_names&amp;#039;;&lt;br /&gt;
&lt;br /&gt;
==Instalación de MariaDB con Dockers==&lt;br /&gt;
 # dnf module reset mariadb -y&lt;br /&gt;
 # docker run -d --name mariadb-server -p 3306:3306 -e &amp;quot;MYSQL_ROOT_PASSWORD=zabbix&amp;quot; mariadb&lt;br /&gt;
 # docker exec -it mariadb-server bash&lt;br /&gt;
&lt;br /&gt;
==Instalación de PostgreSQL con Dockers==&lt;br /&gt;
 # dnf module reset postgresql -y&lt;br /&gt;
 # docker run --name postgresql-server -p 5432:5432 -e POSTGRES_PASSWORD=zabbix1234 -d postgres&lt;br /&gt;
 # docker exec -it postgresql-server bash&lt;br /&gt;
 $ psql -h localhost -p 5432 -U postgres -W&lt;br /&gt;
 Password: &amp;#039;&amp;#039;&amp;#039;zabbix1234&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
 psql (14.1 (Debian 14.1-1.pgdg110+1))&lt;br /&gt;
 Type &amp;quot;help&amp;quot; for help.&lt;br /&gt;
 &lt;br /&gt;
 postgres=#&lt;br /&gt;
&lt;br /&gt;
=Instalación ODBC de Oracle=&lt;br /&gt;
 &amp;#039;&amp;#039;&amp;#039;Download:&amp;#039;&amp;#039;&amp;#039; https://www.zabbix.com/documentation/current/manual/config/items/plugins&lt;br /&gt;
           https://www.oracle.com/es/database/technologies/instant-client/linux-x86-64-downloads.html&lt;br /&gt;
&lt;br /&gt;
 # mkdir -p /opt/oracle&lt;br /&gt;
 # cd /opt/oracle&lt;br /&gt;
 # wget https://download.oracle.com/otn_software/linux/instantclient/185000/instantclient-basic-linux.x64-18.5.0.0.0dbru.zip&lt;br /&gt;
 # unzip instantclient-basic-linux.x64-*.zip&lt;br /&gt;
 &lt;br /&gt;
 # wget https://download.oracle.com/otn_software/linux/instantclient/185000/instantclient-odbc-linux.x64-18.5.0.0.0dbru.zip&lt;br /&gt;
 # unzip instantclient-odbc-linux.x64-18.5.0.0.0dbru.zip&lt;br /&gt;
&lt;br /&gt;
==Librerías adicionales que utiliza el Instantclient==&lt;br /&gt;
 # dnf install -y libaio  libnsl&lt;br /&gt;
&lt;br /&gt;
==Linkeamos las librerías==&lt;br /&gt;
 # echo /opt/oracle/instantclient_18_5 &amp;gt; /etc/ld.so.conf.d/oracle-instantclient.conf&lt;br /&gt;
 # ldconfig&lt;br /&gt;
&lt;br /&gt;
=Instalación UnixODBC=&lt;br /&gt;
&lt;br /&gt;
 Para la instalación de dicho conector ODBC lo haremos desde el repositorio de Centos, para ello ejecutaremos en nuestra maquina servidor de Zabbix quien será la que necesita de dicho driver para llevar a cabo las consultas contra las diferentes BBDD:&lt;br /&gt;
&lt;br /&gt;
 # dnf install unixODBC unixODBC-devel -y&lt;br /&gt;
&lt;br /&gt;
 Tras su instalación procederemos a instalar el driver que necesitemos para establecer conexión contra el motor de base de datos deseado, en este caso pondremos el ejemplo de una BBDD PostgreSQL:&lt;br /&gt;
&lt;br /&gt;
 # dnf install postgresql-odbc mariadb-connector-odbc -y&lt;br /&gt;
&lt;br /&gt;
 Tras esto deberemos de configurar dos archivos, uno que hace referencia a la ubicación del driver y el otro a la conexión contra la bbdd.&lt;br /&gt;
 El .conf que hace referencia al driver que utilizaremos para atacar a la bbdd se encuentra en la siguiente ruta:&lt;br /&gt;
&lt;br /&gt;
 /etc/odbcinst.ini&lt;br /&gt;
&lt;br /&gt;
 En el deberemos tener una referencia a cada driver que utilizaremos, por ejemplo en nuestro caso:&lt;br /&gt;
&lt;br /&gt;
=Configuración del odbc.ini=&lt;br /&gt;
==ODBC para MariaDB==&lt;br /&gt;
===odbcinst.ini===&lt;br /&gt;
 [MariaDB]&lt;br /&gt;
 Description     = ODBC for MariaDB&lt;br /&gt;
 Driver          = /usr/lib/libmaodbc.so&lt;br /&gt;
 Driver64        = /usr/lib64/libmaodbc.so&lt;br /&gt;
 FileUsage       = 1&lt;br /&gt;
&lt;br /&gt;
===odbc.ini===&lt;br /&gt;
 [MariaDB01]&lt;br /&gt;
 Description = MariaDB test database&lt;br /&gt;
 Driver      = MariaDB&lt;br /&gt;
 Server      = 10.1.100.101&lt;br /&gt;
 User        = root&lt;br /&gt;
 Password    = zabbix&lt;br /&gt;
 Port        = 3306&lt;br /&gt;
 Database    = mysql&lt;br /&gt;
&lt;br /&gt;
 # isql -v MariaDB01&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 | Connected!                            |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 | sql-statement                         |&lt;br /&gt;
 | help [tablename]                      |&lt;br /&gt;
 | quit                                  |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 SQL&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==ODBC para PostgreSQL==&lt;br /&gt;
===odbcinst.ini===&lt;br /&gt;
 [PostgreSQL]&lt;br /&gt;
 Description     = ODBC for PostgreSQL&lt;br /&gt;
 Driver          = /usr/lib/psqlodbcw.so&lt;br /&gt;
 Setup           = /usr/lib/libodbcpsqlS.so&lt;br /&gt;
 Driver64        = /usr/lib64/psqlodbcw.so&lt;br /&gt;
 Setup64         = /usr/lib64/libodbcpsqlS.so&lt;br /&gt;
 FileUsage       = 1&lt;br /&gt;
&lt;br /&gt;
===odbc.ini===&lt;br /&gt;
 [PGDB01]&lt;br /&gt;
 Description = PostgreSQL connection to AMPG961&lt;br /&gt;
 Driver = PostgreSQL&lt;br /&gt;
 Database = postgres&lt;br /&gt;
 Servername = 10.1.100.101&lt;br /&gt;
 Port = 5432&lt;br /&gt;
 Protocol = 9.5.5&lt;br /&gt;
 ReadOnly = No&lt;br /&gt;
 RowVersioning = No&lt;br /&gt;
 ShowSystemTables = No&lt;br /&gt;
 ConnSettings =&lt;br /&gt;
&lt;br /&gt;
 # isql -v PGDB01 postgres zabbix&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 | Connected!                            |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 | sql-statement                         |&lt;br /&gt;
 | help [tablename]                      |&lt;br /&gt;
 | quit                                  |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 SQL&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==ODBC para Oracle==&lt;br /&gt;
===odbcinst.ini===&lt;br /&gt;
 [Oracle 11g ODBC driver]&lt;br /&gt;
 Description     = Oracle ODBC driver for Oracle 11g&lt;br /&gt;
 Driver          = /opt/oracle/instantclient_18_5/libsqora.so.18.1&lt;br /&gt;
 Setup           =&lt;br /&gt;
 FileUsage       =&lt;br /&gt;
 CPTimeout       =&lt;br /&gt;
 CPReuse         =&lt;br /&gt;
 Driver Logging  = 7&lt;br /&gt;
&lt;br /&gt;
===odbc.ini===&lt;br /&gt;
 [ORADB01]&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 = //10.1.100.101:1521/ORCL18&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;
 # isql -v ORADB01 zabbix zabbix1234&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 | Connected!                            |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 | sql-statement                         |&lt;br /&gt;
 | help [tablename]                      |&lt;br /&gt;
 | quit                                  |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 SQL&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Errores postibles===&lt;br /&gt;
 &amp;#039;&amp;#039;&amp;#039;IMPORTANTE:&amp;#039;&amp;#039;&amp;#039; si teniendo el odbc y el Instantclient de Oracle instalados nos da un error del siguiente tipo puede ser que nos falte configurar el LD_LIBRARY_PATH&lt;br /&gt;
&lt;br /&gt;
 # isql -v ORADB01 zabbix zabbix1234&lt;br /&gt;
 [01000][unixODBC][Driver Manager]Can&amp;#039;t open lib &amp;#039;/opt/oracle/instantclient_18_5/libsqora.so.18.1&amp;#039; : file not found&lt;br /&gt;
&lt;br /&gt;
 [ISQL]ERROR: Could not SQLConnect&lt;br /&gt;
 &lt;br /&gt;
&lt;br /&gt;
 # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle/instantclient_18_5&lt;br /&gt;
 # isql -v ORADB01 zabbix zabbix1234&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 | Connected!                            |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 | sql-statement                         |&lt;br /&gt;
 | help [tablename]                      |&lt;br /&gt;
 | quit                                  |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
</feed>