오라클 ASM 작업 시에 sysdba 로 접속시에 디스크 관련 작업 실패
sqlplus / as sysasm
sysasm계정으로 꼭 접속 해야 작업이 가능하다
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
[+ASM1:/home/oracle]> sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 8 16:38:35 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> /
GROUP_NUMBER DISK_NUMBER NAME MOUNT_STATUS PATH TOTAL_MB FREE_MB
------------ ----------- -------------- --------------------- ------------------------------ ---------- ----------
1 0 CRS_0000 CACHED /dev/oracleasm/disks/CRS1 1020 700
1 1 CRS_0001 CACHED /dev/oracleasm/disks/CRS2 1020 696
1 2 CRS_0002 CACHED /dev/oracleasm/disks/CRS3 1020 696
2 1 DATA2 CACHED /dev/oracleasm/disks/DATA2 50996 47884
2 0 DATA_0000 CACHED /dev/oracleasm/disks/DATA 30716 28820
3 0 FRA_0000 CACHED /dev/oracleasm/disks/FRA 20476 19084
6 rows selected.
SQL> set line 200
SQL> col path for a50
SQL> select group_number, mount_status, path, total_mb
2 from v$asm_disk where mount_status='CLOSED';
.
GROUP_NUMBER MOUNT_STATUS PATH TOTAL_MB
------------ --------------------- -------------------------------------------------- ----------
0 CLOSED /dev/oracleasm/disks/CRS4 0
SQL> COL LABEL FOR A10
SQL> COL STATE FOR A10
SQL> SELECT A.NAME AS DISK_GROUP, D.NAME "LABEL", A.STATE
2 FROM V$ASM_DISK D, V$ASM_DISKGROUP A
3 WHERE D.GROUP_NUMBER=A.GROUP_NUMBER
4 ORDER BY 2;
DISK_GROUP LABEL STATE
------------------------------------------------------------------------------------------ ---------- ----------
CRS CRS_0000 MOUNTED
CRS CRS_0001 MOUNTED
CRS CRS_0002 MOUNTED
DATA DATA2 MOUNTED
DATA DATA_0000 MOUNTED
FRA FRA_0000 MOUNTED
6 rows selected.
SQL> col path for a30
SQL> col name for a14
SQL> select group_number, disk_number, name, mount_status, path, total_mb, free_mb
2 from v$asm_disk
3 order by 1,3;
GROUP_NUMBER DISK_NUMBER NAME MOUNT_STATUS PATH TOTAL_MB FREE_MB
------------ ----------- -------------- --------------------- ------------------------------ ---------- ----------
0 0 CLOSED /dev/oracleasm/disks/CRS4 0 0
1 0 CRS_0000 CACHED /dev/oracleasm/disks/CRS1 1020 700
1 1 CRS_0001 CACHED /dev/oracleasm/disks/CRS2 1020 696
1 2 CRS_0002 CACHED /dev/oracleasm/disks/CRS3 1020 696
2 1 DATA2 CACHED /dev/oracleasm/disks/DATA2 50996 47884
2 0 DATA_0000 CACHED /dev/oracleasm/disks/DATA 30716 28820
3 0 FRA_0000 CACHED /dev/oracleasm/disks/FRA 20476 19084
7 rows selected.
SQL> ALTER DISKGROUP CRS ADD DISK '/dev/oracleasm/disks/CRS4' REBALANCE POWER 5;
ALTER DISKGROUP CRS ADD DISK '/dev/oracleasm/disks/CRS4' REBALANCE POWER 5
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[+ASM1:/home/oracle]> sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 8 17:22:00 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> ALTER DISKGROUP CRS ADD DISK '/dev/oracleasm/disks/CRS4' REBALANCE POWER 5;
Diskgroup altered.
'ORACLE > TroubleShooting' 카테고리의 다른 글
| 오라클 GIPSU rollback 실패 ../crsconfig_params unable to get oracle owner for (0) | 2023.09.20 |
|---|---|
| ORA-65096: invalid common user or role name (0) | 2023.06.08 |
| DBT-05801 오라클 리스타트 설치시에 asm 볼륨이 안보일 때 (0) | 2023.05.25 |
| linux 7버전에 oracle 11g 설치시 'agent nmhs' 관련 에러 발생 (0) | 2022.04.11 |
| 오라클 ora-48913 (0) | 2018.12.31 |
