내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
OS환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.3.0.0
에러 : nothing provides compat-libcap1 needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64
oracle linux 8 버전에 yum install 명령으로 oracle preinstall ol7 버전을 설치할 때 발생하는 에러
1
2
3
4
5
6
7
8
9
10
11
|
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Oracle Linux 8 BaseOS Latest (x86_64) 16 MB/s | 67 MB 00:04
Oracle Linux 8 Application Stream (x86_64) 13 MB/s | 53 MB 00:03
Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64) 17 MB/s | 82 MB 00:04
Last metadata expiration check: 0:00:14 ago on Mon 04 Dec 2023 11:09:23 PM KST.
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 38 kB/s | 18 kB 00:00
Error:
Problem: conflicting requests
- nothing provides compat-libcap1 needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64
- nothing provides compat-libstdc++-33 needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
|
compat-libcap1, compat-libstdc++-33 2가지 패키지가 우선 설치가 필요하다고 나옴
해결 방법 : dnf 커맨드 사용 또는 설치 실패 패키지 2개 수동 설치
방법1. dnf 명령으로 preinstall 수행(권장)
oracle linux 8 버전부터는 dnf 명령을 사용하라고 공식문서에 나와있음
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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
# dnf install oracle-database-preinstall-19c
Oracle Linux 8 BaseOS Latest (x86_64) 18 MB/s | 67 MB 00:03
Oracle Linux 8 Application Stream (x86_64) 16 MB/s | 53 MB 00:03
Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64) 17 MB/s | 82 MB 00:04
Last metadata expiration check: 0:00:12 ago on Mon 04 Dec 2023 11:21:07 PM KST.
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el8 ol8_appstream 31 k
Installing dependencies:
ksh x86_64 20120801-259.0.1.el8 ol8_appstream 923 k
libaio-devel x86_64 0.3.112-1.el8 ol8_baseos_latest 19 k
libnsl x86_64 2.28-151.0.1.el8 ol8_baseos_latest 102 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
sysstat x86_64 11.7.3-11.0.1.el8 ol8_appstream 427 k
Transaction Summary
==============================================================================================================================================================
Install 6 Packages
Total download size: 1.5 M
Installed size: 5.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): libaio-devel-0.3.112-1.el8.x86_64.rpm 48 kB/s | 19 kB 00:00
(2/6): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 120 kB/s | 59 kB 00:00
(3/6): libnsl-2.28-151.0.1.el8.x86_64.rpm 173 kB/s | 102 kB 00:00
(4/6): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm 261 kB/s | 31 kB 00:00
(5/6): sysstat-11.7.3-11.0.1.el8.x86_64.rpm 1.3 MB/s | 427 kB 00:00
(6/6): ksh-20120801-259.0.1.el8.x86_64.rpm 1.5 MB/s | 923 kB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.5 MB/s | 1.5 MB 00:00
warning: /var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/libaio-devel-0.3.112-1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Oracle Linux 8 BaseOS Latest (x86_64) 2.3 MB/s | 3.1 kB 00:00
Importing GPG key 0xAD986DA3:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : ksh-20120801-259.0.1.el8.x86_64 1/6
Running scriptlet: ksh-20120801-259.0.1.el8.x86_64 1/6
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/6
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/6
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Installing : sysstat-11.7.3-11.0.1.el8.x86_64 3/6
Running scriptlet: sysstat-11.7.3-11.0.1.el8.x86_64 3/6
Installing : libnsl-2.28-151.0.1.el8.x86_64 4/6
Installing : libaio-devel-0.3.112-1.el8.x86_64 5/6
Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
Installing : oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 6/6
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Verifying : libaio-devel-0.3.112-1.el8.x86_64 1/6
Verifying : libnsl-2.28-151.0.1.el8.x86_64 2/6
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 3/6
Verifying : ksh-20120801-259.0.1.el8.x86_64 4/6
Verifying : oracle-database-preinstall-19c-1.0-2.el8.x86_64 5/6
Verifying : sysstat-11.7.3-11.0.1.el8.x86_64 6/6
Installed:
ksh-20120801-259.0.1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64 libnsl-2.28-151.0.1.el8.x86_64
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 oracle-database-preinstall-19c-1.0-2.el8.x86_64 sysstat-11.7.3-11.0.1.el8.x86_64
Complete!
|
정상적으로 설치됨
해당 명령이 수행안된다면 ol8용 rpm 수동 다운로드 후 dnf localinstall 진행
1
2
|
# curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
# dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
|
방법2. 수동으로 compat-libcap1, compat-libstdc++-33 설치 후 yum 명령어 재시도
수동 rpm 설치
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
63
64
65
66
67
68
69
70
71
|
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm
Last metadata expiration check: 0:16:26 ago on Mon 04 Dec 2023 11:09:23 PM KST.
compat-libcap1-1.10-7.el7.x86_64.rpm 46 kB/s | 17 kB 00:00
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
compat-libcap1 x86_64 1.10-7.el7 @commandline 17 k
Transaction Summary
==============================================================================================================================================================
Install 1 Package
Total size: 17 k
Installed size: 29 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : compat-libcap1-1.10-7.el7.x86_64 1/1
Running scriptlet: compat-libcap1-1.10-7.el7.x86_64 1/1
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Verifying : compat-libcap1-1.10-7.el7.x86_64 1/1
Installed:
compat-libcap1-1.10-7.el7.x86_64
Complete!
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
Last metadata expiration check: 0:16:33 ago on Mon 04 Dec 2023 11:09:23 PM KST.
compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 246 kB/s | 190 kB 00:00
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
compat-libstdc++-33 x86_64 3.2.3-72.el7 @commandline 190 k
Transaction Summary
==============================================================================================================================================================
Install 1 Package
Total size: 190 k
Installed size: 811 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 1/1
Running scriptlet: compat-libstdc++-33-3.2.3-72.el7.x86_64 1/1
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 1/1
Installed:
compat-libstdc++-33-3.2.3-72.el7.x86_64
Complete!
|
rpm 수동 설치 완료
rpm 설치 완료 후 yum preinstall 재진행
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
63
64
65
66
67
68
|
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Last metadata expiration check: 0:17:26 ago on Mon 04 Dec 2023 11:09:23 PM KST.
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 46 kB/s | 18 kB 00:00
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-1.el7 @commandline 18 k
Installing dependencies:
ksh x86_64 20120801-259.0.1.el8 ol8_appstream 923 k
libaio-devel x86_64 0.3.112-1.el8 ol8_baseos_latest 19 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 ol8_baseos_latest 59 k
sysstat x86_64 11.7.3-11.0.1.el8 ol8_appstream 427 k
Transaction Summary
==============================================================================================================================================================
Install 5 Packages
Total size: 1.4 M
Total download size: 1.4 M
Installed size: 4.8 M
Downloading Packages:
(1/4): libaio-devel-0.3.112-1.el8.x86_64.rpm 49 kB/s | 19 kB 00:00
(2/4): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 117 kB/s | 59 kB 00:00
(3/4): sysstat-11.7.3-11.0.1.el8.x86_64.rpm 929 kB/s | 427 kB 00:00
(4/4): ksh-20120801-259.0.1.el8.x86_64.rpm 981 kB/s | 923 kB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.5 MB/s | 1.4 MB 00:00
warning: /var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/libaio-devel-0.3.112-1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Oracle Linux 8 BaseOS Latest (x86_64) 3.0 MB/s | 3.1 kB 00:00
Importing GPG key 0xAD986DA3:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : ksh-20120801-259.0.1.el8.x86_64 1/5
Running scriptlet: ksh-20120801-259.0.1.el8.x86_64 1/5
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/5
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/5
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Installing : sysstat-11.7.3-11.0.1.el8.x86_64 3/5
Running scriptlet: sysstat-11.7.3-11.0.1.el8.x86_64 3/5
Installing : libaio-devel-0.3.112-1.el8.x86_64 4/5
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el7.x86_64 5/5
Installing : oracle-database-preinstall-19c-1.0-1.el7.x86_64 5/5
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el7.x86_64 5/5
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored
Verifying : libaio-devel-0.3.112-1.el8.x86_64 1/5
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 2/5
Verifying : ksh-20120801-259.0.1.el8.x86_64 3/5
Verifying : sysstat-11.7.3-11.0.1.el8.x86_64 4/5
Verifying : oracle-database-preinstall-19c-1.0-1.el7.x86_64 5/5
Installed:
ksh-20120801-259.0.1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64
oracle-database-preinstall-19c-1.0-1.el7.x86_64 sysstat-11.7.3-11.0.1.el8.x86_64
Complete!
|
정상적으로 설치됨
원인 : linux 8 버전에서 19c 설치 시 필요없는 패키지가 들어있어 발생한 문제
linux 8 버전에 19c 설치시에는 해당 패키지가 필요가 없음
그런데 이 때 oracle linux 8 에 oracle linux 7용 oracle preinstall을 설치하면 해당 두 패키지를 설치하려고 해서 에러가 발생하는것
Oracle Linux 7 19c 필요패키지 | Oracle Linux 8 19c 필요패키지 |
bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcb make policycoreutils policycoreutils-python smartmontools sysstat |
bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat |
버전에 맞게 preinstall 패키지를 설치해야함
참조 :
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/supported-oracle-linux-8-distributions-for-x86-64.html#GUID-F4902762-325B-4C89-B85B-F52BA482190F
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/supported-oracle-linux-7-distributions-for-x86-64.html#GUID-3E82890D-2552-4924-B458-70FFF02315F7
https://docs.oracle.com/en/database/oracle/oracle-database/19/rnrdm/linux-platform-issues.html#GUID-69942B7A-B662-48DC-8FC1-DFC56A3719D6
https://forums.oracle.com/ords/r/apexds/community/q?question=unable-to-install-compat-libcap1-1-10-in-ol8-2-5797&session=213119556475496
https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-8
https://blog.naver.com/spacemarket/221905694917
'ORACLE > Trouble Shooting' 카테고리의 다른 글
Warning: VKTM detected a backward time drift. (0) | 2023.12.08 |
---|---|
오라클 19c runInstaller gui 빈화면 문제 (0) | 2023.12.04 |
DBeaver Network unavailable due to certificate issue. (4) | 2023.11.21 |
ORA-08104: this index object is being online built or rebuilt (0) | 2023.09.01 |
Warning: log write elapsed time 519ms, size 275KB (0) | 2023.08.17 |