如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]
ORA-01089 oerr ora 1089 01089, 00000, "immediate shutdown in progress - no operations are permitted" // *Cause: The SHUTDOWN IMMEDIATE command was used to shut down // a running ORACLE instance, so your operations have been // terminated. // *Action: Wait for the instance to be restarted, or contact your DBA.
|
Bug 13724193 ORA-1089 over database link involving transitioned primary 本文介绍bug 13724193的简要概述。 影响:
被修正:
临时补丁可能适用于早期版本 –点击 这里 查看。
描述 如果主实例尚未重启，使用DB链接到打开的主数据库（或从其链接）的SQL命令可能会报告正在关机，因为它从“以只读方式打开”的standby被转换。 例如： select * from dual@PRIMARY; ^ ORA-01089: immediate shutdown in progress – no operations are permitted ORA-02063: preceding line from ADV
Rediscovery Notes再认识注意事项 如果包含dblink 到主数据库（或从其链接）的SQL语句失败显示 ORA-01089: immediate shutdown in progress – no operations are permitted and the primary database instance has not been restarted since it transitioned from an “open read only” physical standby then this bug is being hit.不允许任何操作且主数据库实例未被重启，因为它从“以只读方式打开”的物理standby被转换，则遇到该bug。
解决方案 重启主实例。
参考 Bug:13724193 (This link will only work for PUBLISHED bugs) |
Leave a Reply