ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 16359)

最新推荐文章于 2021-04-10 08:11:41 发布
原创 最新推荐文章于 2021-04-10 08:11:41 发布 · 3.1k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了解决在REDHAT5.5环境下使用11GR2+ASM+ISCSI配置时遇到的Oracle ASM实例无法立即关闭的问题。文中提供了两种解决方案：一是通过ASROOT用户执行CRSCTL STOP CRS命令；二是调整GRID用户的CRSCTL命令路径。

平台：REDHAT 5.5+11G R2+ASM+ISCSI

sqlplus "/as sysdba"

SQL> shutdown immediate;

ORA-01031: insufficient privileges

改为:sqlplus "/as sysasm"

然后执行

shutdown immediate


ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 16359)

解决：AS ROOT用户执行CRSCTL STOP CRS（2节点执行）

或者将GRID用户下的CRSCTL用户的目录放在ROOT的PATH变量下执行


launch_225
关注
create controlfile重建控制文件报 ORA-01503 ORA-01565 restore resetlogs cdb 后还可以继续recover pdb
jnrjian的博客
07-01 1857
-----常规方法恢复不了---------------------------------------------online redo的重要性----------resetlogs后不能flashback了， 已经recover pdb 是plug上去的------------------------数据文件全部删了试试-----------------------------如果delete obsolete copy 就可以了。------数据文件在的时候新建controlfile。
ASM磁盘组丢失，ORA-15180，ORA-01115，ORA-01110，ORA-15081，ORA-00202，ORA-15081，ORA-15097
ElvisTan
05-09 2362
启动数据库，提示ORA-01115: IO error reading block from file，可能是asm
ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges
David Dai -- Focus on Oracle
12-15 8629
<br /> <br />停RAC的ASM实例的时候报错：<br />ORA-15097: cannot SHUTDOWN ASM instance with connected client<br /><br />srvctl stop asm -n enode1 -f<br />PRCR-1014 : Failed to stop resource ora.asm<br />PRCR-1065 : Failed to stop resource ora.asm<br />CRS-2673: Attemp
ORA-15097: cannot SHUTDOWN ASM instance with connected client
Perry
10-01 1161
ORA-15097: cannot SHUTDOWN ASM instance with connected client  停RAC的ASM实例的时候报错： ORA-15097: cannot SHUTDOWN ASM instance with connected client srvctl stop asm -n enode1 -f PRCR-1014 : Faile
ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges 处
Finder_Way
08-09 536
[grid@racnode1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 9 17:49:58 2017 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 2476)
沉默_Cloud
05-27 1135
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
rac11g错误：ORA-15097: cannot SHUTDOWN ASM instance with connected client
changyanmanman的专栏
10-25 2639
背景：想停rac环境，所以[grid@rac2 bin]$ srvctl stop asm -n rac1PRCR-1014 : Failed to stop resource ora.asmPRCR-1065 : Failed to stop resource ora.asmCRS-2673: Attempting to stop 'ora.asm' on 'rac1'ORA-15097: ca
RMAN> startup nomount; connected to target database (not started) startup failed: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora ORA-15056: additional error message ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-06512: at line 4 starting Oracle instance without parameter file for retrieval of spfile Oracle instance started Total System Global Area 1068937216 bytes Fixed Size 2260088 bytes Variable Size 285213576 bytes Database Buffers 775946240 bytes Redo Buffers 5517312 bytes
10-22
由于你的 SPFILE（服务器参数文件）位于 `+DATA/orcl/spfileorcl.ora`，而该路径属于 ASM 磁盘组 `DATA`，如果这个磁盘组没有被正确挂载，Oracle 就无法读取 SPFILE，导致启动失败。 不过你可以看到最后提示： > *...
oracle 19c ORA-15032: not all alterations performed ORA-15028: ASM file '+data/xlunidg/datafile/XULEITBS.257.1204033621' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
07-02
我们正在处理一个Oracle ASM（自动存储管理）相关的问题，用户遇到了两个错误：ORA-15032和ORA-15028。具体场景是在尝试删除ASM文件时，因为文件正在被访问而无法删除。根据引用[1]和引用[4]：-引用[1]提到在添加ASM...
【Oracle】ORA-01078 ORA-29701 11gR2 ASM单实例重启系统后不能启动
congsuituo5014的博客
12-06 1118
系统环境：Linux Server release 7.3 数据库环境：11.2.0.4.0 [grid@Oraclelinux ~]$sqlplus / as sysasm 启动asm实例出现下...
oracle 10.2.0.1 ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
爱肯的专栏
05-12 1649
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With
oracle 10g asm ora-15097,解决ORA-15097 Cannot shutdown ASM if OCR is Located in ASM
weixin_34668147的博客
04-10 232
环境介绍：数据库版本： oracle 11.2.0.1数据库平台：所有平台[@more@]问题现象：当你试图关闭ASM的时候，报以下错误：ORA-15097: cannot SHUTDOWN ASM instance with connected clientsrvctl stop asm -n enode1 -fPRCR-1014 : Failed to stop resource ora.as...
[转载]----ORA-15097：cannot SHUTDOWN ASM instance with connected client和ORA-01031：insufficient privileg...
weixin_34096182的博客
01-08 142
    停RAC的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 ...
