Hi, i'm looking for a documentation about how install Zabbix 6.0 using an Oracle Database, I only found tutorials and installers for mysql and postgresql, but not for oracle. Thanks in advance.
-
-
When asking questions here, it's always helpful to provide information about what operating system or Linux distribution you're using, as it can make it easier to tailor the response. Since you didn't provide that, I can only speak in general terms.
Most sites that are using Zabbix are using either MySQL/MariaDB/Percona or PostgreSQL/TimeScaleDB for the Zabbix database backend, so most of the documentation and examples are tailored for those more common cases.
Oracle is a supported Zabbix database backend, it just doesn't have as many sites using it, so the documentation is somewhat sparse.
When the Zabbix developers generate packages (the components are split into multiple separate packages), they generate some packages that are specifically tailored to work with a database backend like MySQL or PostgreSQL. Again, because Oracle isn't as commonly used as a backend, it appears they don't provide pre-built packages that are tailored for Oracle as a backend. That's why you're not seeing an option to select the pre-built packages for Oracle on the download page.
The recipes they use to build their packages have sections for Oracle in the recipe, though, so what I would in your case is download their source RPM (or the Debian/Ubuntu equivalent, if you're not using an RPM-based system) and build your own packages that are configured for Oracle as a backend.
Once you have a zabbix-server package that uses OCI and knows how to talk to an Oracle database, the remainder of the setup is similar to setup for other database. You will need to create a "database" (in Oracle, it's probably a "schema", since Oracle uses some of the same terms but they have different meanings from many other databases) and a "zabbix" user that can access it, and then you would need to load some SQL to create all the tables and some separate SQL to initially populate a few things in the database.
You probably will also need to build separately the PHP oci8 extension, so that the Zabbix front end (web interface) can also access the database.
If you post specific questions on these forums and I see them, I'll try help, but my site never used Oracle for a Zabbix database backend (we use MariaDB), and we migrated all of our production databases off of Oracle a couple years ago, so I no longer have any Oracle access.
Comment