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

2015-07-03

7242
0
Oracle
2017-09-05

錯誤概述

數據庫運行在共享模式下，在數據庫機器上進行操作，其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.

情境說明