Configuring bwagent for Oracle and TIBCO Enterprise Message Service

The bwagent can be configured to use 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 supports sharing the same database.

Prerequisites

  • Install TIBCO Enterprise Messaging Server 8.1 and start the server.
  • Install Oracle Database 12c:
    1. Download and install Oracle Database 12c from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
    2. Configure the server configuration by following the prompts in the Oracle Configuration wizard.
    3. Accept the default port value 1521, or enter your own port number.
    4. Download the following 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:
      1. ojdbc7.jar from http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html
  • Install the Oracle driver by running the command bwinstall oracle-driver from the /bin folder.
    Note: If you are using Oracle Database 11g, execute 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 Oracle Database 12c, 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 located in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name Oracle Value
    dbtype oracle
    dbdriver oracle.jdbc.OracleDriver
    dbconnectionurl jdbc:oracle:thin:@localhost:1521:bwadmindb
    dbuser Cbwuser
    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 '##' ( e.g. 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.