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
这个经过多次测试，应用了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
在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、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |