Oracle® Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide
Release 9.2.0.1.0 for UNIX
Part No. A96196-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Publications

SQL*Plus Prompts

Storage Measurements

Documents Referenced in this Guide

1 Introduction

Introduction to Message Queuing

Introduction to IBM MQSeries

Introduction to the Gateway

Developing Gateway Applications

Advantages of Using the Gateway

Gateway Architecture

Component Descriptions

Oracle Applications

Oracle Integrating Server

MQSeries Queue Manager

MQSeries Application

Gateway Structure

Starting the Gateway

2 Release Information

The Product Set

Changes and Enhancements

Changes and Enhancements for Release 9.2.0.1.0

Oracle Server Dependencies

Password Encryption Utility

Changes and Enhancements for Release 9.0.1.0.1

HS= Parameter in tnsnames.ora file

PG4MQ Data Types

PGM_UTL Procedures

PG4MQ API prototype changes

Heterogeneous Services Architecture

Performance Enhancements

New PG4MQ Packages

Known Problems for Release 9.2.0.1.0

Known Restrictions for Release 9.2.0.1.0

3 Requirements

Hardware Requirements

Software Requirements

Oracle Integrating Server

Recommended Documentation

4 Pre-installation

Preinstallation Tasks

MQSeries Software

Setting Environment Variables

Preventing Conflicts Between ORACLE_HOME Directories

Setting ORACLE_HOME

Setting ORACLE_SID

On Server where the Installer is Running

In Session on Your Workstation

About Oracle Universal Installer

oraInventory Directory

Starting Oracle Universal Installer

5 Installation

Running root.sh

6 Deinstallation and Reinstallation

Deinstalling Using Oracle Universal Installer

Deinstalling Oracle9i Procedural Gateway for IBM MQSeries

7 Configuration

Configuration Overview

Configuring the Gateway

Using the Gateway with the Default Values

Using the Gateway without the Default Values

Changing Default Values

Step 1: Choose a system ID for the gateway

Step 2: Customize the gateway boot file

Step 3: Customize the Gateway Initialization File

Configuring Oracle Net for the Gateway

Using Oracle Net with Gateway Default Values

Using Oracle Net When Changing the Gateway Default Values

Step 1: Configure the Oracle Net TNS listener for the gateway

Step 2: Stop and start the TNS listener for the gateway

Configuring Oracle Net for the Oracle Integrating Server

Using Gateway Default Values

Changing Gateway Default Values

Creating a Transaction Log Queue

Administering Database Links

Creating Database Links

Dropping Database Links

Examining Available Database Links

Limiting the Number of Active Database Links

Installing the Visual Workbench Repository

Preinstallation Tasks

Step 1: Choose a repository server

Step 2: Locate the installation scripts

Step 3: Ensure the UTL_RAW package is installed

Step 4: Ensure the DBMS_OUTPUT package is enabled

Step 5: Create a database link

Visual Workbench Repository Installation Tasks

Step 1: Enter the database connection information

Step 2: Check for existing Workbench Repository

Step 3: Check for required PL/SQL packages

Step 4: Install the UTL_PG package

Step 5: Create the admin user and all repository tables

Step 6: Create public synonyms and development roles

After the Repository is Created

Deinstall the Visual Workbench Repository

Step 1: Enter the database connection information

Step 2: Check for existing Workbench repository

Preparing the Production Oracle Server

Verifying and Installing PL/SQL Packages

Removing the PL/SQL Packages

8 Gateway Running Environment

Security Models

The Authorization Process for an MQSeries Server Application

The Authorization Process for an MQSeries Client Application

Authorization for MQSeries Objects

Transaction Support

Non-Oracle Data Sources and Distributed Transactions

Transaction Capability Types

Transaction Capability Types of Procedural Gateway for IBM MQSeries

Troubleshooting

Message and Error Code Processing

Interpreting Gateway Messages

Common Error Codes

Gateway Tracing

LOG_DESTINATION

Verifying Gateway Operation

9 Heterogeneous Message Propagation

Heterogeneous Message Propagation Option

Oracle Advanced Queuing (AQ)

Operational and Administrative Interfaces

Outbound Interfaces

Inbound Interfaces

Heterogeneous Outbound Propagation

Outbound Propagation in General

Heterogeneous Inbound Propagation

Inbound Propagation in General

10 Installing Heterogeneous Message Propagation

Oracle Software Requirement

Installing the Heterogeneous Message Propagation Option

PL/SQL Installation Scripts

