This article addresses the symptom of seeing Database Not Responding messages in the Uptime Infrastructure Monitor 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;