ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
Database with No Only ALTER CLOSE ORA permitted
2023-09-14 09:01:15 时间
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 |
这是由于一些连接还没有释放所致的，将前端应用关闭后如果还出现这种情况，可以用以下语句确认一下有哪些连接：
相关文章
- 从零实现ORM框架GeoORM-database/sql基础-01
- ORA-01038: cannot write database file version string with ORACLE version string ORACLE 报错 故障修复 远程处理
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected ORACLE 报错 故障修复 远程处理
- ORA-01239: database must be in ARCHIVELOG mode to use external cache ORACLE 报错 故障修复 远程处理
- ORA-25294: Cannot propagate user buffered messages to a database with version lower than 10.2 ORACLE 报错 故障修复 远程处理
- ORA-29311: export dump file was not generated by this database, string does not match ORACLE 报错 故障修复 远程处理
- ORA-39322: Cannot use transportable tablespace with TIMESTAMP WITH TIME ZONE columns and different time zone version. ORACLE 报错 故障修复 远程处理
- ORA-47953: Oracle Data Pump authorization for Oracle Database Vault to string on schema string already exists ORACLE 报错 故障修复 远程处理
- ORA-01038: cannot write database file version string with ORACLE version string ORACLE 报错 故障修复 远程处理
- ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists ORACLE 报错 故障修复 远程处理
- MySQL: Database Administration and Management（mysqldbo）
- Oracle PDM Generation: Quick Insight into Database Design（oracle生成pdm）
- MySQL： Power of a Database Engine（mysqlm）
- store procedureEnhancing Database Performance with MSSQL Stored Procedures（mssqlwhen）
- databaseSecure Your Oracle Database with TPS Technologies（tpsoracle）
- Maximizing Database Performance with Oracle IOPS Technology（oracleiops）
- How to Connect MS SQL Database with PHP: A Quick Guide（mssqlphp）
- Secure Your MySQL Database With AntiInjection Code（mysql防注入代码）
- Maximizing Efficiency with Oracle ODT: Unlocking Your Database Potential（oracleodt）
- 分析学习Oracle深入理解使用With 分析（oracle使用with）