1/17

Contents

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 to Oracle Database Gateway for WebSphere MQ

• Introduction to Message Queuing
• Introduction to WebSphere MQ
  • WebSphere MQ Terms
• Introduction to the Gateway
  • Developing Gateway Applications
  • Gateway Terms
  • Advantages of Using the Gateway
  • Gateway Architecture
  • Component Descriptions
    • Oracle Applications
    • Oracle Database
    • Oracle Net
    • Gateway
    • WebSphere MQ Queue Manager
    • WebSphere MQ Application
  • Gateway Structure
  • Gateway Operation
  • Communication

2 Release Information for Oracle Database Gateway for WebSphere MQ

• Changes and Enhancements
  • Oracle Database Dependencies
  • Support for Large Data Buffers
  • DG4MQ Data Types
  • PGM_UTL Procedures
  • DG4MQ API Prototype Changes
  • DG4MQ Deployment Scripts
  • Large Payload Support
  • Database Link and Alias Library
• Known Problems
• Known Restrictions

3 System Requirements for Oracle Database Gateway for WebSphere MQ

• Hardware Requirements for Oracle Database Gateway for WebSphere MQ
• Software Requirements for Oracle Database Gateway for WebSphere MQ
• Oracle Database

4 Preinstallation Information for Oracle Database Gateway for WebSphere MQ

• Preinstallation Tasks
  • WebSphere MQ 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
  • Using Windows User Account as Oracle Home User
• About Oracle Universal Installer
  • oraInventory Directory
  • Starting Oracle Universal Installer

5 Installing Oracle Database Gateway for WebSphere MQ

• Installation
• Running root.sh on UNIX Based Systems

6 Removing Oracle Database Gateway for WebSphere MQ

• Removing Oracle Database Gateway for WebSphere MQ
  • About the Deinstallation Tool
  • Removing Oracle Software
• Reinstalling Oracle Database Gateway for WebSphere MQ

7 Configuring Oracle Database Gateway for WebSphere MQ

• 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 Initialization File
• Configuring Oracle Net for the Gateway
  • Using Oracle Net with Default Gateway Values
  • Using Oracle Net When Changing the Default Gateway Values
    • Step 1: Configure the Oracle Net Oracle Net Listener for the Gateway
    • Step 2: Stop and Start the Oracle Net Listener for the Gateway
• Configuring Oracle Net for Oracle Database
  • Using Default Gateway Values
  • Changing Default Gateway Values
    • TCP/IP Example
    • IPC Example
• Creating a Transaction Log Queue
• Administering the Database Links Alias Library
  • Using Database Links
  • Creating Database Links
  • Dropping Database Links
  • Examining Available Database Links
  • Limiting the Number of Active Database Links
  • Creating Alias Library
  • Dropping Alias Library
• Installing the Oracle Visual Workbench Repository
  • Preinstallation Tasks
    • Step 1: Choose a Repository Server
    • Step 2: Locate the Installation Scripts
    • Step 3: Upgrade the Visual Workbench Repository
    • Step 4: Ensure that the UTL_RAW Package is Installed
    • Step 5: Ensure that the DBMS_OUTPUT Package is Enabled
    • Step 6: 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 The Required PL/SQL Packages
    • Step 4: Install the UTL_PG Package
    • Step 5: Create the Administrative 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 the Existing Workbench Repository
• Preparing the Production Oracle Database
  • Introduction
  • Verifying and Installing PL/SQL Packages
  • Removing the PL/SQL Packages

8 Oracle Database Gateway for WebSphere MQ Running Environment

• Security Models
  • Relaxed Model
  • Strict Model
    • Authorization Process for a WebSphere MQ Server Application
    • Authorization Process for a WebSphere MQ Client Application
  • Authorization for WebSphere MQ Objects
• Transaction Support
  • Non‐Oracle Data Sources and Distributed Transactions
  • Transaction Capability Types
  • Transaction Capability Types of Oracle Database Gateway for WebSphere MQ
    • Single-Site Transactions
    • Commit-Confirm Transactions
• Troubleshooting
  • Message and Error Code Processing
    • Interpreting Gateway Messages
  • Common Error Codes
  • Gateway Tracing
    • LOG_DESTINATION Parameter
      • Gateway:
      • Default Value:
      • Range of Values:
      • Syntax:
  • Verifying Gateway Operation

A The PGM, PGM_UTL8, and PGM_SUP Packages

• PGM Package, DG4MQ Gateway Procedures, and Data Type Definitions
  • Summary of Procedures and Type Definitions
  • Procedure Conventions
  • MQI Calls Performed by the Gateway
  • Unsupported MQI Calls
  • Migration Tips
• MQCLOSE Procedure
• MQGET Procedure
  • PGM.MQMD Type Definition
  • PGM.MQGMO Type Definition
• MQOPEN Procedure
  • PGM.MQOD Type Definition
• MQPUT Procedure
  • PGM.MQPMO Type Definition
• PGM_SUP Package
  • PGM.MQGMO Values
    • OPTIONS Field
    • VERSION Field
    • MATCHOPTIONS Field
    • WAITINTERVAL
  • PGM.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
  • PGM.MQOD Values
    • OBJECTTYPE Field
    • OBJECTTYPE Field, Extended Values
    • VERSION Field
  • PGM.MQPMO Values
    • OPTIONS Field
    • VERSION Field
  • MQCLOSE Values
    • hobj Argument
    • options Argument
  • MQOPEN Values
    • options Argument
  • Maximum Lengths for Fields of PGM Type Definitions
  • Error Code Definitions

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 Oracle Database Gateway for WebSphere MQ Initialization Parameters

• Gateway Initialization File
• Gateway Parameters
  • LOG_DESTINATION
  • AUTHORIZATION_MODEL
  • QUEUE_MANAGER
  • TRACE_LEVEL
  • TRANSACTION_LOG_QUEUE
  • TRANSACTION_MODEL
  • TRANSACTION_RECOVERY_PASSWORD
  • TRANSACTION_RECOVERY_USER

Index