Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

A couple mornings now my Oracle database has hit this error and not come up for an hour or so. Then it works fine for the rest of the day without needing any interaction. But this messes up my apps relying on Oracle being up for the whole time they run.

Any ideas?

2009-09-11 04:52:56,343 [Orion Launcher] ERROR conn.ConnectionService verifyRepositoryEx.496 - Invalid Connection Pool. ERROR = ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

2009-09-11 04:52:56,734 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2009-09-11 04:52:56,890 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2009-09-11 04:52:56,953 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.reports.em.RepIntg
2009-09-11 04:52:57,015 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration
2009-09-11 04:52:57,031 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration
2009-09-11 04:52:57,031 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration
2009-09-11 04:52:57,031 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration
2009-09-11 04:52:57,031 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg
2009-09-11 04:52:57,031 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ocs.mntr.target.OcsCalGrpIntegration
2009-09-11 04:52:57,078 [OmsServiceDriver thread] WARN  jdbc.ConnectionCache _getConnection.303 - Got a fatal exeption when getting a connection; Error code = 1034; Cleaning up cache and retrying
2009-09-11 04:52:57,078 [OmsServiceDriver thread] WARN  jdbc.ConnectionCache _getConnection.306 - ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
share|improve this question
    
Does this only happen during certain times of the day? Is it every day? Do you run queries over night that encounter problems? Is it possible you have a long running backup process or other application that might be tying up connections? –  Josh Budde Sep 11 '09 at 14:22
1  
Do you close the database at night to back it up ? –  Vincent Sep 11 '09 at 15:03
    
What platform is this Oracle Database running on? –  Cephas Sep 15 '09 at 4:18
add comment

1 Answer

This generally occurs when you are trying to connect to a database that is not running. You can generally visualise Oracle as a collection of worker bees all gathered round a honeycomb. The 'Shared Memory Realm' is the honeycomb; if its not there you've got big problems.

What is contained in the alert log?

I'd start by figuring out what schedule jobs are running at the OS level on the server. Something is either shutting the database down and then restarting it (backup?) or you may have some kind of 'watchdog' task that is restarting the instance after it crashes for some reason.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.