Privileges and Access Control

HQ_ADMINISTRATOR_ROLE:

Calling DBMS_HQADM from a PL/SQL Function or Procedure:

AQ_ADMINISTRATOR_ROLE:

Verifying the Heterogeneous Message Propagation Option

Deinstalling the Heterogeneous Message Propagation Option

11 Configuring Heterogeneous Outbound Message Propagation

Overview of Outbound Message Propagation

Translation of Oracle AQ/IBM MQSeries Interfaces

Translation for Outbound Propagation for MQSeries

DBMS_AQ.ENQUEUE

DBMS_AQADM.CREATE_QUEUE_TABLE

DBMS_AQADM.CREATE_QUEUE

DBMS_AQ.ENQUEUE_OPTIONS_T

DBMS_AQ.MESSAGE_PROPERTIES_T

Configuring Outbound Message Propagation

Operational Interface for Individual Messages

Operational Interface for Queues

Oracle AQ Procedures and Structures

Administrative Interfaces

Procedures for Outbound Message Propagation

Name: SCHEDULE_PROPAGATION

Name: UNSCHEDULE_PROPAGATION

Error Messages:

Exception Handling

Schedule Status

Status of an Outbound Message Propagation Schedule

12 Configuring Heterogeneous Inbound Message Propagation

Overview of Inbound Message Propagation From MQSeries

Translation of MQSeries/Oracle AQ Interfaces

Translations for inbound propagation for MQSeries:

DBMS_AQ.DEQUEUE:

DBMS_AQ.DEQUEUE_OPTIONS_T

DBMS_AQ.MESSAGE_PROPERTIES_T

Configuring Inbound Message Propagation

Operational Interface

Administrative Interface

Procedures for Inbound Message Propagation

Name: SCHEDULE_INBOUND_PROPAGATION

Name: UNSCHEDULE_INBOUND_PROPAGATION

Exception Handling

propagation exception queue

Schedule Status

Status of an Inbound Message Propagation Schedule

A The PGM8, PGM_UTL8, and PGM_SUP Packages

PGM8 Package and PG4MQ Gateway Procedures

Summary of Procedures and Type Definitions

Procedure Conventions

MQI Calls Performed by the Gateway

Unsupported MQI Calls

MQCLOSE Procedure

MQGET Procedure

PGM8.MQMD Type Definition

PGM8.MQGMO Type Definition

MQOPEN Procedure

PGM8.MQOD Type Definition

MQPUT Procedure

PGM8.MQPMO Type Definition

PGM_SUP Package

PGM8.MQGMO Values

MATCHOPTIONS Field

PGM8.MQMD Values

CODEDCHARSETID Field

ENCODING Field, Values for Binary Integers

ENCODING Field, Values for Floating Point Numbers

ENCODING Field, Mask Values

ENCODING Field, Values for Packed Decimal Integers

PERSISTENCE Field

PUTAPPLTYPE Field

Report Field, Mask Values

PGM8.MQOD Values

OBJECTTYPE Field

OBJECTTYPE Field, Extended Values

PGM8.MQPMO Values

hobj Argument

options Argument

options Argument

Maximum Lengths for Fields of PGM8 Type Definitions

Error Code Definitions

Error Code -8500

Error Code -8501

B UTL_RAW Package

Message Data Types

UTL_RAW Functions

UTL_RAW.BIT_AND

UTL_RAW.BIT_COMPLEMENT

UTL_RAW.BIT_XOR

UTL_RAW.CAST_TO_RAW

UTL_RAW.CAST_TO_VARCHAR2

UTL_RAW.COMPARE

UTL_RAW.CONVERT

UTL_RAW.OVERLAY

UTL_RAW.REVERSE

UTL_RAW.TRANSLATE

UTL_RAW.TRANSLITERATE

C Gateway Initialization Parameters

Gateway Initialization File

Gateway Parameters

LOG_DESTINATION

AUTHORIZATION_MODEL

TRANSACTION_LOG_QUEUE

TRANSACTION_MODEL

TRANSACTION_RECOVERY_PASSWORD

Passwords in the Gateway Initialization File

Using the pg4mqpwd Utility

TRANSACTION_RECOVERY_PASSWORD=*

TRANSACTION_RECOVERY_USER

D Heterogeneous Message Propagation DBA Views

DBA_OUTBOUND_SCHEDULES:

DBA_INBOUND_SCHEDULES:

Index

Copyright © 2001, 2002 Oracle Corporation
All rights reserved | | Ad Choices.