Oracle 817关闭数据库报ora-00106错误

郑全

1.错误现象：


使用 system用户关闭数据库，报 ora-00106的错误 :


sql>connect system/manager@xxx as sysdba;
SQL> shutdown immediate

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


2.原因：
看错误提示：
ORA-00106 cannot startup/shutdown database when connected to a dispatcher  
Cause(原因): An attempt was made to start or shut down an instance while connected to a shared server via a dispatcher.  

Action(处理)： Reconnect 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.  

大概意思是重新使用内部用户登录，而不要通过监听器调度程序(Dispatcher)来连接。原来是我通过远程客户端来连接不行，于是登录主机：

$ sqlplus /nolog
SQL> conn sys/sys as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.

3.解决办法 ：

重新以 sys身份 本地 登陆 进行关闭即可。