[ORACLE] ORA-00106: Cannot startup/shutdown database when connected to a dispatcher
錯誤概述
數據庫運行在共享模式下,在數據庫機器上進行操作,其tnsnames.ora配置中使用的是SHARED模式,通過這個模式登進去是無法進行shutdown和close操作,解決的辦法就是將SHARED改成DEDICATED。
錯誤訊息
Oracle Error: ORA-00106
Error Description:
Cannot startup/shutdown database when connected to a dispatcherError Cause:
An attempt was made to startup/shutdown database when connected to a shared server via a dispatcher.Action:
Re-connect as user INTERNAL without going through the dispatcher. For most cases, this can be done by connect to INTERNAL without specifying a network connect string.
情境說明
Oracle 要 shut down 時跳錯
解決方案
1.開啟 tnsnames.ora 並將 (SERVER=DEDICATED) 改為 (SERVER =DEDICATED)
2.關閉資料庫連線並重新連接
3.關閉資料庫成功
參考資料
Thread: ORA-00106: cannot startup/shutdown database when connected to a dispatcher
ORA-00106: 无法在连接到调度程序时启动/关闭数据库
本著作係採用創用 CC 姓名標示-相同方式分享 4.0 國際 授權條款授權,文章歡迎轉載,請註明出處,謝謝~~~