ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges 处
来源:互联网 发布:php编写网站头部底部 编辑:程序博客网 时间:2024/05/23 20:29
[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 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
+ASM1 STARTED
SQL> shutdown
ORA-15097: cannot SHUTDOWN ASM instance with connected client
[grid@racnode1 ~]$ srvctl stop asm -n racnode1 -f
PRCR-1014 : 无法停止资源 ora.asmPRCR-1065 : 无法停止资源 ora.asm
CRS-2675: 未能停止 'ora.RACDB_DATA.dg' (在 'racnode1' 上)
CRS-2675: 未能停止 'ora.FRA.dg' (在 'racnode1' 上)
在oracle 10g 环境下,我们停RAC的顺序是:
(1)数据库
(2)ASM
(3)CRS
但是在Oracle 11gR2下,如果是用OUI来安装的话,除了数据文件之外,OCR 也是放在ASM里的。 11gR2是支持RAW设备的,但是需要手动的安装。
所以这里就遇到了问题。 OCR也是放在ASM里的,这样CRSD 就会成为ASM的客户端。 如果我们像Oracle 10g里那样直接停ASM的时候,就会报上面的错误。 所以,在11gR2下面,要停ASM实例的话,只能和CRS一起停。
root用户下:[root@racnode2 bin]# /u01/app/11.2.0/grid/bin/crsctl stop crs
在关闭ASM实例的时候,还遇到一个问题:
sqlplus / as sysdba
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL>
提示权限不错,如果遇到这种错误,可以用sqlplus / as sysasm方式连接。 这样就有了sysasm的权限。
- 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
- 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 (process 2476)
- 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
- ASM ORA-01031: insufficient privileges
- oracle 11g ASM 的管理用户 asm shutdown immediate ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ora-01031:insufficient privileges
- 机器学习分类
- numpy入门——数组操作
- mysql字符数字组合进行排序
- 用python写网络爬虫-使用xpath代替正则表达式
- Ubuntu 系统在DELL Win10上的安装
- ORA-15097: cannot SHUTDOWN ASM instance with connected client 和 ORA-01031: insufficient privileges 处
- Django配置mysql
- cvRound cvFloor cvCeil
- 周志华《机器学习》笔记:第1章 绪论
- HDU 5036 期望+传递闭包+bitset优化
- SQL中left join、right in、inner join的区别
- c# windows服务 启动外部程序,程序已开启,但看不到界面
- 常用的四种CSS样式表格
- Sprint Boot 打Jar包并启动