ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 2476)
来源:互联网 发布:使人变老的软件 编辑:程序博客网 时间:2024/05/21 10:48
Symptoms
Following error is reported while trying to shutdown ASM:
ORA-15097: cannot SHUTDOWN ASM instance with connected client
srvctl stop asm -n enode1 -f
PRCR-1014 : Failed to stop resource ora.asm
PRCR-1065 : Failed to stop resource ora.asm
CRS-2673: Attempting to stop 'ora.asm' on 'enode1'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 'enode1' failed
CRS-2675: Stop of 'ora.asm' on 'enode1' failed
Verified there is no instance up and running on local node except ASM itself:
ps -ef|grep pmon
oracle 3913 1 0 22:45 ? 00:00:00 asm_pmon_+ASM1
Cause
The OCR is located on ASM and CRSD is client of ASM thus ASM can't be shutdown
Solution
To shutdown ASM, CRS need to be shutdown: crsctl stop crs --root用户
ATTENTION: Never kill the ASM instance!(这样CRS 也会被挂掉。)
Following error is reported while trying to shutdown ASM:
ORA-15097: cannot SHUTDOWN ASM instance with connected client
srvctl stop asm -n enode1 -f
PRCR-1014 : Failed to stop resource ora.asm
PRCR-1065 : Failed to stop resource ora.asm
CRS-2673: Attempting to stop 'ora.asm' on 'enode1'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 'enode1' failed
CRS-2675: Stop of 'ora.asm' on 'enode1' failed
Verified there is no instance up and running on local node except ASM itself:
ps -ef|grep pmon
oracle 3913 1 0 22:45 ? 00:00:00 asm_pmon_+ASM1
Cause
The OCR is located on ASM and CRSD is client of ASM thus ASM can't be shutdown
Solution
To shutdown ASM, CRS need to be shutdown: crsctl stop crs --root用户
ATTENTION: Never kill the ASM instance!(这样CRS 也会被挂掉。)
- ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 2476)
- ORA-15097: cannot SHUTDOWN ASM instance with connected client
- ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 16359)
- ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges 处理方法
- ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges
- ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges 处
- rac11g错误:ORA-15097: cannot SHUTDOWN ASM instance with connected client
- oracle 10.2.0.1 ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
- 解决ORA-15097 Cannot shutdown ASM if OCR is Located in ASM
- ORA-15064: communication failure with ASM instance
- ASM INSTANCE CRASHES FREQUENTLY WITH ORA-15082 in 11g [ID 1056695.1]
- ORA-29786: SIHA attribute GET failed with Error If 11gR2 ASM instance is created manually
- Connected to an idle instance. ORA-01034: ORACLE not available
- ora-01033 ORA-01033:ORACLE initialization or shutdown in process
- ORA-29786: SIHA attribute GET failed with Error If 11gR2 ASM instance is created manually [ID 976075
- 【翻译自mos文章】Oracle Cluster failed to start with ASM instance getting ORA-00443 ---改动/etc/resolv.conf所致
- ora-019401 cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected
- [Oracle] 事务隔离级别(Oracle的实现方式)
- CSDN的类别管理模块的“类别排序”功能好垃圾!!!
- PHP 判断远程图片文件是否存在
- XP系统优化
- SQLServerException: The statement did not return a result set
- ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 2476)
- mysql中创建视图、索引
- hdu 4223 Dynamic Programming?
- Android 利用PhoneStatelistener 判断网络是否连接
- 现在我算不算会了String的compareTo方法
- mootools学习笔记(四)页面元素的控制Element篇(1)
- 什么是转发等价类(FEC, Forwarding Equivalence Class)
- C#编程中常用统计学公式
- Web开发者不容错过的20段CSS代码之一