重庆思庄Oracle、Redhat认证学习论坛

标题: Oracle 817关闭数据库报ora-00106错误 [打印本页]

作者: 郑全 时间: 2018-12-12 09:27
标题: 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身份本地登陆进行关闭即可。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)