To upgrade the Oracle rpms in your split architecture deployment:

1. Backup the existing Oracle directory.

   #cd /usr/lib
   #cp -Rp oracle oracle.BAK

2. Verify the rpms installed.

   #rpm -qa | grep oracle
   
   oracle-instantclient-basic-xx.xx.x.x.x-x.exx.x86_64
   oracle-instantclient-sqlplus-xx.xx.x.x.x-x.exx.x86_64

3. Remove the existing rpms.

   #rpm -e oracle-instantclient-basic-xx.xx.x.x.x-x.exx.x86_64
   # rpm -e oracle-instantclient-sqlplus-xx.xx.x.x.x-x.exx.x86_64
   

4. Verify that the rpms are removed.

   #rpm -qa | grep oracle

5. Install the new rpms.

   #rpm -ivh oracle-instantclient-basic-xx.xx.x.x.x-x.exx.x86_64.rpm
   warning: oracle-instantclient-basic-xx.xx.x.x.x-x.exx.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
   Verifying...                          ################################# [100%]
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:oracle-instantclient-basic-21.18.################################# [100%]
   
   

   #rpm -ivh oracle-instantclient-sqlplus-xx.xx.x.x.x-x.exx.x86_64.rpm
   warning: oracle-instantclient-sqlplus-xx.xx.x.x.x-x.exx.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
   Verifying...                          ################################# [100%]
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:oracle-instantclient-sqlplus-21.1################################# [100%]

6. Verify that SQL Plus is installed.

   #which sqlplus
   /usr/bin/sqlplus

7. Verify the symbolic link.

   #ls -al /usr/bin/sqlplus
   lrwxrwxrwx 1 root root 39 <TimeStamp> /usr/bin/sqlplus -> /usr/lib/oracle/21/client64/bin/sqlplus

8. Verify the SQL Plus version and test.

   #su - aptare
   #sqlplus -version
   
   SQL*Plus: Release xx.x.x.x.x - Production
   Version xx.xx.x.x

   #sqlplus portal@<portal_user_password>@<service_name>
   
   SQL*Plus: Release xx.x.x.x.x - Production on <TimeStamp> 
   Version xx.xx.x.x
   
   Copyright (c) <year>, <year>, Oracle.  All rights reserved.
   
   Last Successful login time: <TimeStamp>
   
   Connected to:
   Oracle Database 19c Enterprise Edition Release 19.x.x.x.x - Production
   Version 19.x.x.x.x
   
   

   Example:

   #su - aptare
   #sqlplus -version
   
   SQL*Plus: Release 21.0.0.0.0 - Production
   Version 21.18.0.0.0
   
    
   
   #sqlplus portal/portal@scdb
   
   SQL*Plus: Release 21.0.0.0.0 - Production on Wed Jul 9 12:48:13 2025
   Version 21.18.0.0.0
   
   Copyright (c) 1982, 2022, Oracle.  All rights reserved.
   
   Last Successful login time: Sat May 17 2025 23:58:30 -05:00
   
   Connected to:
   Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
   Version 19.3.0.0.0

9. Verify TNSNAMES.ORA if required.

   #cd /usr/lib/oracle/21/client64/lib/network/admin/
   
   #cat tnsnames.ora
   scdb =
       (DESCRIPTION =
           (ADDRESS=
               (PROTOCOL=TCP)
               (HOST=xxx.xxx.xxx.xxx)
               (PORT=1521)
           )
           (CONNECT_DATA=(SERVICE_NAME=scdb)(SID=scdb))
       )
   
   EXTPROC_CONNECTION_DATA =
       (DESCRIPTION =
           (ADDRESS=
               (PROTOCOL=IPC)
               (HOST=xxx.xxx.xxx.xxx)
               (KEY=extproc)
   
           (CONNECT_DATA=(SERVICE_NAME=extproc_sid)(SID=extproc_sid))
       )
   
   SCDBCNTR =
       (DESCRIPTION =
           (ADDRESS=
               (PROTOCOL=TCP)
               (HOST=xxx.xxx.xxx.xxx)
               (PORT=1521)
           )
           (CONNECT_DATA=(SERVICE_NAME=scdbcntr)(SID=scdbcntr))
       )