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身份 本地 登陆 进行关闭即可。
|