Oracle-Based Deployment Guide for Cisco IoT FND, Release 5.x.x and Later

PDF

Run the Cisco IoT FND DB migration script

Updated: March 2, 2026

Want to summarize with AI?

Log in

Overview

Learn how to run the IoT FND database migration script to set up or update IoT FND tables before launching the application for the first time or after an upgrade.

Cisco IoT FND uses a database migration system that allows you to migrate your Cisco IoT FND database without performing a full database dump and restore. Each migration updates the database tables and keeps a record of migrations already performed.

Before you begin

Before launching Cisco IoT FND for the first time, you must run the database migration script to set up the required tables in the database.

Procedure

1.

Change to the Cisco IoT FND binary directory and run the database migration script:

Example:


                        #
                        cd /opt/cgms/bin
                        #
                        ./db-migrate
Note
This script runs for a few minutes before launching Cisco IoT FND for the first time. Running this script after upgrading to a new version of Cisco IoT FND takes longer depending on the amount of data in the Cisco IoT FND database.
Note
If deploying Cisco IoT FND server cluster, run the db-migrate script on only one cluster node.
2.

When prompted, enter the database password.

The db-migrate command prompts you for the database password. The default password is cgms123 .

3.

If you enter an incorrect password multiple times, unlock your Oracle user account.

Caution
Ensure that the password entered while running the db-migrate script is the correct password. If you enter an incorrect password multiple times, Oracle might lock your user account. If so, you have to unlock your account on the database server.

  • If you enter an incorrect Cisco IoT FND Database password multiple times, Oracle locks your user account. Unlock your password using the Oracle software, as shown in this example:


                        # su - oracle
                        # sqlplus sys/<database_password>@cgms as sysdba
                        alter user cgms_dev account unlock;
                        exit;