ORA-1093 signalled during

来源：互联网发布：淘宝客如何在微信推广编辑：程序博客网时间：2024/06/05 06:24

在进行主备库切换的时候alter里面出现了这个错误;

SQL> alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

此时日志报错：
Active process 2382 user 'oracle' program 'oracle@oracle11g-std (TNS V1-V3)'
System State dumped to trace file /home/oracle/app/diag/rdbms/ora11standby/ora11/trace/ora11_ora_1908.trc
Errors in file /home/oracle/app/diag/rdbms/ora11standby/ora11/trace/ora11_ora_1908.trc:
Non critical error ORA-48113 caught while writing to trace file "/home/oracle/app/diag/rdbms/ora11standby/ora11/trace/ora11_ora_1908.trc"
Error message:
Writing to the above trace file is disabled for now on...
CLOSE: Active sessions prevent database close operation
ORA-1093 signalled during: alter database commit to switchover to physical standby...
知道是有活动回话还连接到数据库上

而且日志中已经说明是那个回话了
也可以使用一下的语句查询出来
SELECT SID, PROCESS, PROGRAM FROM V$SESSION
WHERE TYPE = 'USER'
AND SID <> (SELECT DISTINCT SID FROM V$MYSTAT);

解决办法就是：
关闭回话，或者是在alter后面加上with session shutdown