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( 
at com.uptimesoftware.uptime.database.JdbcExecutor.execute( 
at com.uptimesoftware.uptime.dataservice.query.Query.getResultSet( 
at com.uptimesoftware.uptime.dataservice.QueryExecutor.getResultSet( 
at com.uptimesoftware.uptime.dataservice.QueryExecutor.executeQuery( 
at com.uptimesoftware.uptime.dataservice.ProtocolHandler.handleQuery( 
at 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;