Skip Headers

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
Go To Index
Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Product Name
Conventions
Related Publications
SQL*Plus Prompts
UNIX Prompts
Storage Measurements
Documents Referenced in this Guide

1 Introduction

Introduction to Message Queuing
Introduction to IBM MQSeries
MQSeries Terms
Introduction to the Gateway
Developing Gateway Applications
Gateway Terms
Advantages of Using the Gateway
Gateway Architecture
Component Descriptions
Oracle Applications
Oracle Integrating Server
Oracle Net
Gateway
MQSeries Queue Manager
MQSeries Application
Gateway Structure
Starting the Gateway
Communication

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
Bugs Fixed
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
ORACLE_HOME
Preventing Conflicts Between ORACLE_HOME Directories
Setting ORACLE_HOME
ORACLE_SID
Setting ORACLE_SID
DISPLAY
On Server where the Installer is Running
In Session on Your Workstation
TMP
About Oracle Universal Installer
oraInventory Directory
Starting Oracle Universal Installer

5 Installation

Installation
Running root.sh

6 Deinstallation and Reinstallation

Deinstallation
Deinstalling Using Oracle Universal Installer
Deinstalling Oracle9i Procedural Gateway for IBM MQSeries
Reinstallation

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
TCP/IP Example
IPC Example
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
Introduction
Verifying and Installing PL/SQL Packages
Removing the PL/SQL Packages

8 Gateway Running Environment

Security Models
Relaxed Model
Strict Model
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
Single-Site
Commit-Confirm
Troubleshooting
Message and Error Code Processing
Interpreting Gateway Messages
Common Error Codes
Gateway Tracing
LOG_DESTINATION
Example
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
Installation
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
Error Messages
Name:  UNSCHEDULE_PROPAGATION
Error Messages:
Example
Security
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
Error Messages
Name: UNSCHEDULE_INBOUND_PROPAGATION
Error Messages
Example
Security
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
Migration Tips
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
OPTIONS Field
VERSION Field
MATCHOPTIONS Field
WAITINTERVAL
PGM8.MQMD Values
CODEDCHARSETID Field
ENCODING 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
EXPIRY Field
FEEDBACK Field
FORMAT Field
MSGTYPE Field
PERSISTENCE Field
PRIORITY Field
PUTAPPLTYPE Field
REPORT Field
VERSION Field
Report Field, Mask Values
PGM8.MQOD Values
OBJECTTYPE Field
OBJECTTYPE Field, Extended Values
VERSION Field
PGM8.MQPMO Values
OPTIONS Field
VERSION Field
MQCLOSE Values
hobj Argument
options Argument
MQOPEN Values
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.TO_RAW
UTL_RAW.BIT_AND
UTL_RAW.BIT_COMPLEMENT
UTL_RAW.BIT_OR
UTL_RAW.BIT_XOR
UTL_RAW.CAST_TO_RAW
UTL_RAW.CAST_TO_VARCHAR2
UTL_RAW.COMPARE
UTL_RAW.CONCAT
UTL_RAW.CONVERT
UTL_RAW.COPIES
UTL_RAW.LENGTH
UTL_RAW.OVERLAY
UTL_RAW.REVERSE
UTL_RAW.SUBSTR
UTL_RAW.TRANSLATE
UTL_RAW.TRANSLITERATE
UTL_RAW.XRANGE

C Gateway Initialization Parameters

Gateway Initialization File
Gateway Parameters
HS_DB_DOMAIN
HS_DB_NAME
LOG_DESTINATION
AUTHORIZATION_MODEL
QUEUE_MANAGER
TRACE_LEVEL
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


Next
Oracle Logo
Copyright © 2001, 2002 Oracle Corporation

All rights reserved
Go To Index
Index