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