Page tree
Skip to end of metadata
Go to start of metadata

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;