Skip Headers

Oracle® Health Sciences Empirica Topics Reporting and Oracle Business Intelligence Configuration Guide Release 8.0 E50113-01 |
| Contents

Previous |

# C Upgrading OBIEE

The Signal 8.0 version of the Empirica Authenticator requires 64-bit Oracle Business Intelligence Enterprise Edition release 11.1.1.7.+ with WebLogic Server 10.3.6.0.

Empirica Signal upgrades include updated versions of the OBIEE RPD and catalog files. You must upload the updated RPD file and re-deploy the web catalog file after upgrading your Empirica Signal installation. However, if you have customized your RPD file or your web catalog file, you must contact Oracle for assistance in order to avoid losing any customizations.

Upgrading OBIEE consists of the following tasks:

- Upgrading the OBIEE Topics views

- Un-installing the previous Empirica Authenticator

- Installing the new Empirica Authenticator

- Updating the RPD file and re-deploying the web catalog file

## Upgrading the OBIEE Topics views

If the Signal upgrade is referencing a different topic workflow configuration than before the upgrade, follow the directions specified in . This will create and populate a new OBIEE_TOPIC_WORKFLOW_n schema.

If the Signal upgrade is referencing the same topic workflow configuration as before the upgrade, the existing OBIEE_TOPIC_WORKFLOW_n schema may be reused. However, the views in the OBIEE_TOPIC_WORKFLOW_n schema will need to be refreshed.

1. Identify the topic workflow account used by the previous Signal 7.3 version of the Empirica Authenticator. This account will often have a name of the form OBIEE_TOPIC_WORKFLOW_n, where n represents the topic workflow configuration ID of the targeted topic workflow configuration. You will need the Oracle database password for this account.

2. On the Empirica Signal application server, locate the `populate_obiee_topics.sql` file in the contents extracted from the `Database.zip` file.

3. Open the `populate_obiee_topics.sql` file in a text editor.

4. Verify that the following properties are set to the appropriate values for your environment, editing the values as necessary:

   `DEFINE TOPIC_WORKFLOW = '<`topic workflow account`>';`

   `DEFINE SIGNAL = '<`Signal account`>';`

5. Open a command prompt window and execute the `populate_obiee_topics.sql` script as the database user identified in step 1.

   `sqlplus OBIEE_<`topic workflow account`>_<`topic workflow ID`>@<`TNS name for database connection`> @populate_obiee_topics.sql`

6. When prompted, type the password for the `OBIEE_``<`topic workflow account`>_<`topic workflow ID`>`

7. When prompted, type the same topic workflow configuration ID (the n value from step 1).

   The script completes, and creates the `populate_obiee_topics.log` file.

## Un-installing the previous Empirica Authenticator

To un-install the previous Empirica Authenticator (associated with Signal 7.3), perform the following tasks:

1. Stop all of the OBIEE server processes. If feasible, re-boot the server hosting OBIEE.

2. Locate the `empiricaprovider` directory on the OBIEE server. This is often located at `/u01/oracle/empiricaprovider`.

3. Make a backup copy of all of the files in the `empiricaprovider` directory. After making backup copies, delete all of the files in the `empiricaprovider` directory.

4. Locate the `<`WebLogic server`>/server/lib/mbeantypes` directory on the OBIEE server.

5. Delete the following files from the mbeantypes directory:

   - `ESAPI-1.4.4.jar`

   - `Log4j-1.2.16.jar`

   - `Secure-coding<`version`>.jar`

   - `Empirica<`version`>.jar`

   - `SignalTopicsCommon<`version`>.jar`

   - `Signal<`version`>.jar`

   - `Empiricaprovider<`version`>.jar`

## Installing the new Empirica Authenticator

To install the new Empirica Authenticator, perform the tasks specified in .

## Updating the RPD file and re-deploying the web catalog file

Empirica Signal upgrades include updated versions of the OBIEE RPD and catalog files. You must upload the updated RPD file and re-deploy the web catalog file after upgrading your Empirica Signal installation. However, if you have customized your RPD file or your web catalog file, you must contact Oracle for assistance in order to avoid losing any customizations.

To upgrade the RPD file and re-deploy the web catalog file, perform the tasks specified in .