Configuring BWAgent for Oracle and TIBCO Enterprise Message Service

The BWAgent can be configured to use the Oracle Database with TIBCO Enterprise Message Service (EMS) for persistence and transport.

Note: The database name must be unique per agent network if multiple networks share the same physical database. BWAgent and BWEngine support sharing the same database.
Before you begin

  • Install the latest TIBCO Enterprise Messaging Server and start the server.

  • Download and install the latest Oracle Database from their official website.

  • Configure the server configuration by following the prompts in the Oracle Configuration wizard.

  • Accept the default port value 1521, or enter your own port number.

  • Download the latest JDBC driver connector JAR files to the BW_HOME\config\drivers\shells\jdbc.oracle.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.oracle\lib folder.

  • Install the Oracle driver by running the command bwinstall oracle-driver from the /bin folder.

    • Note: If you are using Oracle Database 11g, run the oracle11g_create.sql script at BW_HOME/config/dbscripts/admin/oracle and restart the BWAgent.

  • Ensure you have installed EMS client libraries. For more information, see the "Integrating with TIBCO Enterprise Message Service™" section in the TIBCO ActiveMatrix BusinessWorks™ Installation guide.

  • Optional. If you are upgrading to ActiveMatrix BusinessWorks 6.3.2, or later versions of the software, upgrade the database schema. For more information, see the "Updating the Database Schema to Enable BWAgent to Use Database with TIBCO Enterprise Message Service" section in the TIBCO ActiveMatrix BusinessWorks™ Installation guide.

    Procedure
  1. After installing the latest Oracle Database, create a database bwadmindb and grant privileges to the default database owner bwuser as described in the following steps:
    1. Run the following commands in SQLPlus as a root user: 
      CREATE DATABASE bwadmindb;
create USER C##bwuser identified by "bwuser";
GRANT CREATE SESSION TO C##bwuser;
grant create sequence to C##bwuser;
ALTER USER C##bwuser quota unlimited on USERS;
grant create table to C##bwuser;
  2. Stop the BWAgent if it is running.
  3. Open the bwagent_db.json file in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name Oracle Value
    dbtypeoracle
    dbdriver oracle.jdbc.OracleDriver
    dbconnectionurljdbc:oracle:thin:@localhost:1521:bwadmindb
    dbuserCbwuser
    dbpassword bwuser
  5. Run the BWAdmin config command with the -cf option push the changes from the JSON file to the bwagent.ini file. 
    BW_HOME\bin>bwadmin config -cf ../config/bwagent_db.json agent
    Note: If you are creating a user with '##' (for example, c##bwuser), then you need to keep the username field as empty in the bwagent_db.json file and later update the bwagent.ini file manually.
  6. Restart the BWAgent.