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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB