ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
来源:互联网 发布:淘宝上定制购物小票 编辑:程序博客网 时间:2024/05/22 09:17
上午群里一朋友说在500w的表上建索引,半个小时都没有建完,有点不正常,就讨论如何减少建索引的时间,用了nologging +并行,但是效果不明显,朋友一心急,就自己shutdown immediate了. 但是问题是shutdown 没有结束。 挂住了。 在连接就报错。
ORA-01089: immediate shutdown in progress - no operations are permitted
遇到这种情况,只能shutdown abort 后在启动。 用startup force 也行。
关于这几种启动和关闭的方式的区别,可以参考我的另一篇Blog:
深刻理解Oracle数据库的启动和关闭
http://blog.csdn.net/xujinyang/article/details/6830269
如何加快建 index 索引 的时间
http://blog.csdn.net/xujinyang/article/details/6829389
------------------------------------------------------------------------------
- ORA-01089 immediate shutdown in progress - no operations are permitted
- ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
- ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
- Oracle数据库关闭异常(ORA-01089: immediate shutdown in progress - no operations are permitted)的解决方法
- Oracle数据库关闭异常(ORA-01089: immediate shutdown in progress - no operations are permitted)的解决方法
- ORA-01089 immediate shutdown in progress
- ORA-01090: shutdown in progress - connection is not permitted
- ORA-01090: shutdown in progress - connection is not permitted
- ORA-01090: shutdown in progress - connection is not permitted
- ORA-01090 shutdown in progress - connection is not permitted
- ORA-01090: shutdown in progress - connection is not permitted
- ORA-01090: shutdown in progress - connection is not permitted
- ORA-01090: shutdown in progress - connection is not permitted
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ora-01033:oracle initialization or shutdown in progress 解决方法
- ora-01033:oracle initialization or shutdown in progress 解决方法
- RMAN 系列(二) ---- RMAN 设置和配置
- 面向任务流的交互设计-2.0的信息结构
- How to construct a Hopfield network
- 随便聊聊我眼中的SNS
- css定义格式中逗号,空格,冒号,点号的含义
- ORA-01089 immediate shutdown in progress - no operations are permitted 解决方法
- MMC 卡驱动分析
- 中缀表达式转后缀表达式C++代码
- 测试方案内容
- 如何加快建 index 索引 的时间
- php随记
- 分区表 之 Interval分区 和 虚拟列 按星期分区表
- java之public class和class声明区别详解
- 专业开发: StyleCop使用 - C#