- 数据库版本 12c(12.1.0.2)
- ASM 12c以后支持超过2T 的盘
- 记录ORA-15099 问题处理过程:
- ORA-15099：disk '/dev/asm_data' is larger than maximum size of 2097152 MBs
- 查看磁盘的组的rdbms兼容版本
[grid@l01testdb01 ~]$ asmcmd lsattr -G DATA -l
Name Value
access_control.enabled FALSE
access_control.umask 066
au_size 1048576
cell.smart_scan_capable FALSE
compatible.asm 12.1.0.0.0
compatible.rdbms 10.1.0.0.0
content.check FALSE
content.type data
disk_repair_time 3.6h
failgroup_repair_time 24.0h
idp.boundary auto
idp.type dynamic
phys_meta_replicated true
sector_size 512
thin_provisioned FALSE - 修改DISKGROUP rdbms兼容版本
- grid模式下不能已sysdba进入要已sysasm模式进入
- 开始的时候，以为修改为当前数据库版本（12.1.0.2.0），结果提示asm兼容版本是12.1.0.0.0
[grid@l01testdb01 ~]$ asmcmd
ASMCMD> exit
[grid@l01testdb01 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 19 11:15:45 2021Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.2.0';
ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.2.0'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk groupSQL> ALTER DISKGROUP DATA ADD USER 'grid';
ALTER DISKGROUP DATA ADD USER 'grid'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk groupSQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options[grid@l01testdb01 ~]$ sqlplus / as sysasmSQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 19 11:20:28 2021Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management optionsSQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.2.0';
ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.2.0'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.rdbms
ORA-15234: target RDBMS compatibility (12.1.0.2.0) exceeds ASM compatibility
(12.1.0.0.0)SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.0.0';Diskgroup altered.- 查看磁盘组，并修改磁盘大小
SQL> select name, state from v$asm_diskgroup;NAME STATE
------------------------------ -----------
OCR MOUNTED
DATA MOUNTED--查看磁盘组对应的磁盘
SQL> sselect name,disk_number,OS_MB,TOTAL_MB,FREE_MB from v$asm_disk;NAME DISK_NUMBER OS_MB TOTAL_MB FREE_MB
------------------------------ ----------- ---------- ---------- ----------
OCR_0000 0 10245 10245 4558
DATA_0001 1 4194315 2000000 23999916
DATA_0000 0 4194315 2000000 23999917SQL> alter diskgroup DATA resize disk DATA_0000 size 3000000m2 ;Diskgroup altered.SQL> alter diskgroup DATA resize disk DATA_0000 size 4000000m;Diskgroup altered.SQL> alter diskgroup DATA resize disk DATA_0001 size 4000000m;Diskgroup altered.SQL> select name,disk_number,OS_MB,TOTAL_MB,FREE_MB from v$asm_disk;NAME DISK_NUMBER OS_MB TOTAL_MB FREE_MB
------------------------------ ----------- ---------- ---------- ----------
OCR_0000 0 10245 10245 4558
DATA_0001 1 4194315 4000000 3999916
DATA_0000 0 4194315 4000000 3999917参考文档：https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_1007.htm