oracle 10g asm ora-15097,维护 - 探索Oracle之ASM_数据库技术_Linux公社-Linux系统门户网站...
weixin_36111033的博客
04-10 346
一、ASM实例相关操作：ASM实例的管理，启动，关闭ASM实例的启动和数据库实例的启动有严格的先后关系，ASM启动一定早于数据库实例，关闭一定晚于ASM实例，因为它是数据库数据文件存储位置。如果ASM没有起来，起数据库将会报ORA-17503；ORA-15077的错误，错误信息如下:SQL>startupORA-01078:failure in processing system par...
ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges
千里足迹
01-15 2548
11g rac  停RAC的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 resou
grid 用户关不掉rac asm
千里足迹
11-18 1329
rac1-> sqlplus  / as sysasm  SQL> shutdown immediate ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 2536) 不能停止的原因，需要停资源，而不是直接关闭 解决： root@rac1 app]# cd /u01/app/11.
oracle 10g asm ora-15097,rac11g错误：ORA-15097: cannot SHUTDOWN ASM instance with connected client...
weixin_33700809的博客
04-10 191
背景：想停rac环境，之前10g都是用crs_stop -all 来停止，所以，这次也这样做的，没想到报了如下错误：[grid@rac2 ~]$ crs_stop -allCRS-2500: Cannot stop resource 'ora.gsd' as it is not runningCRS-2500: Cannot stop resource 'ora.oc4j' as it is no...
解决ORA-15097 Cannot shutdown ASM if OCR is Located in ASM
欧辰的专栏
10-16 1379
环境介绍： 数据库版本： oracle 11.2.0.1 数据库平台：所有平台 [@more@] 问题现象： 当你试图关闭ASM的时候，报以下错误： ORA-15097: cannot SHUTDOWN ASM instance with connected client srvctl stop asm -n enode1 -f PRCR-1014 : Fa
【RAC】关闭Clusterware 遇到CRS-2529,ORA-15097:
cojm55771的博客
09-02 311
需要关闭整个集群，遇到CRS-2529，ORA-15097 错误 ~！grid@rac1:/home/grid/Opatch>srvctl stop asm -n rac1 -o immediate PRCR...
SQL> shutdown immediate; ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01089: immediate shutdown in progress - no operations are permitted
最新发布
11-14
ORA-01089: immediate shutdown in progress - no operations are permitted ``` 表示你正在尝试执行 `SHUTDOWN IMMEDIATE`，但数据库已经处于**关闭过程中**（shutdown in progress），或者你的会话没有正确连接到...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值