Upgrade the Database Schema

If you use Signal Review reporting, 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 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.