Oracle Linux 9 / Red Hat Enterprise Linux 9上成功安装oracle 19c

郑全 · 发表于 2023-11-8 08:32:59

本帖最后由郑全于 2023-11-8 08:51 编辑

RHEL9.0上能安装ORACLE 19c 吗？

在ORACLE 19.19 以前，这个答案是否定的，不能安装，会报错，
/usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a

如果是单纯安装19C 客服端，报：

Error in invoking target 'client_sharedlib'

原因是从 oracle linux 9,rhel 9开始，pthread library y已经被集成进 glibc ,因此，linker找不到pthread library ，最后，就会报link失败

这个问题，需要下载ORACLE的一个补丁，35775632，

这个补丁，就是提供对应的文件

- Download stubs.tar from Patch 35775632 and extract
- Copy stubs.tar into $ORACLE_HOME/lib/stubs and extract (cmd: $ tar -xf stubs.tar)

登录/注册后可看大图

78738654ad729a80a8.png (83.35 KB, 下载次数: 462)

下载附件

2023-11-8 08:32 上传

这个补丁要求ORACLE 19C最低版本为：19.19及以上。安装这个补丁后，自动解决这个问题。

我这里是安装好后的结果：

[root@dbserver ~]# cat /etc/redhat-release
Red Hat Enterprise Linux release 9.2 (Plow)

我这里是安装的ORACLE LINUX 9.2
[root@dbserver ~]#
[root@dbserver ~]#
[root@dbserver ~]#
[root@dbserver ~]# su - oracle
[oracle@dbserver ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 8 08:17:15 2023
Version 19.21.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

@ >conn / as sysdba
Connected to an idle instance.
SYS@orclcdb >startup
ORACLE instance started.

Total System Global Area 2365586792 bytes
Fixed Size                9166184 bytes
Variable Size          520093696 bytes
Database Buffers       1828716544 bytes
Redo Buffers             7610368 bytes
Database mounted.
Database opened.
SYS@orclcdb >select name,open_mode from v$database;

NAME    OPEN_MODE
--------- --------------------
ORCLCDB READ WRITE

SYS@orclcdb >select BANNER_FULL from v$version;

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.21.0.0.0

SYS@orclcdb >! lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-NOV-2023 08:40:08

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.21.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date             08-NOV-2023 08:40:08
Uptime                   0 days 0 hr. 0 min. 4 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Log File       /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
The listener supports no services
The command completed successfully

SYS@orclcdb >! lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-NOV-2023 08:40:32

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date             08-NOV-2023 08:40:08
Uptime                   0 days 0 hr. 0 min. 24 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Log File       /u01/app/oracle/diag/tnslsnr/dbserver/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
The listener supports no services
The command completed successfully

SYS@orclcdb >

我这里数据库是安装的ORACLE 19C 19.21

至此，RHEL,ORACLE LINUX 9终于可以安装 ORACLE 19C了。

我已经把这个补丁包集成到ORACLE 19.21的安装包里面去了，后面只需要使用我的ORACLE 19.21安装包，就可以直接在RHEL/ORACLE LINUX 9以上版本安装了。

我集成的19.21包补丁情况：

[oracle@dbserver ~]$ $ORACLE_HOME/OPatch/opatch lspatches
35648110;OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)
35655527;OCW RELEASE UPDATE 19.21.0.0.0 (35655527)
35643107;Database Release Update : 19.21.0.0.231017 (35643107)

OPatch succeeded.

参考：

Doc ID 2982833.1

郑全 · 发表于 2023-11-12 23:57:07

这个经过多次测试，应用了19.21 RU后，自动包含这个新的STUBS 包。不需要单独去下载这个补丁包。

[oracle@dbserver stubs]$ ls -ltr libpthread*
-rw-r--r-- 1 oracle oinstall  1680 Oct  4 19:49 libpthread_stubs.a
-rw-r--r-- 1 oracle oinstall 44312 Oct  4 19:49 libpthread.so.0
-rw-r--r-- 1 oracle oinstall 214 Oct  4 19:49 libpthread.so
-rw-r--r-- 1 oracle oinstall 44312 Oct  4 19:49 libpthread-2.17.0-stub.so

郑全 · 发表于 2023-11-13 01:32:50

在RHEL9上安装GI，也会遇到这个问题，已经在19.21 上，自动解决这个问题。

-rw-r--r-- 1 grid oinstall 3614720 Oct  4 19:49 stubs.tar
-rw-r--r-- 1 grid oinstall 1680 Oct  4 19:49 libpthread_stubs.a
-rw-r--r-- 1 grid oinstall 44312 Oct  4 19:49 libpthread.so.0
-rw-r--r-- 1 grid oinstall    214 Oct  4 19:49 libpthread.so
-rw-r--r-- 1 grid oinstall 44312 Oct  4 19:49 libpthread-2.17.0-stub.so
-rw-r--r-- 1 grid oinstall 62392 Oct  4 19:49 libm.so.6
-rw-r--r-- 1 grid oinstall 62392 Oct  4 19:49 libm.so
-rw-r--r-- 1 grid oinstall 62392 Oct  4 19:49 libm-2.17.0-stub.so
-rw-r--r-- 1 grid oinstall  334376 Oct  4 19:49 libc.so.6
-rw-r--r-- 1 grid oinstall    94 Oct  4 19:49 libc.so
-rw-r--r-- 1 grid oinstall 1782 Oct  4 19:49 libc_nonshared_stat.a
-rw-r--r-- 1 grid oinstall  334376 Oct  4 19:49 libc-2.17.0-stub.so
[root@dbserver ~]# ls -ltr /u01/app/19.21.0/grid/lib/stubs/

帐号		自动登录	找回密码
密码			注册

[安装] Oracle Linux 9 / Red Hat Enterprise Linux 9上成功安装oracle 19c