ORA-15000: command disallowed by current instance type

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 12.1.0.2

에러 : ORA-15000: command disallowed by current instance type

ASM 디스크 추가 도중 에러 발생

1 2 3 4 5 6

$ sqlplus / as sysdba SQL> ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM03' REBALANCE POWER 5; ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM03' REBALANCE POWER 5 * ERROR at line 1: ORA-15000: command disallowed by current instance type

해결 방법 : SID를 ASM용으로 맞추고 sysasm으로 접속해서 작업한다.

oracle sid와 oracle home을 asm용으로 맞추고 재시도

$ ps -ef | grep pmon
oracle   20840     1  0 10:59 ?        00:00:00 asm_pmon_+ASM1
oracle   21281     1  0 11:00 ?        00:00:00 ora_pmon_racdb1
$ export ORACLE_SID=+ASM1
$ export ORACLE_HOME=$GRID_HOME;
$ sqlplus / as sysdba
SQL> ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM03' REBALANCE POWER 5;
ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM03' REBALANCE POWER 5
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

에러가 발생했지만 처음과는 다른에러임

sqlplus 접속을 sysasm으로 접속

$ sqlplus / as sysasm
+ASM1> ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM03' REBALANCE POWER 5;
 
Diskgroup altered.

정상 수행됨

추가된 ASM disk 내용 확인

+ASM1> 
SET LINE 200
COL DISK_GROUP FOR A10
COL LABEL FOR A10
COL STATE FOR A10
SELECT A.NAME AS DISK_GROUP, D.NAME "LABEL", A.STATE
FROM V$ASM_DISK D, V$ASM_DISKGROUP A
WHERE D.GROUP_NUMBER=A.GROUP_NUMBER
ORDER BY 2;
 
DISK_GROUP LABEL      STATE
---------- ---------- ----------
ORADATA    ASM01      MOUNTED
ORADATA    ASM02      MOUNTED
ORADATA    ASM03      MOUNTED
ORAFRA       FRA01      MOUNTED
OCR_VOTE   OCR_VOTE01 MOUNTED
OCR_VOTE   OCR_VOTE02 MOUNTED
OCR_VOTE   OCR_VOTE03 MOUNTED

원인 : ASM 작업은 ASM계정과 ASM SID를 맞춰놓고 해야함

참조 :