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.7
ORACLE_HOME, 4.1.2.2, 4.1.2.3, 4.1.2.5
TMP, 4.1.2.9

C

C shell
DISPLAY, 4.1.2.7
ORACLE_HOME, 4.1.2.2, 4.1.2.3, 4.1.2.5
TMP, 4.1.2.9
changes in this release
Oracle database 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.6

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.4
dropping, 7.6.3
limiting active links, 7.6.5
DBMS_OUTPUT package, 7.7.1.5, 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
using Oracle Universal Installer, 6.2
DESCRIBE statement, 7.7.1.4, 7.7.1.5
dg4pwd utility
using, C.2.7
directories
/tmp, 4.1.2.9
directory, script file, 7.7.1.2
DISPLAY, 4.1.2.6
distributed transactions
commit-confirm, 8.2.3.2
recovery requirements, 7.5
DROP DATABASE LINK statement, 7.6.3
dropping a database link, 7.6.3
dropping alias library, 7.6.7

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 database, 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.7
ORACLE_HOME, 4.1.2.2, 4.1.2.3, 4.1.2.5
TMP, 4.1.2.9

L

limiting database links, 7.6.5
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 DG4MQ 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 database
connected to gateway, 1.3.5.2
error messages, 8.3.1
Oracle database dependencies, 2.1.1.1
Oracle Developer, 1.3.3
Oracle Financials, 1.3.3
Oracle Net
configuring for Oracle database, 7.4
Oracle Net Listener, 7.3
checking status, 7.3.2.2
starting, 7.3.2.2
stopping, 7.3.2.2
Oracle Universal Installer, 4.2.1, 4.2.1, 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, 4.1.2.5
C shell, 4.1.2.2, 4.1.2.3, 4.1.2.5
Korn shell, 4.1.2.2, 4.1.2.3, 4.1.2.5
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.5, 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.4, 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
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
pgmbqm8.sql script, 7.8.2
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
pgm.sql, 7.8.2
pgmsup8.sql script, 7.8.2
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.6
TMP, 4.1.2.9
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
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
prvtpg.sql script, 7.8.2
prvtrawb.plb script, 7.7.1.4
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
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
pgmbqm8.sql, 7.8.2
pgmdeploy8.sql, 7.8.1
pgmsup8.sql, 7.8.2
pgmundeploy.sql, 7.8.1
pgvwbremove9.sql, 7.7.4
pgvwbrepos9.sql, 7.7.2, 7.7.3
prvtpg.sql, 7.8.2
prvtrawb.plb, 7.7.1.4
test.sql, 8.3.4
utlpg.sql, 7.8.2
utlraw.sql, 7.7.1.4
sending messages
shorter than 32 767 bytes, A.5
setting
DISPLAY, 4.1.2.6
TMP, 4.1.2.9
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.4, 7.7.1.5
DROP DATABASE LINK, 7.6.3
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.9
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

upgrade the Visual Workbench Repository, 7.7.1.3
UTL_PG package, 7.7.2.4, 7.8.1, 7.8.2
UTL_RAW package, 7.7.1.4, 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
utlpg.sql script, 7.8.2
utlraw.sql script, 7.7.1.4

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
Visual Workbench Repository
upgrade, 7.7.1.3

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