Page 1 of 1
Monitor Oracle Server, session will always keep connecting?!
Posted: Mon May 20, 2019 5:20 am
by xpertech
When use default Oracle plugins, the sessions will occupied and keep connecting, is that normal?
Is it possible each time after got the monitored data and then close session, and re-connect at next monitor?
Re: Monitor Oracle Server, session will always keep connecti
Posted: Mon May 20, 2019 4:34 pm
by ssax
After talking with another tech about this we came to these conclusions:
It should be the oracle server that cleans up the sessions, this should be an adjustable setting.
There could be a bug in the check_oracle_health plugin that causes it to exit without ending the session, we have not been able to reproduce this though and I personally haven't seen it.
Try going to Configure > Core Config Manager > Commands:
- Update all of your oracle command to add
--method sqlplus
- Save
- Apply Config
- Test
That may take care of it.
I don't think there is a way to force or not require the reuse of sessions from the plugin side, the command line options don't list anything here:
https://labs.consol.de/nagios/check_ora ... parameters