Update the Oracle Analytics database account for Oracle Empirica Topics

If you are upgrading from an existing Oracle Business Intelligence account for Oracle Empirica Topics prior to 9.2, you need to update the account on the Oracle Empirica Signal server.

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.