ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
来源:互联网 发布:怎样使用淘宝优惠券 编辑:程序博客网 时间:2024/06/06 03:04
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
SQL> select SID, PROCESS, PROGRAM
2 from v$session where type = 'USER' and
3 SID <> (select DISTINCT SID from v$mystat);
SID PROCESS
---------- ------------------------
PROGRAM
------------------------------------------------
1 20494
sqlplus@dg2 (TNS V1-V3)
SQL> alter database commit to switchover to primary WITH SESSION SHUTDOWN;
Database altered.
0 0
- 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)
- 不知道alter database close 有什么用?
- 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 错误解决
- alter database
- ALTER DATABASE
- ALTER DATABASE ...
- ALTER DATABASE
- ORA-15097: cannot SHUTDOWN ASM instance with connected client
- alter database recover to logical standby xxx no response
- only final is permitted
- 倒排索引算法的Java实现
- MySQL数据库的常用命令
- jquery获取表单元素select option的值,对select option操作
- 大数据应用时Oracle优化实例
- Kotlin学习笔记——基本类型
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
- 全排列
- 01随机生成函数
- SecureCRT配置前--Linux网卡设置
- Android:自定义view实现动画
- mac10.9 安装caffe CPU_Only 模式
- 安装nfs步骤
- Encountering ORA-01153: an incompatible media recovery is active When Starting Up Phycial Standby
- 错误记录:this.requestWindowFeature(Window.FEATURE_NO_TITLE)报错或没效果