Go to main content
1/16
Contents
Title and Copyright Information
Send Us Your Comments
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 Integrating Server
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
2
Release Information
2.1
Changes and Enhancements
2.1.1
Changes and Enhancements for Release 10.2.0
2.1.1.1
Oracle Server Dependencies
2.1.2
Changes and Enhancements for Release 10.2.0
2.1.2.1
Support for Large Data Buffers
2.1.2.2
PGM_UTL Procedures
2.1.2.3
PG4MQ API Prototype Changes
2.1.2.4
Heterogeneous Services Architecture
2.1.2.5
Performance Enhancements
2.1.2.6
New PG4MQ Packages
2.1.2.7
New PG4MQ Deployment Scripts
2.1.2.8
Large Payload Support
2.1.2.9
Database Link and Alias Library
2.2
Known Problems for 10
g
Release 2
2.3
Known Restrictions for 10
g
Release 2
3
Requirements
3.1
Hardware Requirements
3.2
Software Requirements
3.3
Related Documentation
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
Setting ORACLE_SID
4.1.2.5
DISPLAY
4.1.2.6
On Server where the Installer is Running
4.1.2.7
In Session on Your Workstation
4.1.2.8
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
6
Deinstallation and Reinstallation
6.1
Deinstallation
6.1.1
Deinstalling Using Oracle Universal Installer
6.1.2
Deinstalling Oracle Procedural Gateway for WebSphere MQ
6.2
Reinstallation
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 TNS Listener for the Gateway
7.3.2.2
Step 2: Stop and Start the TNS Listener for the Gateway
7.4
Configuring Oracle Net for Oracle Integrating Server
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
Examining Available Database Links
7.6.4
Creating Alias Library
7.6.5
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 4: Ensure that the UTL_RAW Package is Installed
7.7.1.4
Step 5: Ensure that the DBMS_OUTPUT Package is Enabled
7.7.1.5
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 Server
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 Procedural 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, PG4MQ 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
Scripting on this page enhances content navigation, but does not change the content in any way.