Tutorial: Sending Messages Between Oracle Databases

The example in this topic involves a business that enters orders in an Oracle database at headquarters. When an order is entered, the business wants to use a messaging system to send the order ID and order date to an Oracle database in a warehouse in a different location. These messages alert employees at the warehouse about the orders so that they can fill and ship them. The employees at the warehouse have access to the data at headquarters to find detailed information about any particular order.

This example uses the oe sample schema for its order-entry schema. The oe sample schema is installed by default with Oracle Database.

In this example, the global name of the database at headquarters is ii1.example.com, and the global name of the database at the warehouse is ii2.example.com. However, you can substitute any two databases in your environment to complete the example.

Figure: Sample Messaging Environment That Sends Messages Between Databases provides an overview of the messaging environment created in this example.

Before you start this example, complete the tasks described in "Preparing for Messaging".

To configure a messaging system that sends messages about orders from the ii1.example.com database to the ii2.example.com database: 

• Task 1: Creating the Message Type at Each Database

• Task 2: Configuring the Queues and Propagation Between Them

• Task 3: Configuring a Message Enqueuing Mechanism

• Task 4: Configuring a Messaging Client to Dequeue Messages

• Task 5: Enqueuing Messages

• Task 6: Dequeuing Messages