Error while trying to retrieve text for error ORA-01804 (OCIError)

Hi Experts,

I am getting an ORA-01804 error in my Sensu check. Although when I ran my sensu script in the terminal, I get the result that I want. But when Sensu Client picks it up, I can see in Uchiwa and the log files the following:

{“timestamp”:“2017-09-10T12:11:44.300319+0000”,“level”:“info”,“message”:“publishing check result”,“payload”:{“client”:“OTM”,“check”:{“type”:“metric”,“command”:"/opt/sensu/embedded/bin/metrics-stale-transmissions.rb -s 30",“interval”:600,“handle_when”:{“reset”:600},“standalone”:true,“payload-type”:“json”,“name”:“stale-transmission”,“issued”:1505045504,“executed”:1505045504,“duration”:0.283,“output”:"oci8lib.c:280:in oci8lib_240.so: Error while trying to retrieve text for error ORA-01804 (OCIError)\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:55:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/gems/2.4.0/gems/ruby-oci8-2.2.4.1/lib/oci8.rb:107:in<top (required)>’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:inrescue in require’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:40:in require'\n\tfrom /opt/sensu/embedded/bin/sqlcore.rb:4:in<top (required)>’\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in require_relative'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in

'\n",“status”:3}}}

``

I researched and found that I just need to properly set my environment variables. And after looking into them, they are indeed properly set but still this error persists

LD_LIBRARY_PATH=/opt/oracle/11R23/lib:/opt/oracle/11R23/lib:/opt/oracle/11R23/lib:
ORACLE_HOME=/opt/oracle/11R23
NLS_LANG=American_America.UTF

``

Hoping you can assist on this issue. Thank you

Regards,
Peter

Hey Peter! I know it’s been a little while on this one. Have you made any progress you can share? If not, bumping this back up into people’s inbox. Good luck!

Matt Broberg

VP Community, Sensu

···

On Sunday, September 10, 2017 at 5:37:56 AM UTC-7, Peter wrote:

Hi Experts,

I am getting an ORA-01804 error in my Sensu check. Although when I ran my sensu script in the terminal, I get the result that I want. But when Sensu Client picks it up, I can see in Uchiwa and the log files the following:

{“timestamp”:“2017-09-10T12:11:44.300319+0000”,“level”:“info”,“message”:“publishing check result”,“payload”:{“client”:“OTM”,“check”:{“type”:“metric”,“command”:“/opt/sensu/embedded/bin/metrics-stale-transmissions.rb -s 30”,“interval”:600,“handle_when”:{“reset”:600},“standalone”:true,“payload-type”:“json”,“name”:“stale-transmission”,“issued”:1505045504,“executed”:1505045504,“duration”:0.283,“output”:"oci8lib.c:280:in oci8lib_240.so: Error while trying to retrieve text for error ORA-01804 (OCIError)\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:55:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/gems/2.4.0/gems/ruby-oci8-2.2.4.1/lib/oci8.rb:107:in<top (required)>‘\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:in require'\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:133:inrescue in require’\n\tfrom /opt/sensu/embedded/lib/ruby/site_ruby/2.4.0/rubygems/core_ext/kernel_require.rb:40:in require'\n\tfrom /opt/sensu/embedded/bin/sqlcore.rb:4:in<top (required)>'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in require_relative'\n\tfrom /opt/sensu/embedded/bin/metrics-stale-transmissions.rb:25:in

'\n",“status”:3}}}

``

I researched and found that I just need to properly set my environment variables. And after looking into them, they are indeed properly set but still this error persists

LD_LIBRARY_PATH=/opt/oracle/11R23/lib:/opt/oracle/11R23/lib:/opt/oracle/11R23/lib:
ORACLE_HOME=/opt/oracle/11R23
NLS_LANG=American_America.UTF

``

Hoping you can assist on this issue. Thank you

Regards,
Peter