Update the Oracle Analytics database account for Oracle Empirica Topics

If there are no customizations in the data model (RPD) or database schema, we recommend dropping the existing OBIEE_TOPIC_WORKFLOW account and recreating it by following the steps in Section 3Prepare the Oracle Empirica Signal database server for Oracle Analytics. If your environment includes customizations in the data model or schema, please contact Oracle Consulting for assistance in reapplying them to the default model.
  1. On the Oracle Empirica Signal application server, unzip the Database.zip file.
  2. Using a text editor, open the update_obiee_9_1_to_9_2.sql file and modify the following properties as needed for your environment:
    
    DEFINE TOPIC_WORKFLOW = '<topic workflow account>';
    DEFINE SIGNAL = '<Signal account>';
    DEFINE OBIEE_USER = 'OBIEE_&TOPIC_WORKFLOW._&TWC_ID.'
  3. Open the populate_obiee_topics.sql file in a text editor and modify the following properties as needed for your environment:
    DEFINE TOPIC_WORKFLOW = '<topic workflow account>';
    DEFINE SIGNAL = '<Signal account>'
  4. In a command prompt window, execute the update_obiee_9_1_to_9_2.sql script as the Oracle SYS user:
    $ sqlplus sys@<database_server_TNS name> as sysdba
    @update_obiee_9_1_to_9_2.sql

    Note:

    The database may reside on a different server than the Oracle Empirica Signal server.

    A password prompt appears.

  5. Enter the password for the Oracle SYS account.
  6. Enter the target topic workflow configuration ID.
  7. Enter the target topic workflow configuration ID again.
  8. After the script runs, verify there are no errors in update_obiee_9_1_to_9_2.log and populate_obiee_topics.log.