ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
http://www.cnblogs.com/killkill/archive/2010/12/20/1911172.html
以上语句有可能会遇到如下错误:
1
2
3
4
|
alter database commit to switchover to physical standby * ERROR at line 1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected |
这是由于一些连接还没有释放所致的,将前端应用关闭后如果还出现这种情况,可以用以下语句确认一下有哪些连接: