Skip Headers
Oracle Procedural Gateway® for WebSphere MQ Installation and User's Guide
10g Release 2 (10.2) for UNIX

Part Number B16215-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  I  K  L  M  O  P  Q  R  S  T  U  V  W 

A

administrative user, creating, 7.7.2.5
authorization for WebSphere MQ objects, 8.1.3
AUTHORIZATION_MODEL parameter, 7.6.2

B

Bourne shell
DISPLAY, 4.1.2.6
ORACLE_HOME, 4.1.2.2, 4.1.2.3
TMP, 4.1.2.8
buttons
cancel, 6.1.2
close, 6.1.2
deinstall products, 6.1.2
help, 6.1.2, 6.1.2
installed products, 6.1.2
location, 6.1.2
no, 6.1.2
remove, 6.1.2
save as, 6.1.2
yes, 6.1.2

C

C shell
DISPLAY, 4.1.2.6
ORACLE_HOME, 4.1.2.2, 4.1.2.3, 4.1.2.4
TMP, 4.1.2.8
changes in this release
Oracle server dependencies, 2.1.1.1
choosing a repository server, 7.7.1.1
closing a queue, A.2
commit-confirm transactions, 8.2.3.2
configuring
gateway, 7.2
Oracle Net, 7.3
with default values, 7.2.1
without default values, 7.2.2
constant definitions for PGM package, A.6
CREATE DATABASE LINK statement, 7.6.2
ORA-29400, 8.3.2
Strict model, 8.1.2
creating
a database link, 7.6.2
the administrative user, 7.7.2.5
creating alias library, 7.6.4

D

data dictionary
checked by pgvwbrepos.sql script, 7.7.2.2
database link
behavior, 7.6
creating, 7.6.2
determining available links, 7.6.3
DBMS_OUTPUT package, 7.7.1.4, 7.7.2.3, 7.8.1, 7.8.2
DBMS_PIPE package, 7.7.2.3, 7.8.1, 7.8.2
default values
changing during configuration, 7.2.3
deinstall
the Visual Workbench repository, 7.7.4
deinstallation, 6.1
Oracle Discoverer 4i Viewer, 6.1.1
using Oracle Universal Installer, 6.2
DESCRIBE statement, 7.7.1.3, 7.7.1.4
directories
/tmp, 4.1.2.8
directory, script file, 7.7.1.2
DISPLAY, 4.1.2.5
distributed transactions
commit-confirm, 8.2.3.2
recovery requirements, 7.5
dropping alias library, 7.6.5

E

environment variable
MCAUSER, 8.1.2.2
MQ_PASSWORD, 8.1.2.2
MQ_USER_ID, 8.1.2.2
error
error codes, WebSphere MQ, 8.3.1
ORA-29400, 8.3.1
errors
common errors, 8.3.2
common WebSphere MQ errors, 8.3.2
from Oracle server, 8.3.1
from WebSphere MQ, 8.3.1
gateway message format, 8.3.1.1

F

file
default gateway initialization file, 7.2.3.2
file transfer program, 7.7.1.2
function
UTL_RAW.BIT_AND, B.2.2
UTL_RAW.BIT_COMPLEMENT, B.2.3
UTL_RAW.BIT_OR, B.2.4
UTL_RAW.BIT_XOR, B.2.5
UTL_RAW.CAST_TO_RAW, B.2, B.2.6
UTL_RAW.CAST_TO_VARCHAR2, B.2, B.2.7
UTL_RAW.COMPARE, B.2.8
UTL_RAW.CONCAT, B.2, B.2.9
UTL_RAW.CONVERT, B.2.10
UTL_RAW.COPIES, B.2.11
UTL_RAW.LENGTH, B.2.12
UTL_RAW.OVERLAY, B.2.13
UTL_RAW.REVERSE, B.2.14
UTL_RAW.SUBSTR, B.2.15
UTL_RAW.TRANSLATE, B.2.16
UTL_RAW.TRANSLITERATE, B.2.17
UTL_RAW.XRANGE, B.2.18

