* ERROR at line 1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 此错误的因为主库中有活动的会话造成的,解决的办法为: 1.杀掉活动会话,重新执行该命令 2.在该命令后面加上with session shutdown即 ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUT...
ERROR at line1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 现在需要连接进备库检查数据的一致性,为了主备切换做准备,但是10g的库处在open状态就无法开启实时同步,Oracle 10g,要在mount状态下,才能开启MRP。然而11g在open就可以 此时的备库处于mount且同步的状态,外部plsql连接报...
ERROR at line 1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected SQL> SELECT SID, PROCESS, PROGRAM FROM V$SESSION WHERE TYPE = 'USER' AND SID <> (SELECT DISTINCT SID FROM V$MYSTAT); SID PROCESS PROGRAM --- --- --- 528 26545racgimon@rac1(TNS V1-V3) 53...
alter database recover managed standby database disconnect from session * ERROR at line 1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 提示是在有连接的情况下,没法执行,检查发现是rman客户端在连接,关闭后,在执行正常了。
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 这是由于一些连接还没有释放所致的,将前端应用关闭后如果还出现这种情况,可以...
alter database commit to switchover to physical standby * ERROR at line 1: ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 这是由于一些连接还没有释放所致的,将前端应用关闭后如果还出现这种情况,可以用以下语句确认一下有哪些连接:...