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_MODEL parameter 7.6.2
• authorization for WebSphere MQ objects 8.1.3

---

B

• Bourne shell
  • DISPLAY 4.1.2.3.1
  • ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • TMP 4.1.2.4

---

C

• changes in this release
  • Oracle database dependencies 2.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
• C shell
  • DISPLAY 4.1.2.3.1
  • ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • TMP 4.1.2.4

---

D

• 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
• data dictionary
  • checked by pgvwbrepos.sql script 7.7.2.2
• 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
• directory, script file 7.7.1.2
• DISPLAY 4.1.2.3
• 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
• 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.3.1
  • ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • TMP 4.1.2.4

---

L

• limiting database links 7.6.5
• listener.ora file 7.3, 7.3.2.1
  • for IPC 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_SUP package A
  • PGM 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_HOME 4.1.2.1
  • Bourne shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • C shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • Korn shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
  • preventing conflicts 4.1.2.1.1
• Oracle applications 1.3.5.1
• Oracle Application Server
  • preinstallation tasks 4.1
• Oracle database
  • connected to gateway 1.3.5.2
  • error messages 8.3.1
• Oracle database dependencies 2.1.1
• Oracle Database Gateway for WebSphere MQ
  • reinstallation 6.2
• 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.2
  • overview 4.2
  • starting 4.2.2
• oraInventory directory 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_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
• 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
• PGM8.MQOPEN procedure
  • error condition 2085 8.3.2
• PGMADMIN 7.7.2.5, 7.7.4.1
• PGMDEV role 7.7.3
• PGM package
  • error code definitions A.6.8
  • unsupported MQI calls A.1.4
• pgvwbrepos9.sql script 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.3
    • TMP 4.1.2.4
• 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
  • MQPUT A.5
  • PGM.MQOPEN 8.3.2, A.6.6
  • PGM8.MQOPEN 8.3.2
• program
  • file transfer 7.7.1.2
• protocol
  • IPC 7.3.2.1, 7.4.2.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 Database Gateway for WebSphere MQ 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
  • prvtrawb.plb 7.7.1.4
  • test.sql 8.3.4
• sending messages
  • shorter than 32 767 bytes A.5
• setting
  • DISPLAY 4.1.2.3
  • TMP 4.1.2.4
• 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
• 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.4
• tnsnames.ora file 7.4
• TRACE_LEVEL parameter 8.3.3, C.2.4
• trace feature 8.3.3
• 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
• 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
• 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.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
• 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

---

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