Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Product Name
• Typographic Conventions
• Command Syntax
• Related Publications
• Related Documents

1 Introduction

• 1.1 Introduction to Message Queuing
• 1.2 Introduction to WebSphere MQ
  • 1.2.1 WebSphere MQ Terms
• 1.3 Introduction to the Gateway
  • 1.3.1 Developing Gateway Applications
  • 1.3.2 Gateway Terms
  • 1.3.3 Advantages of Using the Gateway
  • 1.3.4 Gateway Architecture
  • 1.3.5 Component Descriptions
    • 1.3.5.1 Oracle Applications
    • 1.3.5.2 Oracle Database
    • 1.3.5.3 Oracle Net
    • 1.3.5.4 Gateway
    • 1.3.5.5 WebSphere MQ Queue Manager
    • 1.3.5.6 WebSphere MQ Application
  • 1.3.6 Gateway Structure
  • 1.3.7 Gateway Operation
  • 1.3.8 Communication

2 Release Information

• 2.1 Changes and Enhancements
  • 2.1.1 Changes and Enhancements
    • 2.1.1.1 Oracle Database Dependencies
    • 2.1.1.2 Support for Large Data Buffers
    • 2.1.1.3 DG4MQ Data Types
    • 2.1.1.4 PGM_UTL Procedures
    • 2.1.1.5 DG4MQ API Prototype Changes
    • 2.1.1.6 DG4MQ Deployment Scripts
    • 2.1.1.7 Large Payload Support
    • 2.1.1.8 Database Link and Alias Library
• 2.2 Known Problems for 11g
• 2.3 Known Restrictions for 11g

3 Requirements

• 3.1 Hardware Requirements
• 3.2 Software Requirements
• 3.3 Oracle Database

4 Preinstallation

• 4.1 Preinstallation Tasks
  • 4.1.1 WebSphere MQ Software
  • 4.1.2 Setting Environment Variables
    • 4.1.2.1 ORACLE_HOME
    • 4.1.2.2 Preventing Conflicts Between ORACLE_HOME Directories
    • 4.1.2.3 Setting ORACLE_HOME
    • 4.1.2.4 ORACLE_SID
    • 4.1.2.5 Setting ORACLE_SID
    • 4.1.2.6 DISPLAY
    • 4.1.2.7 On Server where the Installer is Running
    • 4.1.2.8 In Session on Your Workstation
    • 4.1.2.9 TMP
• 4.2 About Oracle Universal Installer
  • 4.2.1 oraInventory Directory
  • 4.2.2 Starting Oracle Universal Installer

5 Installation

• 5.1 Installation
• 5.2 Running root.sh on UNIX Based Systems

6 Removing the Gateway

• 6.1 Removing the Gateway
  • 6.1.1 About the Deinstallation Tool
  • 6.1.2 Removing Oracle Software
• 6.2 Reinstalling the gateway

7 Configuration

• 7.1 Configuration Overview
• 7.2 Configuring the Gateway
  • 7.2.1 Using the Gateway with the Default Values
  • 7.2.2 Using the Gateway Without the Default Values
  • 7.2.3 Changing Default Values
    • 7.2.3.1 Step 1: Choose a System ID for the Gateway
    • 7.2.3.2 Step 2: Customize the Gateway Initialization File
• 7.3 Configuring Oracle Net for the Gateway
  • 7.3.1 Using Oracle Net with Default Gateway Values
  • 7.3.2 Using Oracle Net When Changing the Default Gateway Values
    • 7.3.2.1 Step 1: Configure the Oracle Net Oracle Net Listener for the Gateway
    • 7.3.2.2 Step 2: Stop and Start the Oracle Net Listener for the Gateway
• 7.4 Configuring Oracle Net for Oracle Database
  • 7.4.1 Using Default Gateway Values
  • 7.4.2 Changing Default Gateway Values
    • 7.4.2.1 TCP/IP Example
    • 7.4.2.2 IPC Example
• 7.5 Creating a Transaction Log Queue
• 7.6 Administering the Database Links Alias Library
  • 7.6.1 Using Database Links
  • 7.6.2 Creating Database Links
  • 7.6.3 Dropping Database Links
  • 7.6.4 Examining Available Database Links
  • 7.6.5 Limiting the Number of Active Database Links
  • 7.6.6 Creating Alias Library
  • 7.6.7 Dropping Alias Library
• 7.7 Installing the Oracle Visual Workbench Repository
  • 7.7.1 Preinstallation Tasks
    • 7.7.1.1 Step 1: Choose a Repository Server
    • 7.7.1.2 Step 2: Locate the Installation Scripts
    • 7.7.1.3 Step 3: Upgrade the Visual Workbench Repository
    • 7.7.1.4 Step 4: Ensure that the UTL_RAW Package is Installed
    • 7.7.1.5 Step 5: Ensure that the DBMS_OUTPUT Package is Enabled
    • 7.7.1.6 Step 6: Create a Database Link
  • 7.7.2 Visual Workbench Repository Installation Tasks
    • 7.7.2.1 Step 1: Enter the Database Connection Information
    • 7.7.2.2 Step 2: Check for Existing Workbench Repository
    • 7.7.2.3 Step 3: Check for The Required PL/SQL Packages
    • 7.7.2.4 Step 4: Install the UTL_PG Package
    • 7.7.2.5 Step 5: Create the Administrative User and All Repository Tables
    • 7.7.2.6 Step 6: Create Public Synonyms and Development Roles
  • 7.7.3 After the Repository is Created
  • 7.7.4 Deinstall the Visual Workbench Repository
    • 7.7.4.1 Step 1: Enter the Database Connection Information
    • 7.7.4.2 Step 2: Check for the Existing Workbench Repository
