프린트 하기

내맘대로긍정이 알려주는

Oracle 23ai 신기능
무료 세미나 발표자료

다운로드 trending_flat

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/|  67 MB     00:04
Oracle Linux 8 Application Stream (x86_64)                                                                                     13 MB/|  53 MB     00:03
Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64)                                                     17 MB/|  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/|  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 명령을 사용하라고 공식문서에 나와있음

https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/installing-the-oracle-preinstallation-rpm-with-uln-support.html#GUID-AF94713E-97AF-4F20-8DBC-36BC383D0301

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/|  67 MB     00:03
Oracle Linux 8 Application Stream (x86_64)                                                                                     16 MB/|  53 MB     00:03
Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 8 (x86_64)                                                     17 MB/|  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/|  19 kB     00:00
(2/6): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm                                                             120 kB/|  59 kB     00:00
(3/6): libnsl-2.28-151.0.1.el8.x86_64.rpm                                                                                     173 kB/| 102 kB     00:00
(4/6): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm                                                                    261 kB/|  31 kB     00:00
(5/6): sysstat-11.7.3-11.0.1.el8.x86_64.rpm                                                                                   1.3 MB/| 427 kB     00:00
(6/6): ksh-20120801-259.0.1.el8.x86_64.rpm                                                                                    1.5 MB/| 923 kB     00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                         1.5 MB/| 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/| 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/|  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/| 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/|  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/|  19 kB     00:00
(2/4): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm                                                             117 kB/|  59 kB     00:00
(3/4): sysstat-11.7.3-11.0.1.el8.x86_64.rpm                                                                                   929 kB/| 427 kB     00:00
(4/4): ksh-20120801-259.0.1.el8.x86_64.rpm                                                                                    981 kB/| 923 kB     00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                         1.5 MB/| 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/| 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을 설치하면 해당 두 패키지를 설치하려고 해서 에러가 발생하는것

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

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