G

gateway
advantages, 1.3.3
components, 1.3.4
configured with default values, 7.2.1
configured without default values, 7.2.2
default SIDs, 7.2
description, 1.3
directories, 1.3.6
error message format, 8.3.1.1
initialization file, 1.3.2, 7.1
authorization model, 8.1
default, 7.2.3.2
gateway parameters, C.1
with commit-confirm, 8.2.3.2
with transaction log queue, 7.5
known problems and restrictions, 2.2
PGM package, A.1
retrieving messages from a queue, A.3
running environment, 8
security models, 8.1
SID, 7.2.3.1
starting, 1.3.7
structure, initialization file, 1.3.6
terms, 1.3.2
tracing, 8.3.3, C.2.4
using Visual Workbench, 1.3.1
verifying that it works, 8.3.4
Gateway Ininialization File
passwords in, C.2.7

I

initialization file
customizing, 7.2.3.2
default file name, 7.2.3.2
gateway, 1.3.2, 7.1
authorization model, 8.1
default, 7.2.3.2
parameters, C.1
with commit-confirm, 8.2.3.2
with transaction log queue, 7.5
gateway structure, 1.3.6
initsid.ora file, C.1
customizing the gateway initialization file, 7.2.3.2
installation log files, 4.2.1, 4.2.1
installation scripts, 7.7.1.2
installing
the repository, 7.7
IPC protocol, 7.3.2.1, 7.4.2.2

K

Korn shell
DISPLAY, 4.1.2.6
ORACLE_HOME, 4.1.2.2, 4.1.2.3
TMP, 4.1.2.8

L

listener.ora file, 7.3, 7.3.2.1
for IPC adapter, 7.3.2.1
for TCP/IP adapter, 7.3.2.1
LOG_DESTINATION parameter, 8.3.3, C.2.4

M

MCAUSER environment variable, 8.1.2.2
message queue interface
See MQI, 1.2.1
message queues, definition, 1.2.1
message queuing, description, 1.1
migration tips
PGM package and PG4MQ procedures, A.1.5
MIP
data profiles, B.1
description, 1.3.1, 1.3.2
PGM package, A
PGM_SUP package, A
UTL_RAW functions, B.1
MQ_PASSWORD environment variable, 8.1.2.2
MQ_USER_ID environment variable, 8.1.2.2
MQCLOSE procedure, A.6.5
description, A.2
MQGET procedure
retrieving short messages, A.3
MQI
definition, 1.2.1
gateway calls and structures, A.1
MQBACK, A.1.3
MQCMIT, A.1.3
MQCONN, A.1.3
MQDISC, A.1.3
MQINQ, A.1.4
MQPUT1, A.1.4
MQSET, A.1.4
MQOPEN procedure
description, A.4
opening a queue, A.4
MQPUT procedure
sending short messages, A.5

O

opening a queue, A.4
ORA-08500 error, 8.3.1
Oracle Application Server
preinstallation tasks, 4.1
reinstallation, 6.2
Oracle applications, 1.3.5.1
Oracle Developer, 1.3.3
Oracle Financials, 1.3.3
Oracle Net
configuring for Oracle server, 7.4
Oracle Procedural Gateway for Message Queuing Visual Workbench
See Visual Workbench, 1.3.1
Oracle server
connected to gateway, 1.3.5.2
error messages, 8.3.1
Oracle server dependencies, 2.1.1.1
Oracle Universal Installer, 4.2.1, 4.2.1, 4.2.2
mounting CD-ROM, 4.2.2
mounting manually, 4.2.2
overview, 4.2
starting, 4.2.2
ORACLE_HOME, 4.1.2.1
Bourne shell, 4.1.2.2, 4.1.2.3
C shell, 4.1.2.2, 4.1.2.3, 4.1.2.4
Korn shell, 4.1.2.2, 4.1.2.3
preventing conflicts, 4.1.2.2
oraInventory directory, 4.2.1, 4.2.1, 4.2.1, 4.2.1
location, 4.2.1
overview
Oracle Universal Installer, 4.2

