This sensu plugin provides native Oracle instrumentation.

• bin/check-oracle-alive.rb
• bin/check-oracle-query.rb

-- check a single connection
check-oracle-alive.rb -u scott -p tiger -d hr

-- check a single connection with timeout
check-oracle-alive.rb -u scott -p tiger -d hr -T 30

-- check multiple connections as defined in a file, use 5 worker threads (-W 5) and verbose output (-v)
check-oracle-alive.rb -f connections.csv -W 5 -v

> cat connections.csv
  # production connection
  example_connection_1,scott/tiger@hr

  # test connection
  example_connection_2,scott/tiger@hr_test

-- check for invalid objects in a schema, shows type and name if there are invalid objects (-s), define a ciritical boundary only (-c)
check-oracle-query.rb -u scott -p tiger -d hr -t -s -query "select object_type, object_name from user_objects where status = 'INVALID'" -c "value > 0"

-- same as above but check for all connections in a file, use 5 worker threads
check-oracle-query.rb -f connections.csv -t -s -query "select object_type, object_name from user_objects where status = 'INVALID'" -c "value > 0" -W 5

Installation and Setup

Currently supported and tested ruby versions are:

• 4.0 (EOL March 31 2029)
• 3.4 (EOL March 31 2028)
• 3.3 (EOL March 31 2027)
• 3.2 (EOL March 31 2026)

Ruby versions not tested anymore:

• 3.1 (EOL March 31 2025)
• 3.0 (EOL March 31 2024)
• 2.7 (EOL March 31 2023)
• 2.6 (EOL March 31 2022)

Note: the default branch was renamed from master to main in 2025/08 to align with modern Git defaults. Please base new work and pull requests on main.

This project uses Trusted Publishing to securely publish gems to RubyGems.org. Trusted Publishing eliminates the need for long-lived API tokens by using OpenID Connect (OIDC) to establish a trusted relationship between GitHub Actions and RubyGems.org.

With Trusted Publishing configured, gem releases are automatically published to RubyGems when the release workflow runs, providing a more secure and streamlined publishing process.

Bug reports and pull requests are welcome on GitHub at https://github.com/thomis/sensu-plugins-oracle. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

1. Fork it ( https://github.com/thomis/sensu-plugins-oracle/fork )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request

The gem is available as open source under the terms of the MIT License.