Oracle9i Messaging Gateway Supplement -- Index

administration

Messaging Gateway, 1-3

See also DBMS_MGWADM package

administration user

creating, 2-7

example, 2-7

agent. See gateway agent

agent user

creating, 2-8

example, 2-8

altering

messaging gateway links, 3-6

registered non-Oracle queues, 3-8

schedules, 3-11

subscribers, 3-11

AQ queues

registering, 3-9

checking

listener.ora file, 2-4

configuring

connection information, 2-8

messaging gateway links, 3-4

propagation jobs, 3-9

See DBMS_MGWADM.DB_CONNECT_INFO procedure

connection information

configuring, 2-8

example, 3-2

constants

DBMS_MGWADM package, 5-7

DBMS_MGWMSG package, 6-8

creating

administration user, 2-7

agent user, 2-8

messaging gateway links, 3-4

schedules, 3-10

subscribers, 3-9

database objects

loading, 2-4

DBMS_MGWADM package, 1-3, 5-1

constants, 5-7

methods, 5-2

object types, 5-2

summary of subprograms, 5-12

DBMS_MGWADM.DB_CONNECT_INFO procedure

configuring Messaging Gateway, 3-2

example, 2-8

DBMS_MGWMSG package, 6-1

constants, 6-8

methods, 6-2

object types, 6-2

summary of subprograms, 6-9

disabling

propagation jobs, 3-10

enabling

propagation jobs, 3-10

exception queues, 3-14

gateway agent, 1-4

managing, 3-2

status information, 2-11

terminating after fatal error, 2-10

gateway links. See messaging gateway links or messaging links

installing

Messaging Gateway

checks, 2-2

prerequisites for non-Oracle messaging systems, 2-2

prerequisites for the Oracle database, 2-2

verification, 2-8

links. See messaging gateway links

listener.ora file

checking, 2-4

loading

database objects, 2-4

log file

monitoring, 3-15

managing

gateway agent, 3-2

Messaging Gateway, 3-9

administration

architecture, 1-3

functionality, 1-2

installing, 2-2

checks, 2-2

prerequisites for non-Oracle messaging systems, 2-2

prerequisites for the Oracle database, 2-2

verification, 2-8

postinstallation tasks, 2-3

subscribers

creating, 3-9

uninstalling, 2-9

Messaging Gateway agent. See gateway agent

messaging gateway links

altering, 3-6

configuring, 3-4

creating, 3-4

example, 3-7

removing, 3-6

messaging links

MQSeries, 5-10

queue properties, 5-11

methods

DBMS_MGWADM package, 5-2

DBMS_MGWMSG package, 6-2

MGW_ADMINISTRATOR_ROLE role, 3-1

mgw.ora file

example, 2-7

modifying, 2-6

modifying

mgw.ora file, 2-6

tnsnames.ora file, 2-5, 2-7

monitoring

log file, 3-15

registered non-Oracle queues, 3-9

MQSeries

messaging links, 5-10

queue properties, 5-11

non-Oracle queues

registering, 3-7

unregistering, 3-8

object types

DBMS_MGWADM package, 5-2

DBMS_MGWMSG package, 6-2

PL/SQL

functions

DBMS_MGWADM package subprograms, 5-12

DBMS_MGWMSG package subprograms, 6-9

procedures

DBMS_MGWADM package subprograms, 5-12

DBMS_MGWMSG package subprograms, 6-9

postinstallation tasks, 2-3

prerequisites

for non-Oracle messaging systems, 2-2

for the Oracle database, 2-2

propagation

processing, 1-5

propagation jobs

configuring, 3-9

disabling, 3-10

enabling, 3-10

resetting, 3-11

restarting, 3-11

protocol address

example, 2-4

queues

AQ

registering, 3-9

exception, 3-14

non-Oracle

registering, 3-7

unregistering, 3-8

registered non-Oracle queues

altering, 3-8

example, 3-9

monitoring, 3-9

registering

AQ queues, 3-9

non-Oracle queues, 3-7

removing

messaging gateway links, 3-6

resetting

propagation jobs, 3-11

restarting

propagation jobs, 3-11

schedules

altering, 3-11

creating, 3-10

selection rules, 3-12

shutdown, 3-3

SNP background processes, 2-10

startup, 3-3

static service information

example, 2-5

subscribers

altering, 3-11

creating, 3-9

tnsnames.ora file, 2-7

example, 2-5, 2-7

modifying, 2-5

transformations, 3-12

example, 3-13

troubleshooting, 2-9

uninstalling

Messaging Gateway, 2-9

unregistering

non-Oracle queues, 3-8

example, 3-8

users

administration, 2-7

agent, 2-8

views

summary, 5-33

Index

A

C

D

E

G

I

L

M

N

O

P

Q

R

S

T

U

V