Task 2: Configuring the Queues and Propagation Between Them

Create a queue at each database, and create a propagation to send messages about orders from the queue at the ii1.example.com database to the queue at the ii2.example.com database.

To create a propagation: 

1. Create a queue named streams_queue in the schema of the Oracle Streams administrator at both the ii1.example.com and ii2.example.com databases. See "Creating an ANYDATA Queue" for instructions.

2. Create a database link named ii2.example.com in the Oracle Streams administrator schema at ii1.example.com. Configure the database link to connect to the Oracle Streams administrator schema at ii2.example.com. The service name of the database link must be ii2.example.com. See "Tutorial: Creating a Database Link" for instructions.

3. In Oracle Enterprise Manager, log in to the ii1.example.com database as the Oracle Streams administrator.

4. Go to the Database Home page.

5. Click Data Movement to open the Data Movement subpage.

6. Click Manage Replication in the Streams section.

7. On the Streams page, click Streams to open the Streams subpage.

8. Click Setup Propagation to open the Setup Propagation page.

9. Enter send_orders in the Propagation Name field.

10. Enter strmadmin.streams_queue in the Source Queue field. This queue is the queue at the ii1.example.com database into which messages about orders will be enqueued.

11. Enter the name of the database link that you created in Step 2 in the Destination Database Link field. In this example, the database link name is ii2.example.com.

12. Enter strmadmin.streams_queue in the Destination Queue field. This is the queue at the ii2.example.com database to which messages about orders will be sent.

13. Leave the Positive Rule Set and Negative Rule Set fields empty. When a propagation does not have a rule set, it sends all of the messages in the source queue to the destination queue.

14. Enable the Queue to Queue Propagation option.

15. Click OK to create the propagation.

16. Complete the steps in "Task 3: Configuring a Message Enqueuing Mechanism" to continue this extended example.