OS 환경 : Oracle Linux 9.6 (64bit)
DB 환경 : Oracle Database 19.28.0.0
에러 : [INS-30508] Invalid ASM disks.
Oracle Linux 9에 oracle asmlib3 버전을 사용하여 asmdisk 라벨링 후 grid 설치시 asm diskgroup 생성하는 부분에서 발생한 문제
grid 설치(및 패치)
|
1
|
$ ./gridSetup.sh -applyRU /app/media/37952382/37957391
|
/dev/sda1로 진행하려 했지만 안됨
디스크가 안나오는 문제가 발생하거나 아래 에러가 발생함
디스크가 안나올때는 다시 change path - ok 여러번 해주면 나오는데
그래도 next 하면 [INS-30508] Invalid ASM disks. 발생하면서 안됨
로그 확인
|
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
|
$ tail -300f /tmp/GridSetupActions2025-12-20_10-10-41PM/gridSetupActions2025-12-20_10-10-41PM.log
...
INFO: [Dec 20, 2025 10:55:53 PM] Executing ASMCA
INFO: [Dec 20, 2025 10:55:53 PM] Command /app/grid/product/19c/bin/asmca -silent -oui_internal -configureASM -diskString '/dev/sd*' -diskGroupName DATA1 -diskList /dev/sda1 -redundancy EXTERNAL -au_size 4
INFO: [Dec 20, 2025 10:55:53 PM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Dec 20, 2025 10:55:53 PM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Dec 20, 2025 10:55:53 PM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Dec 20, 2025 10:55:53 PM] ... GenericInternalPlugIn: starting read loop.
INFO: [Dec 20, 2025 10:55:58 PM] SYS_PASSWORD_PROMPT
INFO: [Dec 20, 2025 10:55:58 PM] Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
INFO: [Dec 20, 2025 10:55:58 PM] Skipping line: ^H ^H^H ^H********
INFO: [Dec 20, 2025 10:55:58 PM] ASMSNMP_PASSWORD_PROMPT
INFO: [Dec 20, 2025 10:55:58 PM] Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: [Dec 20, 2025 10:55:58 PM] End of argument passing to stdin
INFO: [Dec 20, 2025 10:55:58 PM] Skipping line: ^H ^H^H ^H******
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line:
INFO: [Dec 20, 2025 10:56:33 PM] [FATAL] [DBT-30002] Disk group DATA1 creation failed.
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line: [FATAL] [DBT-30002] Disk group DATA1 creation failed.
INFO: [Dec 20, 2025 10:56:33 PM] ORA-15018: diskgroup cannot be created
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line: ORA-15018: diskgroup cannot be created
INFO: [Dec 20, 2025 10:56:33 PM] ORA-15031: disk specification '/dev/sda1' matches no disks
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line: ORA-15031: disk specification '/dev/sda1' matches no disks
INFO: [Dec 20, 2025 10:56:33 PM] ORA-15025: could not open disk "/dev/sda1"
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line: ORA-15025: could not open disk "/dev/sda1"
INFO: [Dec 20, 2025 10:56:33 PM] ORA-27041: unable to open file
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line: ORA-27041: unable to open file
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line:
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line:
INFO: [Dec 20, 2025 10:56:33 PM] Skipping line:
INFO: [Dec 20, 2025 10:56:33 PM] Completed Plugin named: asmca
|
diskgroup을 생성하지 못함
해결 방법 : ok버튼 여러번 선택, silent 모드로 설치, 골드 이미지로 설치, diskString을 ORCL:*로 선택
ok버튼 여러번 선택, silent 모드로 설치, 골드 이미지로 설치, diskString을 ORCL:*로 설정 후 진행
방법이 존재함
방법1. silent 모드로 설치
현재 디스크 확인
|
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# oracleasm discover
Using ASMLIB from /opt/oracle/extapi/64/asm/orcl/1/libasm.so
[ASM Library - Linux, version 3.1.1 (KABI_V3), 2025-07-24 22:50]
Discovered disk: ORCL:OCR_VOTE1 [8388608 blocks (4294967296 bytes), blksz 512/512, maxio 1310720 bytes, integrity unsupported]
Discovered disk: ORCL:OCR_VOTE2 [8388608 blocks (4294967296 bytes), blksz 512/512, maxio 1310720 bytes, integrity unsupported]
Discovered disk: ORCL:OCR_VOTE3 [8388608 blocks (4294967296 bytes), blksz 512/512, maxio 1310720 bytes, integrity unsupported]
Discovered disk: ORCL:RECO [62914560 blocks (32212254720 bytes), blksz 512/512, maxio 1310720 bytes, integrity unsupported]
Discovered disk: ORCL:DATA [62914560 blocks (32212254720 bytes), blksz 512/512, maxio 1310720 bytes, integrity unsupported]
$ /app/grid/product/19c/bin/kfod disks=all asm_diskstring='ORCL:*'
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 30720 MB ORCL:DATA
2: 4096 MB ORCL:OCR_VOTE1
3: 4096 MB ORCL:OCR_VOTE2
4: 4096 MB ORCL:OCR_VOTE3
5: 30720 MB ORCL:RECO
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /app/grid/product/19c
$ /app/grid/product/19c/bin/kfod disks=all asm_diskstring='/dev/disk/by-label/*'
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 30720 MB /dev/disk/by-label/DATA oracle dba
2: 4096 MB /dev/disk/by-label/OCR_VOTE1 oracle dba
3: 4096 MB /dev/disk/by-label/OCR_VOTE2 oracle dba
4: 4096 MB /dev/disk/by-label/OCR_VOTE3 oracle dba
5: 30720 MB /dev/disk/by-label/RECO oracle dba
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /app/grid/product/19c
# oracleasm querydisk -i DATA
ORCL:DATA
Device: /dev/sda1 (8:1)
Device UUID: <unknown>
Disk Group: <unknown>
Capabilities: IO | NOGLOBAL
Size: 62914560 blocks (32212254720 bytes)
Logical Block Size: 512 bytes
Physical Block Size: 512 bytes
Max I/O Size: 2560 blocks (1310720 bytes)
Data Integrity: unsupported
Thin Provisioning: unsupported
Max TP I/O Size: 0 blocks (0 bytes)
**UUID 없는것도 vm 환경에선 정상이라고함
|
모두 정상임
silent 모드로 설치
참고 : Oracle Linux 9.6에 Oracle 19c Restart 설치 가이드(silent 포함) ( https://positivemh.tistory.com/1321 )
이후 디스크그룹을 mount 시킨 뒤 db 엔진 설치, db 구성 등 절차 진행하면됨
방법2. asm_diskstring 파라미터 설정
asm 인스턴스에 접속해서 asm_diskstring 파라미터를 설정해주면 정상적으로 디스크 그룹이 생성이됨
asm_diskstring 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
|
$ ps -ef|grep smon
oracle 87314 1567 0 23:12 ? 00:00:00 asm_smon_+ASM
oracle 89477 48935 0 23:24 pts/2 00:00:00 grep --color=auto smon
$ export ORACLE_HOME=$GRID_HOME
$ export ORACLE_SID=+ASM
$ sqlplus / as sysasm
SQL> show parameter asm_diskstring;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string
|
비어있음
ORCL:*로 변경
|
1
2
3
4
5
6
7
8
9
|
SQL> alter system set asm_diskstring='ORCL:*';
System altered.
SQL> show parameter asm_diskstring
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string ORCL:*
|
변경됨
디스크 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SQL>
set lines 200
col path for a45
col header_status for a12
col mode_status for a12
select path, header_status, mode_status, state
from v$asm_disk
order by path;
PATH HEADER_STATU MODE_STATUS STATE
--------------------------------------------- ------------ ------------ --------
ORCL:DATA PROVISIONED ONLINE NORMAL
ORCL:OCR_VOTE1 PROVISIONED ONLINE NORMAL
ORCL:OCR_VOTE2 PROVISIONED ONLINE NORMAL
ORCL:OCR_VOTE3 PROVISIONED ONLINE NORMAL
ORCL:RECO PROVISIONED ONLINE NORMAL
|
PROVISIONED 상태임
asm diskgroup 생성
|
1
2
3
4
5
|
SQL> create diskgroup DATA1 external redundancy
disk 'ORCL:DATA'
attribute 'au_size'='4M';
Diskgroup created.
|
정상적으로 생성됨
확인
|
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
|
SQL>
set lines 200
col name for a10
col state for a10
select name, state, type, total_mb, free_mb
from v$asm_diskgroup;
NAME STATE TYPE TOTAL_MB FREE_MB
---------- ---------- ------ ---------- ----------
DATA1 MOUNTED EXTERN 30720 30632
SQL>
col path for a35
col header_status for a12
select group_number, disk_number, name, path, header_status, state
from v$asm_disk
order by group_number, disk_number;
GROUP_NUMBER DISK_NUMBER NAME PATH HEADER_STATU STATE
------------ ----------- ---------- ----------------------------------- ------------ ----------
0 0 ORCL:RECO PROVISIONED NORMAL
0 1 ORCL:OCR_VOTE3 PROVISIONED NORMAL
0 2 ORCL:OCR_VOTE1 PROVISIONED NORMAL
0 3 ORCL:OCR_VOTE2 PROVISIONED NORMAL
1 0 DATA ORCL:DATA MEMBER NORMAL
|
정상적으로 생성됨
이후 디스크그룹을 mount 시킨 뒤 db 엔진 설치, db 구성 등 절차 진행하면됨
방법3. 골드 이미지로 설치
골드이미지로 설치했을때는 문제가 발생하지 않고 잘 설치되었음
구축한 타 서버에서 골드이미지를 생성해 해당 파일로 설치를 진행할수도 있음
골드 이미지는 아래 게시글 참고
참고 : 오라클 19c grid 골드 이미지 생성 및 배포 가이드 ( https://positivemh.tistory.com/1327 )
참고용
|
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
#restart deconfig 명령
# /app/grid/product/19c/crs/install/roothas.sh -deconfig -force
Using configuration parameter file: /app/grid/product/19c/crs/install/crsconfig_params
The log of current session can be found at:
/app/oracle/crsdata/ora19/crsconfig/hadeconfig.log
2025/12/20 23:31:48 CLSRSC-332: CRS resources for listeners are still configured
PRCR-1001 : Resource ora.asm does not exist
2025/12/20 23:31:50 CLSRSC-180: An error occurred while executing the command '/app/grid/product/19c/bin/srvctl stop asm -force'
Redirecting to /bin/systemctl restart rsyslog.service
2025/12/20 23:32:03 CLSRSC-337: Successfully deconfigured Oracle Restart stack
#재수행을 위해 다시 delete 후 수행 명령
# oracleasm deletedisk -f DATA
# dd if=/dev/zero of=/dev/sda1 bs=1M count=100 oflag=direct status=progress
# sync
# sync
# sync
# oracleasm scandisks
oracleasm listdisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Setting up iofilter map for ASM disks: done
Scanning system for ASM disks...
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
RECO
#다시생성
# oracleasm createdisk DATA /dev/sda1
Writing disk header: done
Instantiating disk:
done
[root@ora19 install]#
[root@ora19 install]# oracleasm listdisks
DATA
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
RECO
#grid도 deinstall
$ cd $GRID_HOME/deinstall/
$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
#
rm -rf /app/grid/product/19c
mkdir -p /app/grid/product/19c
chown oracle:dba -R /app/
$
mkdir -p $GRID_HOME
cd $GRID_HOME
unzip -q /app/media/LINUX.X64_193000_grid_home.zip
mv OPatch OPatchold
unzip -q /app/media/p6880880_190000_Linux-x86-64
cd /app/grid/product/19c/cv/rpm
rpm -ivh cvuqdisk-*.rpm
|
원인 : 리눅스9에 설치시 버그로 판단됨
정확한 원인을 찾을순 없었지만 일반적인 방법이 안되는걸로 봐서 버그인것으로 판단됨
참조 :
Oracle Linux 9.6에 Oracle 19c Restart 설치 가이드(silent 포함) ( https://positivemh.tistory.com/1321 )
오라클 19c grid 골드 이미지 생성 및 배포 가이드 ( https://positivemh.tistory.com/1327 )
Bug 35578393 - Warnings During Oracle Gateway pg4appc after 19c(19.19) install on ol9 (Doc ID 35578393.8)
19c regular client installation on OL9/RHEL9 using Silent method aborted after relink error "Error in invoking target 'client_sharedlib' of makefile '$ORACLE_HOME/rdbms/lib/ins_rdbms.mk'" (Doc ID 3008635.1)
Requirements for Installing Oracle Database/Client 19c (19.22 or higher) on OL9 or RHEL9 64-bit (x86-64) (Doc ID 2982833.1)
19.x: ./runInstaller failed with " PRVF-7532 : Package "compat-libcap1" is missing on node "(HOSTNAME)" " on OL9/RHEL9 (Doc ID 3018358.1)
19c Database Installation/relink fails with :"Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk " (Doc ID 2760289.1)
Primary Note of Linux OS Requirements for Database Server (Doc ID 851598.1)
OL9:ORA-15186: ASMLIB Error Function = [asm_init] [io_uring not permitted for this process] (Doc ID 3108578.1)
ASM and Database Services Not Starting After 19.27 RU Patching (STANDALONE) (Doc ID 3092401.1)
CVU Report PRVE-3155 error (Doc ID 2630514.1)
Wrong DiscoveryString /dev/*: rootupgrade.sh/root.sh hangs (Doc ID 1916106.1)
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/supported-oracle-linux-9-distributions-for-x86-64.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/supported-oracle-linux-9-distributions-for-x86-64.html
https://yum.oracle.com/repo/OracleLinux/OL9/addons/x86_64/index.html
https://www.oracle.com/linux/downloads/linux-asmlib-v9-downloads.html
https://docs.oracle.com/en/operating-systems/oracle-linux/asmlib/
https://dataforum.io/pages/viewpage.action?pageId=5734410
https://dev.to/vahidusefzadeh/installing-oracle-grid-infrastructure-1925-on-oracle-linux-95-using-asmlib-3-4bki
https://blog.purestorage.com/purely-technical/installation-configuration-oracle-asmlib-v3-1-on-oracle-linux-9/
https://positivemh.tistory.com/765
https://positivemh.tistory.com/175
https://positivemh.tistory.com/1321