ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected解决方法
来源:互联网 发布:画画软件大全下载 编辑:程序博客网 时间:2024/05/20 02:27
在进行物理主备库角色转换的时候遇到ORA-01093错误
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
此错误的因为主库中有活动的会话造成的,解决的办法为:
1.杀掉活动会话,重新执行该命令
2.在该命令后面加上with session shutdown即
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected解决方法
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
- ORA-01093: alter database close only permitted with no sessions connected
- ORA-01126 & alter database archivelog
- Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (文档 ID 1296264.1)
- ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
- ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
- 不知道alter database close 有什么用?
- Oracle数据库关闭异常(ORA-01089: immediate shutdown in progress - no operations are permitted)的解决方法
- Oracle数据库关闭异常(ORA-01089: immediate shutdown in progress - no operations are permitted)的解决方法
- KEIL提示“No target connected”的解决方法
- database crash with ora-00494
- ORA-01089 immediate shutdown in progress - no operations are permitted
- 161.In your database instance, the user sessions are connected to the database server from the remot
- ORA-1122 signalled during: alter database open 错误解决
- Database is read-only 的解决方法
- alter database
- 宽带中国战略解读系列
- 深入java内部
- Java 信号量
- Linux下的目录树
- 将两个数交换--引用
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected解决方法
- 2013年9月15日 人人面试被虐 郁闷
- 实现怎样在android开发中捕获应用中的日志
- 安装java_ee_sdk-7-jdk7-windows-x64-ml.exe & wls1211_generic.jar
- 用c语言产生随机数
- CGI跟我学
- js循环动态绑定带参数函数
- Java单例模式
- 工作一年的一些感受