Install ActiveMQ

Download ActiveMQ from http://activemq.apache.org to the computer where SharePlex for Oracle is installed.

In the lib/providers directory in the SharePlex for Oracle product directory, create the directory activemq and extract the ActiveMQ download to this location.

$tar -xvfz apache-activemq-version-bin.tar.gz

Copy the ActiveMQ JAR file and dependencies from providers/activemq/lib to providers/activemq/.

Start ActiveMQ

Change to the ActiveMQ bin directory lib/providers/activemq/bin/ and start ActiveMQ:

./activemq start

Open the web console to verify ActiveMQ is running ok: http://localhost:8161/admin/ with the username and password "admin".

TIP: To run ActiveMQ on a computer other than the one where SharePlex for Oracle is installed:

1. Download and install ActiveMQ.
2. Install ActiveMQ on a second computer.
3. Run ActiveMQ from the second computer. The second computer requires network access to SharePlex for Oracle and SharePlex Connector for Hadoop.

Start the SharePlex cop Process

From the SharePlex for Oracle SHAREPLEX_PRODUCT_DIRECTORY/bin directory, start the sp_cop process.

/u01/app/shareplex/prod/bin > ./sp_cop &

Leave this session open.

Configure ActiveMQ

Configure ActiveMQ to work with SharePlex

Set the environment parameters for the JNDI environment as follows. For more information on JNDI and ActiveMQ see http://activemq.apache.org/jndi-support.html

Start a SharePlex sp_ctrl session

/u01/app/shareplex/prod/bin > ./sp_ctrl

sp_ctrl ()>

Set the Factory Class

sp_ctrl ()> target x.jms queue PostQueueName set jms factory_class = org.apache.activemq.jndi.ActiveMQInitialContextFactory

This creates the SharePlex post queue (name PostQueueName) and sets the JNDI property java.naming.factory.initial.

Declare the ActiveMQ URL

sp_ctrl ()> target x.jms queue PostQueueName set jms provider_url = url

This sets the JNDI property java.naming.provider.url. Set it to the host name or IP address of the host running ActiveMQ. Example URLs are tcp://w2k3-64bit:61616 or tcp://localhost:61616

Declare the location of the ActiveMQ JAR files

sp_ctrl ()> target x.jms queue PostQueueName set jms lib_location = activemq

Set lib_location to the directory in the SharePlex /lib/providers directory where you copied the ActiveMQ JAR files. The above example assumes the JAR files were copied to the SHAREPLEX_PRODUCT_DIRECTORY/lib/providers/activemq.

The JMS Queue name

By default the JMS queue name is OpenTarget.

You can create an additional JMS queue with the following command. The JMS queue name in the example is JMSQueueName.

sp_ctrl> target x.jms queue PostQueueName set jms queuename = JMSQueueName

Note: The JMS queue with the name "Command_Queue_ORACLE_HOST_NAME" is reserved for internal use by SharePlex Connector for Hadoop. Do not use it.

Further Commands