[ORACLE] ORA-00106: Cannot startup/shutdown database when connected to a dispatcher

[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 dispatcher

Error 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 時跳錯

image

 

解決方案

1.開啟 tnsnames.ora 並將 (SERVER=DEDICATED) 改為 (SERVER =DEDICATED)

image

2.關閉資料庫連線並重新連接

3.關閉資料庫成功

 

參考資料

Thread: ORA-00106: cannot startup/shutdown database when connected to a dispatcher

ORA-00106: 无法在连接到调度程序时启动/关闭数据库

 

創用 CC 授權條款
本著作係採用創用 CC 姓名標示-相同方式分享 4.0 國際 授權條款授權,文章歡迎轉載,請註明出處,謝謝~~~