일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Tags
- Oracle RAC
- oracle hugepage
- window pscp
- oracle account_status expired
- sqlnet.allowed_logon_version_server=8
- oracle tde
- oracle sqlnet.ora
- ora-28002: the password will expire within 7 days
- oracle system lock
- oracle dba_profile password_life_time
- oracle pdb
- oracleasm
- oracle SCN
- oracle 테스트 데이터
- window에서 linux로 scp 하는 방법
- MSSQL
- oracle install
- oracle
- 오라클
- supplemental log 활성화
- ora-28040: no matching authentication protocol
- window scp
- ORA-00020
- Oracle Database
- SSMS
- sqlnet.allowed_logon_version_client=8
- SQL Server
- oracle awr
- mssql database 삭제
- ora-39083 ora-00439
Archives
- Today
- Total
신문지한장
[DBT-05802] Creating password file on diskgroup (DATA) 본문
Oracle/Error Messages
[DBT-05802] Creating password file on diskgroup (DATA)
신문지한장 2024. 5. 9. 14:08OS : 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
'Oracle > Error Messages' 카테고리의 다른 글
[Error] ORA-27054 (0) | 2024.08.26 |
---|---|
ORA-00700 ORA-48209 ORA-48122 ORA-48126 (0) | 2024.08.26 |
ORA-00020: maximum number of processes (500) exceeded (0) | 2024.05.09 |
SHUTDOWN: Waiting for active calls to complete (0) | 2024.04.29 |
[Error] ORA-65096 : invalid common user or role name (1) | 2024.01.05 |