Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Foglight Data Missing: ORA-01033: ORACLE initialization or shutdown in progress
Description
When viewing graphs there are consistent gaps in data during a specific time of day.
Reviewing the Foglight Management Server (FMS) bundle > Logs directory shows recent Datasource auto thread dumps.
Datasource Auto Thread dumps
Exception message: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
))
paried with the Management server logs
Management Server Logs
[QuartzScheduler.PersistencePolicy_Worker-1] com.quest.nitro.service.persistence.obs.handler.AbstractObservationPersister - An error has occurred while persisting observations.
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
Cause
The database was subjected to an unexpected maintenance cycle
Resolution
Ensure a cohesive maintenance cycle between the Foglight Managment server application and it's repository.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
