Skip Headers
Oracle® Database Gateway for WebSphere MQ Installation and User's Guide
11g Release 1 (11.1)
Part Number B31286-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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 for Release 10.2.0
2.1.1.1
Oracle Database Dependencies
2.1.1.2
Support for Large Data Buffers
2.1.1.3
OG4MQ Data Types
2.1.1.4
PGM_UTL Procedures
2.1.1.5
OG4MQ API Prototype Changes
2.1.1.6
OG4MQ Deployment Scripts
2.1.1.7
Large Payload Support
2.1.1.8
Database Link and Alias Library
2.2
Known Problems for 11
g
2.3
Known Restrictions for 11
g
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.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, OG4MQ 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