sqlplus banner from ASM shows version 19.3.0.0.0 even though RU 19.4 applied (Doc ID 2588500.1)

本文解决了一个Oracle 19c环境中,应用了19.4RU补丁后,其中一个ASM节点的sqlplus版本仍显示为19.3的问题。通过重新链接GI Home,成功将版本更新至19.4。

sqlplus banner from ASM shows version 19.3.0.0.0 even though RU 19.4 applied (Doc ID 2588500.1)       

In this Document
Symptoms
Changes
Cause
Solution

APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
After patching to 19.4 RU ,sqlplus banner still showing as 19.3.0.0.0 for ASM for one of the node ,say here it's Node 2.

Node 2:

[+ASM2] ]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on <timestamp>
Version 19.4.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select * from v$version ;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------    
   CON_ID
----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    
Node 1:

+ASM1] ]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on <timestamp>
Version 19.4.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0
SQL> select * from v$version ;

BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------    
   CON_ID
----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
        0
 

Both the node has 19.4 RU applied to GI Home:
 

[+ASM1] ]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [XXXXXXXX] and the complete list of patches [29401763 29517242 29517247 29585399 29834717 29850993 29851014 ] have been applied on the local node. The release patch string is [19.4.0.0.0].

[+ASM2] ]$ crsctl query crs releasepatch
Oracle Clusterware release patch level is [XXXXXXXX] and the complete list of patches [29401763 29517242 29517247 29585399 29834717 29850993 29851014 ] have been applied on the local node. The release patch string is [19.4.0.0.0].
 

CAUSE
libsqlplus.so value on Node 2  has different values then the node 1:

NODE 2:

[+ASM2] ]$ ls -la $GI_HOME/lib/*libsqlplus*
-rw-r--r--. 1 root oinstall 1573416 Aug 24 20:56 $GI_HOME/lib/libsqlplus.so

NODE 1 :

[+ASM1] ]$ ls -la $GI_HOME/lib/*libsqlplus*
-rw-r--r--. 1 root oinstall 1572880 Aug 29 16:35 $GI_HOME/lib/libsqlplus.so

SOLUTION
Please relink the GI Home for node 2:

1) As root OS user, please unlock the Grid Infrastructure Oracle Home as follows:

# cd < Grid Infrastructure Oracle Home >/crs/install
# rootcrs.sh -unlock

2) As the Oracle Grid Infrastructure owner relink the Grid Infrastructure Oracle Home as follows:

$ export ORACLE_HOME=< Grid Infrastructure Oracle Home >
$ < Grid Infrastructure Oracle Home>/bin/relink all

3) As root OS user again, please execute the next commands :

# cd < Grid Infrastructure Oracle Home >/rdbms/install/
# ./rootadd_rdbms.sh
# cd < Grid Infrastructure Oracle Home >/crs/install
# rootcrs.sh -lock


4) As root OS user, to Start the Cluster:
#crsctl start crs

And now   shows  correct version 19.4.0.0.0

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值