P

package
DBMS_OUTPUT, 7.7.1.4, 7.7.2.3, 7.8.1, 7.8.2
DBMS_PIPE, 7.7.2.3, 7.8.1, 7.8.2
PGM_BQM, 7.7.2.5, 7.8.1, 7.8.2
PGM_SUP, 7.7.2.5, 7.8.1, 7.8.2, A.6
PL/SQL, 7.8.1, 7.8.2, 7.8.3
UTL_PG, 7.7.2.4, 7.8.1, 7.8.2
UTL_RAW, 7.7.1.3, 7.7.2.3, 7.8.1, 7.8.2
parameter
AUTHORIZATION_MODEL, 7.6.2
LOG_DESTINATION, 8.3.3, C.2.4
QUEUE_MANAGER, C.2.3
TRACE_LEVEL, 8.3.3, C.2.4
TRANSACTION_LOG_QUEUE, 8.2.3.2, C.2.5
TRANSACTION_MODEL, 7.5, C.2.6
TRANSACTION_RECOVERY_PASSWORD, 8.2.3.2, C.2.7
TRANSACTION_RECOVERY_USER, 8.2.3.2, C.2.8
pg4mqpwd utility
using, C.2.7
PGM package
description, A.1
error code definitions, A.6.8
unsupported MQI calls, A.1.4
PGM_BQM package, 7.7.2.5, 7.8.1, 7.8.2
PGM_SUP package, 7.7.2.5, 7.8.1, 7.8.2
description, A.6
PGM8.MQOPEN procedure
error condition 2085, 8.3.2
PGMADMIN, 7.7.2.5, 7.7.4.1
pgmdeploy8.sql script, 7.8.1
PGMDEV role, 7.7.3
PGM.MQGMO type definition
description, A.3.2
PGM_SUP constants, A.6.1
PGM.MQMD type definition, A.3.1
PGM_SUP constants, A.6.2
PGM.MQOD type definition
PGM_SUP constants, A.6.3
PGM.MQOPEN procedure
error condition 2085, 8.3.2
PGM_SUP constants, A.6.6
PGM.MQPMO type definition
description, A.5.1
PGM_SUP constants, A.6.4
pgmundeploy.sql script, 7.8.1
pgvwbremove9.sql script, 7.7.4
pgvwbrepos9.sql script, 7.7.2, 7.7.3
PL/SQL
installing missing packages, 7.8.1
package, 7.8.1, 7.8.2, 7.8.3
removing packages, 7.8.3
verifying packages exist, 7.8.1
preinstallation
environment variables, 4.1.2
DISPLAY, 4.1.2.5
TMP, 4.1.2.8
private access privileges, 7.7.2.6
private repository, 7.7.4.2
privileges, private access, 7.7.2.6
privileges, public access, 7.7.2.6
procedural gateway
database link for access, 7.7.1.5
procedure
MQCLOSE, A.2, A.6.5
MQGET, A.3
MQOPEN, A.4, A.4
MQPUT, A.5
PGM8.MQOPEN, 8.3.2
PGM.MQOPEN, 8.3.2, A.6.6
program
file transfer, 7.7.1.2
protocol
IPC, 7.3.2.1, 7.4.2.2
prvtrawb.plb script, 7.7.1.3
public access privileges, 7.7.2.6

Q

queue
closing, A.2
opening, A.4
QUEUE_MANAGER parameter, C.2.3

R

reinstallation
Oracle Application Server, 6.2
related documentation, 3.4
relaxed security model, defined, 8.1.1
Remote Procedure Call (RPC), 1.3
repository
choosing a server, 7.7.1.1
deinstall, 7.7.4
development privileges, 7.7.3
installation scripts, 7.7.1.2
installing, 7.7
installing the repository, 7.7
private, 7.7.4.2
server, definition, 7.7.1.1
requirements
hardware, 3.1
software, 3.2
retrieving messages
shorter than 32 767 bytes, A.3
role
PGMDEV, 7.7.3
root.sh script, 5.2

S

