ORA-27101:共享内存域不存在

Question

几个早上，我的Oracle数据库碰到了这个错误，一个多小时都没有出现。然后，它可以在一天的剩余时间内正常工作，而不需要任何交互。但这会让我的应用程序陷入困境，我的应用程序在运行过程中一直依赖甲骨文。

有什么想法吗？

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

Answer 1

当您试图连接到没有运行的数据库时，通常会发生这种情况。你通常可以想象甲骨文是一群聚集在蜂巢周围的工蜂。“共享内存领域”就是蜂巢；如果它不在那里，你就会遇到大问题。

警报日志中包含了什么？

我首先要弄清楚在服务器上操作系统级别上运行的调度作业是什么。有些东西要么关闭数据库，然后重新启动它(备份？)或者，您可能有某种“看门狗”任务，它在实例因某种原因崩溃后重新启动。