shutdown immediate关不了
来源:互联网 发布:米尔游 知乎 编辑:程序博客网 时间:2024/04/27 18:11
SQL> shutdown immediate
。。。。。一直等待
警报日志:
[oracle@liumujing trace]$ more alert_bianxueqing.log
Thu Feb 21 16:34:55 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Thu Feb 21 16:34:56 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:36:05 2013
Instance shutdown cancelled
Shutting down instance (immediate)
Shutting down instance: further logons disabled
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:41:23 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:46:33 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:51:40 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:56:49 2013
SHUTDOWN: Active processes prevent shutdown operation
从中可看出每隔5分钟出现一条
SHUTDOWN: Active processes prevent shutdown operation
模拟情境如下:
打开两个sqlplus 并以sys身份连接上去
以sqlplus1、sqlplus2表示
sqlplus2内容:
[oracle@liumujing ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 17:06:12 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> host
[oracle@liumujing ~]$
sqlplus1内容:
SQL> shutdown immediate
---- 一直在等待,shutdown immediate被hang住
解决方法:
sqlplus2退出sys连接
[oracle@liumujing ~]$ exit
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@liumujing ~]$
sqlplus1:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
- shutdown immediate关不了
- linux shutdown关不了机
- shutdown immediate
- oracle shutdown immediate
- shutdown immediate 时间很久解决方法
- shutdown immediate一直停在那里
- 关不了机??!!
- 电脑关不了机
- Shutdown Immediate Hangs: Common Causes [ID 106474.1]
- Oracle shutdown immediate hang住 现象分析
- ORA-01089 immediate shutdown in progress
- fishcat论 高效的shutdown immediate
- shutdown normal、transactional、immediate关闭启动
- Oracle shutdown immediate无法关闭数据库解决方法
- shutdown的normal、transactional、immediate、abort
- Oracle shutdown immediate无法关闭数据库解决方法
- Oracle shutdown immediate无法关闭数据库解决方法
- shutdown immediate 超60mins 无法关闭
- 点云匹配介绍
- sqlserver 查询通配符
- 初学Android_方法总结(三)
- 2013中国手机的春天在哪里?
- i2c controller on intel platform
- shutdown immediate关不了
- hdu 1203 I NEED A OFFER!(简单01背包)
- jquery高仿2012淘宝商城多格子焦点图滚动切换
- 正确理解ThreadLocal
- Linux的I2C 设备驱动 -- mini2440 上i2c接口触摸屏驱动
- Oracle 监听动态注册和静态注册
- 从无到有构建红黑树
- Action methods vs. normal methods
- 大数据分析的5个方面