Oracle OCI client not properly closing connections

thedstro · Post by **thedstro** » Tue May 20, 2008 12:43 am

After installing HostMonitor and wanting to use it to monitor our main database server (running Oracle 10g) we started running out of dedicated server processes... it seems that HostMonitor is opening a new connection every time it runs a test and these connections are staying open almost indefinitely, until they time out.

This also happens if we use "shared server" mode, it takes longer to happen, but eventually it runs out of shared server processes as well.

Other applications we have that frequently open/close connections, including those using OCI, do not cause the same kind of lingering connections.

Is the "check oracle server" test calling OCILogoff() to close these connections after it tests?

KS-Soft Europe · Post by **KS-Soft Europe** » Tue May 20, 2008 12:58 am

thedstro wrote:After installing HostMonitor and wanting to use it to monitor our main database server (running Oracle 10g) we started running out of dedicated server processes... it seems that HostMonitor is opening a new connection every time it runs a test and these connections are staying open almost indefinitely, until they time out.

Could you provide more information, please?
- What version of HostMonitor do you use?
- What Windows do you use? Service Pack?
- What version of Oracle Client do you use?
- What exact version of Oracle Call Interface (oci.dll) have you installed?

thedstro wrote:Is the "check oracle server" test calling OCILogoff() to close these connections after it tests?

HostMonitor calls OCISessionEnd() to release user session. When HostMonitor performs Oracle test it uses OCIServerAttach and OCISessionBegin fuctions (oci.dll) to create a user session and begins a user session for a given server. If session established, HostMonitor closes session and sets "host is alive" status.

Regards,
Max

thedstro · Post by **thedstro** » Tue May 20, 2008 1:22 am

Could you provide more information, please?
- What version of HostMonitor do you use? 7.22c
- What Windows do you use? Service Pack? XP, SP2
- What version of Oracle Client do you use? Oracle InstantClient 11.1.0.6.0 Basic
- What exact version of Oracle Call Interface (oci.dll) have you installed? oci.dll reports itself as version 11.1.0.1

Are you also calling OCIServerDetach() and using OCIHandleFree() to free all associated handles?

http://download.oracle.com/docs/cd/B141 ... htm#462207
"Terminating an Application"

thedstro · Post by **thedstro** » Tue May 20, 2008 3:49 pm

Sooooooooooo................. yeah.

The problem was not caused by the Check Oracle Server test. Rather, the stacking connections are caused by one of the web applications which is ALSO being monitored by HostMonitor. So, the connections are just connections being allocated from the connection pool, and not HostMonitor improperly closing its connections.

Sorry...

KS-Soft · Post by **KS-Soft** » Tue May 20, 2008 7:28 pm

Are you also calling OCIServerDetach() and using OCIHandleFree() to free all associated handles?

Sure. HostMonitor calls OCISessionEnd(), OCIServerDetach() and OCIHandleFree() to release several handles

The problem was not caused by the Check Oracle Server test. Rather, the stacking connections are caused by one of the web applications which is ALSO being monitored by HostMonitor. So, the connections are just connections being allocated from the connection pool, and not HostMonitor improperly closing its connections.

Thank you for explanation

Regards
Alex

Oracle OCI client not properly closing connections

Oracle OCI client not properly closing connections

Re: Oracle OCI client not properly closing connections