ORA-15032: not all alterations performed

2023-10-14 18:10
文章标签 ora alterations 15032 performed

本文主要是介绍ORA-15032: not all alterations performed，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

好久没有写oracle了

其实单单看标题，大家能看出什么问题？

SQL> /NAME			       STATE	     TOTAL_MB	 FREE_MB
------------------------------ ----------- ---------- ----------
DGCRS			       MOUNTED		15360	   14188
DGHPP65DATA02		       MOUNTED	     63488000	 8983424
DGHPP65REDO02		       MOUNTED	       614400	  539648
DGIBMV7DATA01		       MOUNTED	    110592000	10571712
DGIBMV7REDO01		       MOUNTED	       614400	  539648
DGHPP65TDATA03		       DISMOUNTED	    0	       06 rows selected.SQL> alter diskgroup DGHPP65TDATA03 mount;
alter diskgroup DGHPP65TDATA03 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group


问题原因是sqlplus / as sysdba 没得权限操作asm


所以sqlplus / as sysasm

[grid@IBM-PC-Server-1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Wed May 24 17:01:15 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> alter diskgroup DGHPP65TDATA03 mount;Diskgroup altered.SQL> 
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;NAME			       STATE	     TOTAL_MB	 FREE_MB
------------------------------ ----------- ---------- ----------
DGCRS			       MOUNTED		15360	   14188
DGHPP65DATA02		       MOUNTED	     63488000	 8983296
DGHPP65REDO02		       MOUNTED	       614400	  539648
DGIBMV7DATA01		       MOUNTED	    110592000	10559680
DGIBMV7REDO01		       MOUNTED	       614400	  539648
DGHPP65TDATA03		       MOUNTED	     83968000	838133116 rows selected.


该问题是节点1 出了故障，硬件故障。所以down机





但是今天现场说恢复了，叫我们看下。

       吐槽一下： 数据库多还稳定，主要是硬件环境不稳定，所以还是需要一个运维dba做支撑。




一看没有使用裸设备，并且属组不对。





于是chmod +chown

[root@IBM-PC-Server-1 dev]# chown grid:asmadmin  /dev/mapper/mpath*
[root@IBM-PC-Server-1 dev]# ls -l  /dev/mapper/mpath*
brw-rw---- 1 grid asmadmin 253,  16 May 24 16:44 /dev/mapper/mpath0
brw-rw---- 1 grid asmadmin 253,  17 May 22 17:03 /dev/mapper/mpath1
brw-rw---- 1 grid asmadmin 253,  26 May 22 17:03 /dev/mapper/mpath10
brw-rw---- 1 grid asmadmin 253, 122 May 22 17:03 /dev/mapper/mpath100
brw-rw---- 1 grid asmadmin 253, 123 May 22 17:03 /dev/mapper/mpath101
brw-rw---- 1 grid asmadmin 253, 124 May 22 17:03 /dev/mapper/mpath102
brw-rw---- 1 grid asmadmin 253, 125 May 22 17:03 /dev/mapper/mpath103
brw-rw---- 1 grid asmadmin 253, 126 May 22 17:03 /dev/mapper/mpath104
brw-rw---- 1 grid asmadmin 253, 127 May 22 17:03 /dev/mapper/mpath105
brw-rw---- 1 grid asmadmin 253, 128 May 22 17:03 /dev/mapper/mpath106
brw-rw---- 1 grid asmadmin 253, 129 May 22 17:03 /dev/mapper/mpath107
brw-rw---- 1 grid asmadmin 253, 130 May 22 17:03 /dev/mapper/mpath108
brw-rw---- 1 grid asmadmin 253, 131 May 22 17:03 /dev/mapper/mpath109
brw-rw---- 1 grid asmadmin 253,  27 May 22 17:03 /dev/mapper/mpath11
brw-rw---- 1 grid asmadmin 253, 132 May 22 17:03 /dev/mapper/mpath110
brw-rw---- 1 grid asmadmin 253, 133 May 22 17:03 /dev/mapper/mpath111
brw-rw---- 1 grid asmadmin 253, 134 May 22 17:03 /dev/mapper/mpath112
brw-rw---- 1 grid asmadmin 253,  94 May 22 17:03 /dev/mapper/mpath113
brw-rw---- 1 grid asmadmin 253,  95 May 22 17:03 /dev/mapper/mpath114
brw-rw---- 1 grid asmadmin 253,  96 May 22 17:03 /dev/mapper/mpath115
brw-rw---- 1 grid asmadmin 253,  97 May 22 17:03 /dev/mapper/mpath116
brw-rw---- 1 grid asmadmin 253,  98 May 22 17:03 /dev/mapper/mpath117
brw-rw---- 1 grid asmadmin 253,  99 May 22 17:03 /dev/mapper/mpath118
brw-rw---- 1 grid asmadmin 253, 100 May 22 17:03 /dev/mapper/mpath119
brw-rw---- 1 grid asmadmin 253,  28 May 22 17:03 /dev/mapper/mpath12
brw-rw---- 1 grid asmadmin 253, 101 May 22 17:03 /dev/mapper/mpath120
brw-rw---- 1 grid asmadmin 253, 102 May 22 17:03 /dev/mapper/mpath121
brw-rw---- 1 grid asmadmin 253, 103 May 22 17:03 /dev/mapper/mpath122
brw-rw---- 1 grid asmadmin 253, 104 May 22 17:03 /dev/mapper/mpath123
brw-rw---- 1 grid asmadmin 253, 105 May 22 17:03 /dev/mapper/mpath124
brw-rw---- 1 grid asmadmin 253, 106 May 22 17:03 /dev/mapper/mpath125
brw-rw---- 1 grid asmadmin 253, 107 May 22 17:03 /dev/mapper/mpath126
brw-rw---- 1 grid asmadmin 253, 108 May 22 17:03 /dev/mapper/mpath127
brw-rw---- 1 grid asmadmin 253, 109 May 22 17:03 /dev/mapper/mpath128
brw-rw---- 1 grid asmadmin 253, 110 May 22 17:03 /dev/mapper/mpath129
brw-rw---- 1 grid asmadmin 253,  29 May 22 17:03 /dev/mapper/mpath13
brw-rw---- 1 grid asmadmin 253, 111 May 22 17:03 /dev/mapper/mpath130
brw-rw---- 1 grid asmadmin 253, 112 May 22 17:03 /dev/mapper/mpath131
brw-rw---- 1 grid asmadmin 253, 113 May 22 17:03 /dev/mapper/mpath132
brw-rw---- 1 grid asmadmin 253, 114 May 22 17:03 /dev/mapper/mpath133
brw-rw---- 1 grid asmadmin 253, 115 May 22 17:03 /dev/mapper/mpath134
brw-rw---- 1 grid asmadmin 253, 116 May 22 17:03 /dev/mapper/mpath135
brw-rw---- 1 grid asmadmin 253,  31 May 22 17:03 /dev/mapper/mpath14
brw-rw---- 1 grid asmadmin 253,  32 May 22 17:03 /dev/mapper/mpath15
brw-rw---- 1 grid asmadmin 253,  33 May 22 18:00 /dev/mapper/mpath16
brw-rw---- 1 grid asmadmin 253,  34 May 22 17:03 /dev/mapper/mpath17
brw-rw---- 1 grid asmadmin 253,  35 May 22 17:03 /dev/mapper/mpath18
brw-rw---- 1 grid asmadmin 253,  36 May 22 17:03 /dev/mapper/mpath19
brw-rw---- 1 grid asmadmin 253,  18 May 22 17:03 /dev/mapper/mpath2
brw-rw---- 1 grid asmadmin 253,  37 May 22 17:03 /dev/mapper/mpath20
brw-rw---- 1 grid asmadmin 253,  38 May 22 17:03 /dev/mapper/mpath21
brw-rw---- 1 grid asmadmin 253,  39 May 22 17:03 /dev/mapper/mpath22
brw-rw---- 1 grid asmadmin 253,  40 May 22 17:03 /dev/mapper/mpath23
brw-rw---- 1 grid asmadmin 253,  41 May 22 17:03 /dev/mapper/mpath24
brw-rw---- 1 grid asmadmin 253,  42 May 22 17:03 /dev/mapper/mpath25
brw-rw---- 1 grid asmadmin 253,  43 May 22 18:00 /dev/mapper/mpath27
brw-rw---- 1 grid asmadmin 253,  45 May 22 17:03 /dev/mapper/mpath28
brw-rw---- 1 grid asmadmin 253,  46 May 22 17:03 /dev/mapper/mpath29
brw-rw---- 1 grid asmadmin 253,  19 May 22 17:03 /dev/mapper/mpath3
brw-rw---- 1 grid asmadmin 253,  47 May 24 16:44 /dev/mapper/mpath30
brw-rw---- 1 grid asmadmin 253,  48 May 24 16:44 /dev/mapper/mpath31
brw-rw---- 1 grid asmadmin 253,  49 May 24 16:44 /dev/mapper/mpath32
brw-rw---- 1 grid asmadmin 253,  50 May 22 18:00 /dev/mapper/mpath33
brw-rw---- 1 grid asmadmin 253,  30 May 22 17:03 /dev/mapper/mpath34
brw-rw---- 1 grid asmadmin 253,  44 May 22 17:03 /dev/mapper/mpath35
brw-rw---- 1 grid asmadmin 253,  51 May 22 17:03 /dev/mapper/mpath36
brw-rw---- 1 grid asmadmin 253,  52 May 22 17:03 /dev/mapper/mpath37
brw-rw---- 1 grid asmadmin 253,  53 May 22 17:03 /dev/mapper/mpath38
brw-rw---- 1 grid asmadmin 253,  54 May 22 17:03 /dev/mapper/mpath39
brw-rw---- 1 grid asmadmin 253,  20 May 22 17:03 /dev/mapper/mpath4
brw-rw---- 1 grid asmadmin 253,  55 May 22 17:03 /dev/mapper/mpath40
brw-rw---- 1 grid asmadmin 253,  56 May 22 17:03 /dev/mapper/mpath41
brw-rw---- 1 grid asmadmin 253,  57 May 22 17:03 /dev/mapper/mpath42
brw-rw---- 1 grid asmadmin 253,   1 May 22 17:03 /dev/mapper/mpath43
brw-rw---- 1 grid asmadmin 253,   3 May 22 17:03 /dev/mapper/mpath44
brw-rw---- 1 grid asmadmin 253,   5 May 22 17:03 /dev/mapper/mpath45
brw-rw---- 1 grid asmadmin 253,   6 May 22 17:03 /dev/mapper/mpath46
brw-rw---- 1 grid asmadmin 253,   8 May 22 17:03 /dev/mapper/mpath47
brw-rw---- 1 grid asmadmin 253,  10 May 22 17:03 /dev/mapper/mpath48
brw-rw---- 1 grid asmadmin 253,  11 May 22 17:03 /dev/mapper/mpath49
brw-rw---- 1 grid asmadmin 253,  21 May 22 17:03 /dev/mapper/mpath5
brw-rw---- 1 grid asmadmin 253,   0 May 22 17:03 /dev/mapper/mpath50
brw-rw---- 1 grid asmadmin 253,   2 May 22 17:07 /dev/mapper/mpath51
brw-rw---- 1 grid asmadmin 253,   4 May 22 17:03 /dev/mapper/mpath52
brw-rw---- 1 grid asmadmin 253,   7 May 22 17:03 /dev/mapper/mpath53
brw-rw---- 1 grid asmadmin 253,   9 May 22 17:03 /dev/mapper/mpath54
brw-rw---- 1 grid asmadmin 253,  12 May 22 17:03 /dev/mapper/mpath55
brw-rw---- 1 grid asmadmin 253,  13 May 22 17:03 /dev/mapper/mpath56
brw-rw---- 1 grid asmadmin 253,  14 May 22 17:03 /dev/mapper/mpath57
brw-rw---- 1 grid asmadmin 253,  15 May 22 17:03 /dev/mapper/mpath58
brw-rw---- 1 grid asmadmin 253,  58 May 24 16:44 /dev/mapper/mpath59
brw-rw---- 1 grid asmadmin 253,  22 May 22 17:03 /dev/mapper/mpath6
brw-rw---- 1 grid asmadmin 253,  59 May 22 17:03 /dev/mapper/mpath60
brw-rw---- 1 grid asmadmin 253,  60 May 24 16:44 /dev/mapper/mpath61
brw-rw---- 1 grid asmadmin 253,  61 May 22 18:00 /dev/mapper/mpath62
brw-rw---- 1 grid asmadmin 253,  62 May 24 16:44 /dev/mapper/mpath63
brw-rw---- 1 grid asmadmin 253,  63 May 22 17:03 /dev/mapper/mpath64
brw-rw---- 1 grid asmadmin 253,  64 May 22 18:00 /dev/mapper/mpath65
brw-rw---- 1 grid asmadmin 253,  65 May 22 17:03 /dev/mapper/mpath66
brw-rw---- 1 grid asmadmin 253,  66 May 22 17:03 /dev/mapper/mpath67
brw-rw---- 1 grid asmadmin 253,  67 May 22 17:03 /dev/mapper/mpath68
brw-rw---- 1 grid asmadmin 253,  68 May 22 17:03 /dev/mapper/mpath69
brw-rw---- 1 grid asmadmin 253,  23 May 22 17:03 /dev/mapper/mpath7
brw-rw---- 1 grid asmadmin 253,  69 May 22 17:07 /dev/mapper/mpath70
brw-rw---- 1 grid asmadmin 253,  70 May 22 17:03 /dev/mapper/mpath71
brw-rw---- 1 grid asmadmin 253,  71 May 22 17:03 /dev/mapper/mpath72
brw-rw---- 1 grid asmadmin 253,  72 May 22 17:03 /dev/mapper/mpath73
brw-rw---- 1 grid asmadmin 253,  73 May 22 17:03 /dev/mapper/mpath74
brw-rw---- 1 grid asmadmin 253,  74 May 22 17:03 /dev/mapper/mpath75
brw-rw---- 1 grid asmadmin 253,  75 May 22 17:03 /dev/mapper/mpath76
brw-rw---- 1 grid asmadmin 253,  76 May 22 17:03 /dev/mapper/mpath77
brw-rw---- 1 grid asmadmin 253,  77 May 22 17:03 /dev/mapper/mpath78
brw-rw---- 1 grid asmadmin 253,  78 May 22 17:03 /dev/mapper/mpath79
brw-rw---- 1 grid asmadmin 253,  24 May 22 17:03 /dev/mapper/mpath8
brw-rw---- 1 grid asmadmin 253,  79 May 22 18:00 /dev/mapper/mpath80
brw-rw---- 1 grid asmadmin 253,  80 May 22 17:03 /dev/mapper/mpath81
brw-rw---- 1 grid asmadmin 253,  81 May 22 17:03 /dev/mapper/mpath82
brw-rw---- 1 grid asmadmin 253,  82 May 22 17:03 /dev/mapper/mpath83
brw-rw---- 1 grid asmadmin 253,  83 May 22 17:03 /dev/mapper/mpath84
brw-rw---- 1 grid asmadmin 253,  84 May 22 17:03 /dev/mapper/mpath85
brw-rw---- 1 grid asmadmin 253,  85 May 22 17:03 /dev/mapper/mpath86
brw-rw---- 1 grid asmadmin 253,  86 May 22 17:03 /dev/mapper/mpath87
brw-rw---- 1 grid asmadmin 253,  87 May 22 17:03 /dev/mapper/mpath88
brw-rw---- 1 grid asmadmin 253,  88 May 22 17:03 /dev/mapper/mpath89
brw-rw---- 1 grid asmadmin 253,  25 May 22 17:03 /dev/mapper/mpath9
brw-rw---- 1 grid asmadmin 253,  89 May 22 17:03 /dev/mapper/mpath90
brw-rw---- 1 grid asmadmin 253,  90 May 22 17:03 /dev/mapper/mpath91
brw-rw---- 1 grid asmadmin 253,  91 May 22 17:03 /dev/mapper/mpath92
brw-rw---- 1 grid asmadmin 253,  92 May 22 17:03 /dev/mapper/mpath93
brw-rw---- 1 grid asmadmin 253,  93 May 22 17:03 /dev/mapper/mpath94
brw-rw---- 1 grid asmadmin 253, 117 May 22 17:03 /dev/mapper/mpath95
brw-rw---- 1 grid asmadmin 253, 118 May 22 17:03 /dev/mapper/mpath96
brw-rw---- 1 grid asmadmin 253, 119 May 22 17:03 /dev/mapper/mpath97
brw-rw---- 1 grid asmadmin 253, 120 May 22 17:03 /dev/mapper/mpath98
brw-rw---- 1 grid asmadmin 253, 121 May 22 17:03 /dev/mapper/mpath99


然后查看状态 4个online （心里暗喜）偷笑




这不是要收工的节奏么？

马上查看下实例，会不会自动也拉起了呢？ 结果是节点1实例仍然没有启动。




这里我的想法是把grid搞定后，再看实例（反而此时，我想他报错，因为这个时候报错的几率不大， 如果报错，说明又可以学习点新东西）

SQL> /NAME			       STATE	     TOTAL_MB	 FREE_MB
------------------------------ ----------- ---------- ----------
DGCRS			       MOUNTED		15360	   14188
DGHPP65DATA02		       MOUNTED	     63488000	 8983424
DGHPP65REDO02		       MOUNTED	       614400	  539648
DGIBMV7DATA01		       MOUNTED	    110592000	10571712
DGIBMV7REDO01		       MOUNTED	       614400	  539648
DGHPP65TDATA03		       DISMOUNTED	    0	       06 rows selected.SQL> alter diskgroup DGHPP65TDATA03 mount;
alter diskgroup DGHPP65TDATA03 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group



NND 看嘛，果然有个磁盘没有mount，结果手动alter，报权限不足。

心想难道又要折磨我？

结果才想起是sysdba角色，所以要切换到sysasm

[grid@IBM-PC-Server-1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Wed May 24 17:01:15 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> alter diskgroup DGHPP65TDATA03 mount;Diskgroup altered.SQL> 
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;NAME			       STATE	     TOTAL_MB	 FREE_MB
------------------------------ ----------- ---------- ----------
DGCRS			       MOUNTED		15360	   14188
DGHPP65DATA02		       MOUNTED	     63488000	 8983296
DGHPP65REDO02		       MOUNTED	       614400	  539648
DGIBMV7DATA01		       MOUNTED	    110592000	10559680
DGIBMV7REDO01		       MOUNTED	       614400	  539648
DGHPP65TDATA03		       MOUNTED	     83968000	838133116 rows selected.SQL> exit
启动成功。



看下实例，如下图




嗯，问题不大。



正常了！！





然后高兴去交差






那么第二个问题来了，看图




因为我对应用也不是很了解，只能一个awr看问题。 结果吓尿了！！！  DB_time 7379  




客户把我们当智能系统了，在压力测试、。 详单   1000W/小时

查询了30+24=54天， 54*24*60*1000w= 777,600,000,000  条记录 。




在来看io等待





结果给现场项目经理吐槽了一下。大笑





这篇关于ORA-15032: not all alterations performed的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/212249。

相关文章

ora-01017 ora-02063 database link，oracle11.2g通过dblink连接oracle11.2g

ora-01017 ora-02063 database link，oracle11.2g通过dblink连接oracle11.2g

错误图示： 问题解决 All database links, whether public or private, need username/password of the remote/target database. Public db links are accessible by all accounts on the local database, while private
阅读更多...
ORA-25150:不允许对区参数执行ALTERING

ORA-25150:不允许对区参数执行ALTERING

在用PL/SQL工具修改表存储报错： 百度一下找到原因： 表空间使用本地管理，其中的表不能修改NEXT MAXEXTENTS和PCTINCREASE参数 使用数据自动管理的表空间，其中的表可以修改NEXT MAXEXTENTS和PCTINCREASE参数
阅读更多...
ORA-01861:文字与格式字符串不匹配

ORA-01861:文字与格式字符串不匹配

select t.*, t.rowid from log_jk_dtl t; insert into log_jk_dtl (rq,zy,kssj,jssj,memo)  values (to_date(sysdate,'yyyy-mm-dd'),'插入供应商', to_char(sysdate,'hh24:mi:ss'),to_char(sysdate,'hh24:mi:ss'),'备注'
阅读更多...
利用PL/SQL工具连接Oracle数据库的时候，报错：ORA-12638: 身份证明检索失败的解决办法

利用PL/SQL工具连接Oracle数据库的时候，报错：ORA-12638: 身份证明检索失败的解决办法

找到相对应的安装目录：比如：E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN 在里面找到：SQLNET.AUTHENTICATION_SERVICES= (NTS) 将其更改为：SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE) 或者注释掉：#SQLNET.AUTHENTICATION_SERVICES= (N
阅读更多...
ORA-00600 [1880]

ORA-00600 [1880]

-----环境信息 [oracle@trsen02 bdump]$ uname -a Linux trsen02.yto.com 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux SQL> select * from v$version; BANNER ----
阅读更多...
ORA-31626/ORA-31638/ORA-39077/ORA-6502

ORA-31626/ORA-31638/ORA-39077/ORA-6502

导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502 报错信息如下： [oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.log Export: Release 11.2.0.3.0 - Production on Sun Sep
阅读更多...
ORA-00600 [504]

ORA-00600 [504]

ALERT日志： Wed Sep 10 09:00:53 2014 Errors in file /u01/app/oracle/diag/rdbms/trsendb/trsendb2/trace/trsendb2_ora_40371414.trc  (incident=821340): ORA-00600: internal error code, arguments: [504],
阅读更多...
【oracle sql错误】ORA-01795: 列表中的最大表达式数为 1000

【oracle sql错误】ORA-01795: 列表中的最大表达式数为 1000

select SOURCE_ID,FILTER_TEXT from TEXT_CENTER where SOURCE_ID in() in后面的括号里的数目超过1000条。 问题描述: SQL进行IN查询时，IN中的数据量不能超过1000条。 解决办法： 拆分：id in (1,2,3,4,5,,,,999) or id in(1000,1001,1002,1003,1004,,,,,,
阅读更多...
Oracl查询报错：ORA-29275: 部分多字节字符

Oracl查询报错：ORA-29275: 部分多字节字符

报错描述 --使用oracl的sql查询时候，此sql无误：SELECT DISTINCT MS_BRDA.MZHM as patientId,MS_BRDA.BRXM as name,CASEWHEN MS_BRDA.BRXB = 1 THEN '男'WHEN MS_BRDA.BRXB = 2 THEN '女'ELSE '未知'END
阅读更多...
ORA-24067: exceeded maximum number of subscribers for queue ADMIN.SMS_MT_QUEUE

ORA-24067: exceeded maximum number of subscribers for queue ADMIN.SMS_MT_QUEUE

临时处理办法： delete from aq$_ss_MT_tab_D;delete from aq$_ss_MT_tab_g;delete from aq$_ss_MT_tab_h;delete from aq$_ss_MT_tab_i;delete from aq$_ss_MT_tab_p;delete from aq$_ss_MT_tab_s;delete from aq$
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2