script
file directory, 7.7.1.2
pgmdeploy8.sql, 7.8.1
pgmundeploy.sql, 7.8.1
pgvwbremove9.sql, 7.7.4
pgvwbrepos9.sql, 7.7.2, 7.7.3
prvtrawb.plb, 7.7.1.3
test.sql, 8.3.4
utlraw.sql, 7.7.1.3
sending messages
shorter than 32 767 bytes, A.5
setting
DISPLAY, 4.1.2.5
TMP, 4.1.2.8
SID
default values, 7.2
description, 7.2
length, 7.2.3.1
single-site transactions, 8.2.3.1
software requirements, 3.2
SQL*Net
configuring, 7.3
configuring for gateway, 7.3
purpose, 1.3.5.3
starting, 4.2.2
Oracle Universal Installer, 4.2.2, 4.2.2
statement
CREATE DATABASE LINK, 7.6.2
ORA-29400, 8.3.2
Strict model, 8.1.2
DESCRIBE, 7.7.1.3, 7.7.1.4
strict security model
defined, 8.1.2
running root.sh, 5.2
system ID
See SID, 7.2

T

TCP/IP protocol, 7.3.2.1, 7.4.2.1
test.sql script, 8.3.4
TMP, 4.1.2.8
TNS listener, 7.3
checking status, 7.3.2.2
starting, 7.3.2.2
stopping, 7.3.2.2
tnsnames.ora file, 7.4
trace feature, 8.3.3
TRACE_LEVEL parameter, 8.3.3, C.2.4
transaction capability types
description, 8.2.2
transaction levels
commit-confirm, 8.2.3.2
single-site, 8.2.3.1
transaction log queue
creating, 7.5
TRANSACTION_LOG_QUEUE parameter, 8.2.3.2, C.2.5
TRANSACTION_MODEL parameter, 7.5, C.2.6
TRANSACTION_RECOVERY_PASSWORD parameter, 8.2.3.2, C.2.7
TRANSACTION_RECOVERY_USER parameter, C.2.8
TRANSACTION_RECOVERY_USER parameters, 8.2.3.2
triggers
WebSphere MQ, 1.2.1

U

UTL_PG package, 7.7.2.4, 7.8.1, 7.8.2
UTL_RAW package, 7.7.1.3, 7.7.2.3, 7.8.1, 7.8.2
example of using functions, B.2
function syntax, B.2
UTL_RAW.BIT_AND function, B.2.2
UTL_RAW.BIT_COMPLEMENT function, B.2.3
UTL_RAW.BIT_OR function, B.2.4
UTL_RAW.BIT_XOR function, B.2.5
UTL_RAW.CAST_TO_RAW function, B.2, B.2.6
UTL_RAW.CAST_TO_VARCHAR2 function, B.2, B.2.7
UTL_RAW.COMPARE function, B.2.8
UTL_RAW.CONCAT function, B.2, B.2.9
UTL_RAW.CONVERT function, B.2.10
UTL_RAW.COPIES function, B.2.11
UTL_RAW.LENGTH function, B.2.12
UTL_RAW.OVERLAY function, B.2.13
UTL_RAW.REVERSE function, B.2.14
UTL_RAW.SUBSTR function, B.2.15
UTL_RAW.TRANSLATE function, B.2.16
UTL_RAW.TRANSLITERATE function, B.2.17
UTL_RAW.XRANGE function, B.2.18
utlraw.sql script, 7.7.1.3

V

variable
environment
MCAUSER, 8.1.2.2
MQ_PASSWORD, 8.1.2.2
MQ_USER_ID, 8.1.2.2
Visual Workbench
deinstall repository, 7.7.4
description, 1.3.1
development privileges for repository, 7.7.3
installing the repository, 7.7
MIP, A

W

WebSphere MQ
access authorization, 8.1.3
client configuration definition, 1.2.1
common error messages, 8.3.2
description, 1.2
error codes, 8.3.1
queue manager definition, 1.2.1
triggers, 1.2.1
WebSphere MQ server, 1.3.5.5