신문지한장

[DBT-05802] Creating password file on diskgroup (DATA) 본문

Oracle/Error Messages

[DBT-05802] Creating password file on diskgroup (DATA)

신문지한장 2024. 5. 9. 14:08

OS : CentOS7

DB : Oracle Database 11.2.0.1

 

[FATAL] [DBT-05802] Creating password file on diskgroup (DATA) would fail since it requires compatible.asm of version (12.1.0.0.0) or higher. Current compatible.asm version is '11.2.0.2.0'.   ACTION: Choose a diskgroup with correct value for compatible.asm attribute.

 

원인 : ASM 호환성 문제

 

해결방법 : 호환성 맞춤

  • 맞추기 전 확인
select group_number, name, compatibility, database_compatibility from v$asm_diskgroup; 

1 OCR_VOTE             19.0.0.0.0 10.1.0.0.0
2 DATA                 11.2.0.2.0 10.1.0.0.0

 

  • 호환성 맞추는 쿼리
ASMCMD [+DATA] > setattr -G   asmcmd setattr -G DATA compatible.asm 19.0.0.0.0Example: ASMCMD [+DATA] > setattr -G OCR_VOTE compatible.asm 12.1.0.2.0
[grid@node01 ~]$ asmcmd setattr -G DATA compatible.asm 19.0.0.0.0

 

  • 확인
select group_number, name, compatibility, database_compatibility from v$asm_diskgroup; 

1 OCR_VOTE             19.0.0.0.0 10.1.0.0.0
2 DATA                 19.0.0.0.0 10.1.0.0.0