• 7.8 Preparing the Production Oracle Database
  • 7.8.1 Introduction
  • 7.8.2 Verifying and Installing PL/SQL Packages
  • 7.8.3 Removing the PL/SQL Packages

8 Gateway Running Environment

• 8.1 Security Models
  • 8.1.1 Relaxed Model
  • 8.1.2 Strict Model
    • 8.1.2.1 Authorization Process for a WebSphere MQ Server Application
    • 8.1.2.2 Authorization Process for a WebSphere MQ Client Application
  • 8.1.3 Authorization for WebSphere MQ Objects
• 8.2 Transaction Support
  • 8.2.1 Non-Oracle Data Sources and Distributed Transactions
  • 8.2.2 Transaction Capability Types
  • 8.2.3 Transaction Capability Types of Oracle Database Gateway for WebSphere MQ
    • 8.2.3.1 Single-Site Transactions
    • 8.2.3.2 Commit-Confirm Transactions
• 8.3 Troubleshooting
  • 8.3.1 Message and Error Code Processing
    • 8.3.1.1 Interpreting Gateway Messages
  • 8.3.2 Common Error Codes
  • 8.3.3 Gateway Tracing
    • 8.3.3.1 LOG_DESTINATION Parameter
  • 8.3.4 Verifying Gateway Operation

A The PGM, PGM_UTL8, and PGM_SUP Packages

• A.1 PGM Package, DG4MQ Gateway Procedures, and Data Type Definitions
  • A.1.1 Summary of Procedures and Type Definitions
  • A.1.2 Procedure Conventions
  • A.1.3 MQI Calls Performed by the Gateway
  • A.1.4 Unsupported MQI Calls
  • A.1.5 Migration Tips
• A.2 MQCLOSE Procedure
• A.3 MQGET Procedure
  • A.3.1 PGM.MQMD Type Definition
  • A.3.2 PGM.MQGMO Type Definition
• A.4 MQOPEN Procedure
  • A.4.1 PGM.MQOD Type Definition
• A.5 MQPUT Procedure
  • A.5.1 PGM.MQPMO Type Definition
• A.6 PGM_SUP Package
  • A.6.1 PGM.MQGMO Values
    • A.6.1.1 OPTIONS Field
    • A.6.1.2 VERSION Field
    • A.6.1.3 MATCHOPTIONS Field
    • A.6.1.4 WAITINTERVAL
  • A.6.2 PGM.MQMD Values
    • A.6.2.1 CODEDCHARSETID Field
    • A.6.2.2 ENCODING Field
    • A.6.2.3 ENCODING Field, Values for Binary Integers
    • A.6.2.4 ENCODING Field, Values for Floating Point Numbers
    • A.6.2.5 ENCODING Field, Mask Values
    • A.6.2.6 ENCODING Field, Values for Packed Decimal Integers
    • A.6.2.7 EXPIRY Field
    • A.6.2.8 FEEDBACK Field
    • A.6.2.9 FORMAT Field
    • A.6.2.10 MSGTYPE Field
    • A.6.2.11 PERSISTENCE Field
    • A.6.2.12 PRIORITY Field
    • A.6.2.13 PUTAPPLTYPE Field
    • A.6.2.14 REPORT Field
    • A.6.2.15 VERSION Field
    • A.6.2.16 Report Field, Mask Values
  • A.6.3 PGM.MQOD Values
    • A.6.3.1 OBJECTTYPE Field
    • A.6.3.2 OBJECTTYPE Field, Extended Values
    • A.6.3.3 VERSION Field
  • A.6.4 PGM.MQPMO Values
    • A.6.4.1 OPTIONS Field
    • A.6.4.2 VERSION Field
  • A.6.5 MQCLOSE Values
    • A.6.5.1 hobj Argument
    • A.6.5.2 options Argument
  • A.6.6 MQOPEN Values
    • A.6.6.1 options Argument
  • A.6.7 Maximum Lengths for Fields of PGM Type Definitions
  • A.6.8 Error Code Definitions

B UTL_RAW Package

• B.1 Message Data Types
• B.2 UTL_RAW Functions
  • B.2.1 UTL_RAW.TO_RAW
  • B.2.2 UTL_RAW.BIT_AND
  • B.2.3 UTL_RAW.BIT_COMPLEMENT
  • B.2.4 UTL_RAW.BIT_OR
  • B.2.5 UTL_RAW.BIT_XOR
  • B.2.6 UTL_RAW.CAST_TO_RAW
  • B.2.7 UTL_RAW.CAST_TO_VARCHAR2
  • B.2.8 UTL_RAW.COMPARE
  • B.2.9 UTL_RAW.CONCAT
  • B.2.10 UTL_RAW.CONVERT
  • B.2.11 UTL_RAW.COPIES
  • B.2.12 UTL_RAW.LENGTH
  • B.2.13 UTL_RAW.OVERLAY
  • B.2.14 UTL_RAW.REVERSE
  • B.2.15 UTL_RAW.SUBSTR
  • B.2.16 UTL_RAW.TRANSLATE
  • B.2.17 UTL_RAW.TRANSLITERATE
  • B.2.18 UTL_RAW.XRANGE

C Gateway Initialization Parameters

• C.1 Gateway Initialization File
• C.2 Gateway Parameters
  • C.2.1 LOG_DESTINATION
  • C.2.2 AUTHORIZATION_MODEL
  • C.2.3 QUEUE_MANAGER
  • C.2.4 TRACE_LEVEL
  • C.2.5 TRANSACTION_LOG_QUEUE
  • C.2.6 TRANSACTION_MODEL
  • C.2.7 TRANSACTION_RECOVERY_PASSWORD
  • C.2.8 TRANSACTION_RECOVERY_USER

Index