几个早上,我的 Oracle 数据库遇到了这个错误,一个小时左右都没有出现。然后它可以在一天的剩余时间里正常工作,无需任何交互。但这会弄乱我的应用程序,因为它们依赖于 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
当您尝试连接到未运行的数据库时,通常会发生这种情况。您通常可以将 Oracle 想象为聚集在蜂巢周围的工蜂集合。“共享内存领域”是蜂窝;如果它不存在,你就有大问题。
警报日志中包含什么?
我首先要弄清楚服务器上的操作系统级别正在运行哪些计划作业。某些东西要么关闭数据库然后重新启动它(备份?),要么您可能有某种“看门狗”任务在实例由于某种原因崩溃后重新启动它。