Oracle Database Setup and Upgrade Guide for Cisco IoT FND, Release 5.x.x and Later

PDF

Oracle Database Setup and Upgrade Guide for Cisco IoT FND, Release 5.x.x and Later

Install Oracle DB patch

Updated: October 17, 2025

Want to summarize with AI?

Log in

Provides instructions to prepare for and install an Oracle 19c patch by checking the current Oracle version, stopping Cisco IoT FND and Oracle services, and applying the patch file.

Before you begin

Note

To install the Oracle 19c patch as an additional option from 19.3.0.0.0 to 19.18.0.0.0, complete these prerequisites before installing the patch.

  • Check the current Oracle version using the given command:

    [root@iot-fnd-oracle ~]# su - oracle
    [oracle@iot-fnd-oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 29 20:59:44 2023
Version 19.3.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> exit;

  • Stop the Cisco IoT FND application if it is already running. Use the given command: 

    service cgms stop

  • Log in as the oracle user.

    su - oracle
    Note
    Stop the Oracle service if it is already running: 
    
cd /opt/cgms-oracle/scripts
./stopOracle.sh

  • Apply the patch file: p34765931_190000_Linux-x86-64.zip.

Use the following steps to install the Oracle DB patch:

Use this procedure to install the Oracle DB patch.

Procedure

Follow the steps given in Downloading and Installing Release Update Patches.