My Oracle Support Banner

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

Last updated on APRIL 17, 2023

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
        0

 

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].

 

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.