Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Introduction to Oracle Messaging Gateway

Messaging Gateway Functionality

Messaging Gateway Architecture

Administration Package

Gateway Agent

Propagation Processing

2 Installing Messaging Gateway

Oracle9i Database Prerequisites

Non-Oracle Messaging System Prerequisites

Running the Oracle Universal Installer

Checks after Running the Installer

Postinstallation Tasks

Loading Database Objects into the Database

Checking listener.ora for the External Procedure

Modifying tnsnames.ora for the External Procedure

Modifying mgw.ora for the External Procedure

Modifying tnsnames.ora for the Gateway Agent's Connection to the Database

Creating an Administration User

Creating an Agent User

Configuring Messaging Gateway Connection Information

Installation Verification

Messaging Gateway Uninstall

Troubleshooting

3 Working with Messaging Gateway

Managing the Messaging Gateway Agent

Configuration

Startup and Shutdown

Configuring Messaging Gateway Links

Creating a Messaging Gateway Link

Altering a Messaging Gateway Link

Removing a Messaging Gateway Link

Monitoring the Status of a Messaging Gateway Link

Registering Non-Oracle Messaging System Queues

Registering a Non-Oracle Queue

Altering a Registered Queue

Unregistering a Non-Oracle Queue

Monitoring the Status of a Registered Non-Oracle Queue

AQ Queues

Configuring Propagation Jobs

Creating a Messaging Gateway Subscriber

Creating Messaging Gateway Schedules

Enabling and Disabling Propagation Jobs

Resetting Propagation Jobs

Altering Subscribers and Schedules

Removing Subscribers and Schedules

Selection Rules

Using Transformations

Exception Queues

Monitoring Propagation Jobs

Monitoring the Messaging Gateway Log File

Sample Log File

4 Converting Messages

The Message Conversion Process

Messaging Gateway Canonical Types

Message Conversion for Advanced Queuing

Converting RAW AQ Payload Types

Converting MGW_BASIC_MSG_T AQ Payload Types

Using Transformations

Message Conversion for MQSeries

Message Header Conversions

Default Message Header Mapping

Advanced Queuing Header Properties

MQSeries Header Properties

Messaging Gateway Examples: Using Header Properties

5 DBMS_MGWADM

Summary of DBMS_MGWADM Object Types and Methods

MGW_PROPERTY Type

MGW_PROPERTY.CONSTRUCT Method

MGW_PROPERTY.CONSTRUCT Method

MGW_PROPERTIES Type

MGW_MQSERIES_PROPERTIES Type

MGW_MQSERIES_PROPERTIES.CONSTRUCT Method

MGW_MQSERIES_PROPERTIES.ALTER_CONSTRUCT Method

DBMS_MGWADM Constants

MQSeries System Properties

Basic Link Properties (MGW_MQSERIES_PROPERTIES)

Optional Link Properties

Optional Queue Properties

Summary of DBMS_MGWADM Subprograms

ALTER_AGENT Procedure

DB_CONNECT_INFO Procedure

STARTUP Procedure

SHUTDOWN Procedure

CLEANUP_GATEWAY Procedure

SET_LOG_LEVEL Procedure

CREATE_MSGSYSTEM_LINK Procedure

ALTER_MSGSYSTEM_LINK Procedure

REMOVE_MSGSYSTEM_LINK Procedure

REGISTER_FOREIGN_QUEUE Procedure

UNREGISTER_FOREIGN_QUEUE Procedure

ADD_SUBSCRIBER Procedure

ALTER_SUBSCRIBER Procedure

REMOVE_SUBSCRIBER Procedure

RESET_SUBSCRIBER Procedure

SCHEDULE_PROPAGATION Procedure

UNSCHEDULE_PROPAGATION Procedure

ALTER_PROPAGATION_SCHEDULE Procedure

ENABLE_PROPAGATION_SCHEDULE Procedure

DISABLE_PROPAGATION_SCHEDULE Procedure

Summary of Database Views

MGW_GATEWAY View

MGW_LINKS View

MGW_MQSERIES_LINKS View

MGW_FOREIGN_QUEUES View

MGW_SUBSCRIBERS View

MGW_SCHEDULES View

6 DBMS_MGWMSG

Summary of DBMS_MGWMSG Object Types and Methods

MGW_NAME_VALUE_T Type

MGW_NAME_VALUE_T.CONSTRUCT Method

MGW_NAME_VALUE_T.CONSTRUCT_<TYPE> Methods

MGW_NAME_TYPE_ARRAY_T Type

MGW_TEXT_VALUE_T Type

MGW_TEXT_VALUE_T.CONSTRUCT Method

MGW_RAW_VALUE_T Type

MGW_RAW_VALUE_T.CONSTRUCT Method

MGW_BASIC_MSG_T Type

MGW_BASIC_MSG_T.CONSTRUCT Method

DBMS_MGWMSG Constants

Summary of DBMS_MGWMSG Subprograms

NVARRAY_ADD Procedure

NVARRAY_GET Function

NVARRAY_GET_BOOLEAN Function

NVARRAY_GET_BYTE Function

NVARRAY_GET_SHORT Function

NVARRAY_GET_INTEGER Function

NVARRAY_GET_LONG Function

NVARRAY_GET_FLOAT Function

NVARRAY_GET_DOUBLE Function

NVARRAY_GET_TEXT Function

NVARRAY_GET_RAW Function

NVARRAY_GET_DATE Function

NVARRAY_FIND_NAME Function

NVARRAY_FIND_NAME_TYPE Function

Index