Upgrade the Database Schema

If you use Signal Review reporting and you are upgrading from Empirica Signal 2025.4.01, perform the following steps to update the database schema.

1. In a command shell, navigate to the database directory (for example, /u01/stage/Database).
2. Open ESI_2025.4.02/update_obiee_2025.4.01_to_2025.4.02.sql and verify the Signal account value assigned to the variable SIGNAL. Update it if needed.
3. Connect to SQL*Plus as the Signal Review reporting user (for example, OBIEE_SIGNAL_MGT) and execute the script
   $ sqlplus OBIEE_SIGNAL_MGT@<connection_str> @update_obiee_2025.4.01_to_2025.4.02.sql
4. Enter the password when prompted.
5. Confirm that the script completed without errors.