Dropped Oracle Connections

[Former Member]

xMII v11.0.2. Several (on different xMII servers) connections to an Oracle v9.2.0.6 DB, using default driver oracle.jdbc.driver.OracleDriver

Data sources stay connected for "a while" then drop out, and am often not able to reconnect for some time.

Our Oracle folks seem to think there is a problem with the client (xMII). Any ideas?

Errors:

<b>(Occurs when xMII tries to query DB when connection has failed)</b>

"An error occurred while creating a DB connection. Connection may have been prevented due to too many waiting connections in pool."

<b>(Occurs when attempting manual reconnect from xMII after connection has failed)</b>

2007-08-02 08:45:05,273 [ServletExec: request: time=1186058691835, uri=/Lighthammer/Illuminator] FATAL Connector - Unable to create connection pool for FLO_SampleManager: Fatal error while filling connection pool for jdbc:oracle:thin:@<REM>:<REM>:<REM>

2007-08-02 08:45:05,273 [ServletExec: request: time=1186058691835, uri=/Lighthammer/Illuminator] SYSTEM Connector - Create server FLO_SampleManager[serverClassName=com.lighthammer.Illuminator.connectors.IDBC.IDBC, enabled=true]

2007-08-02 08:45:28,601 [ServletExec: request: time=1186058728538, uri=/Lighthammer/Illuminator] SYSTEM SessionHandler - Session timeout set to 120 minutes

2007-08-02 08:45:35,117 [ServletExec: request: time=1186058731960, uri=/Lighthammer/Illuminator] ERROR ConnectionPool - Fatal error while filling connection pool for jdbc:oracle:thin:@<REM>:<REM>:<REM>

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.fill(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.initialize(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionPool.<init>(Unknown Source)

at com.lighthammer.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(Unknown Source)

at com.lighthammer.Illuminator.server.ServerObject.createHolder(Unknown Source)

at com.lighthammer.Illuminator.server.ServerObject.<init>(Unknown Source)

at com.lighthammer.Illuminator.server.ServerStore.addServer(Unknown Source)

at com.lighthammer.Illuminator.server.ServerStore.updateServer(Unknown Source)

at com.lighthammer.Illuminator.config.system.ServersProxy.update(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.lighthammer.Illuminator.services.admin.Add.processRequest(Unknown Source)

at com.lighthammer.Illuminator.services.handlers.Admin.process(Unknown Source)

at com.lighthammer.Illuminator.services.handlers.Admin.processRequest(Unknown Source)

at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source)

at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638)

at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236)

at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283)

at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96)

at com.lighthammer.Illuminator.security.IllumFilter.doFilter(Unknown Source)

at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60)

at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2140)

at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1804)

at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091)

at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973)

at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167)

at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204)

at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)

[jcgood25]

Paul,

I hope you are well on your way with plans on updating your version, especially since 11.0 is no longer an officially supported product.

Do you have a ValidationQuery in your data server settings?

Regards,

Jeremy Good

[Former Member]

Hello Jeremy,

Point taken on the version we are running.

But, yes, validation query: <i>SELECT SYSDATE FROM DUAL</i>

[jcgood25]

I vaguely recall some connection pool changes made in the 11.5 version...

When do you typically see this happen - first thing in the morning? It is after a long period of inactivity or is this data server used all the time during your shift coverage that it really shouldn't get stale? Are you using the IP address or machine name in the ServerURL - any potential issues with DNS?

Regards,

Jeremy

[Former Member]

Well, we have jobs that connect to this DB, running on a daily basis. Connection is fine for a while -- a week or two, usually -- then it drops out.

Using the same connection on several different servers.

Tried using the DNS vs IP, no difference in behavior. Able to telnet to Oracle server:port via full DNS, short DNS, IP with no problems.

Thanks,

Paul

[Former Member]

Sounds like legitimate network issues or maybe the database is being bounced periodically for maintenance?