Very basic Oracle support for Zabbix server.

[ftclausen]

Hello,

Intro

We have a need to connect to an Oracle database since most of our DBAs know Oracle - it is the most supported RDBMS for us to use. I have modified the cookbook to support connecting as an oracle client only. These changes make no attempt whatsoever to configure the Oracle server (yet - maybe in a future PR).

I accept this may not be merge worthy as it currently stands but I thought I'd pass it along to the community in case someone else finds it useful.

This is all not heavily tested outside of our environment so feedback welcome.

Prerequisites

As alluded to above - this requires the following

• Fully configured Oracle server with the Zabbix tablespaces, schema and user ready to go
• Oracle instantclient RPMs available to download - set the appropriate attributes as described in the oracle-instantclient cookbook
• Oracle instantclient attributes set allowing successful installation of the instantclient binaries

  Attributes

• node['zabbix']['database']['install_method'] - set this to "oracle"
• node['zabbix']['database']['dbname'] - set this to the Oracle SID
• The rest of the attributes serve the same functions

[laradji]

Hi @ftclausen ,

This looks good to me, @guilhem can you give a +1 too ?

[laradji]

oh and thank you @ftclausen :)

[guilhem]

sorry my bad

[ftclausen]

Great! Let me know if you guys have any further questions. In time I would like to fork the Opscode database cookbook in order to add a proper Oracle provider. Once that is done and merged we can look at extending the provider here to actually support creating the schema, user, tablespaces and so on.

[guilhem]

it doesn't merge anymore.

Can you rebase it?

[ftclausen]

I did the following

• Update the master branch in my forked repo to bring it up to date with the main project master
• Rebased the latest master onto my "basic-oracle" branch
• Resolved conflicts along the way

Let me know if the result is merge-able or if I can do anything differently.