Oracle database not responding in up.time interface

This article addresses the symptom of seeing Database Not Responding messages in the up.time User Interface. The message will typically be similar to the following error:

=========================================================
Database is not responding

<< java.lang.RuntimeException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
at com.uptimesoftware.uptime.database.QueryDatabaseConnector.executeWork(QueryDatabaseConnector.java:24)
at com.uptimesoftware.uptime.database.JdbcExecutor.execute(JdbcExecutor.java:34)
at com.uptimesoftware.uptime.dataservice.query.Query.getResultSet(Query.java:81)
at com.uptimesoftware.uptime.dataservice.QueryExecutor.getResultSet(QueryExecutor.java:30)
at com.uptimesoftware.uptime.dataservice.QueryExecutor.executeQuery(QueryExecutor.java:13)
at com.uptimesoftware.uptime.dataservice.ProtocolHandler.handleQuery(ProtocolHandler.java:143)
at com.uptimesoftware.uptime.dataservice.ProtocolHandler.run(ProtocolHandler.java:58)
at java.lang.Thread.run(Unknown Source)
=========================================================

This error indicates that the Oracle open cursor limit has been reached.   To resolve this issue, try increasing the open_cursor limit by using the following command:

ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;