Oracle Streams Data Dictionary for Propagations → available to a propagation, Oracle automatically populates a multiversioned Oracle Streams data … dictionary at each database that has an Oracle Streams propagation. Oracle automatically sends internal … propagated by a propagation. Which Oracle Streams data dictionary information to propagate depends on … the rule set s for the
Managing Queues → ANYDATA queue, and each Oracle Streams propagation is associated with one ANYDATA source queue and
Enabling a User to Perform Operations on a Secure Queue → For a user to perform queue operations, such as enqueue and dequeue, on a secure queue, the user must be configured as a secure queue user of the queue. If you use the SET_UP_QUEUE procedure in the DBMS_STREAMS_ADM package to create the secure queue, then the queue owner and the user specified by the queue_user parameter are configured as secure users of the queue automatically. If you want to enable
Disabling a User from Performing Operations on a Secure Queue → You might want to disable a user from performing queue operations on a secure queue for the following reasons: You dropped a capture process or a synchronous capture, but you did not drop the queue that was used by the capture process or synchronous capture, and you do not want the user who was the capture user to be able to perform operations on the remaining secure queue. You dropped an apply process,
Dropping a Propagation → propagation. For example, the following procedure drops a propagation named strm01_propagation: BEGIN … drops any rule set s used by the propagation strm01_propagation, unless a rule set is used by another … positive rule set and negative rule set for the propagation might be dropped. If this procedure drops a
Scheduling a Propagation → ) throws JMSException This method schedules a propagation. It has the following parameters: Parameter … Description session JMS session destination Database link of the remote database for which propagation … is being scheduled. A string means that propagation is scheduled for all subscribers in the … database of the topic. start_time
DBA_QUEUE_SCHEDULES: All Propagation Schedules → The DBA_QUEUE_SCHEDULES view describes all the current schedules in the database for propagating messages.
JMS Outbound Propagation → propagation of messages from that queue does not continue until the message is removed.
Scheduling a Queue Propagation → schedules propagation of messages. The destination can be identified by a database link in the destination … results in queue-to-dblink propagation. If you propagate messages to several queues in another … link. Specifying the destination queue name results in queue-to-queue propagation was introduce in … another database, queue-to-queue
Altering a Propagation Schedule → , destination_queue IN VARCHAR2 DEFAULT NULL); This procedure alters parameters for a propagation … schedule. The destination_queue parameter for queue-to-queue propagation cannot be altered. Example 8 … -52 Altering a Propagation Schedule to Queues in the Same Database BEGIN … /86400', latency => '32'); END; / Example 8-53 Altering
Propagation Tuning Tips → Propagation can be considered a special kind of dequeue operation with an additional INSERT at the … remote (or local) queue table. Propagation from a single schedule is not parallelized across … of propagation schedules according to the available system resources (CPUs). Propagation rates from … transactional
Enhanced Propagation Scheduling Capabilities → Catalog views defined for propagation provide the following information about active schedules … handling the propagation Instance handling a schedule (if using Oracle RAC) Previous successful … execution of a schedule Next planned execution of a schedule The following propagation statistics are … propagated a message Propagation
Unscheduling a Propagation → JMSException This method unschedules a previously scheduled propagation. It has the following … . A string means that propagation is to the local database. Example 12-32 Unscheduling a … Propagation TopicSession t_sess; Topic topic; ((AQjmsDestination)topic).unschedulePropagation(t_sess, \"dbs1\");
Enabling a Propagation Schedule → propagation schedule. Example 8-54 Enabling a Propagation to Queues in the Same Database BEGIN … a Propagation to Queues in Another Database BEGIN DBMS_AQADM.ENABLE_PROPAGATION_SCHEDULE( queue_name => 'test.multiconsumer_queue', destination => 'another_db.world'); END; /
Exception Handling During Propagation → reverified. If you have capped the number of job queue processes and propagation remains busy, then … queue-to-queue propagation, propagation stops and throws an error. In such situations you must query … the DBA_SCHEDULES view to determine the last error that occurred during propagation to a particular destination.
TIB/Rendezvous Inbound Propagation → If no propagation transformation is provided for inbound propagation, then the Oracle Streams … propagation transformation is specified, then the target ADT of the transformation can be any ADT supported … subject name is usually the same as the subject name of the registered propagation source queue
JMS Inbound Propagation → is necessary prior to enqueuing using Oracle JMS. However, if the payload ADT of the propagation
Verifying Propagation Queue Type → DBMS_AQADM.VERIFY_QUEUE_TYPES( src_queue_name IN VARCHAR2, dest_queue_name IN VARCHAR2, destination IN VARCHAR2 DEFAULT NULL, rc OUT BINARY_INTEGER); This procedure verifies that the source and destination queues have identical types. The result of the verification is stored in the dictionary table SYS.AQ$_MESSAGE_TYPES, overwriting all previous output of this command. If the source and destination
Unscheduling a Queue Propagation → propagation of messages from a queue to a destination. The destination is identified by a specific … Unscheduling a Propagation to Queues in the Same Database BEGIN DBMS_AQADM.UNSCHEDULE_PROPAGATION … ( queue_name => 'test.multiconsumer_queue'); END; / Example 8-59 Unscheduling a Propagation to Queues in
Handling Failures in Propagation → message propagation include the following: Database link failed Remote database is not available Remote … the DBA_QUEUE_SCHEDULES view. When an error occurs in a schedule, propagation of messages in that
Disabling a Propagation Schedule → propagation schedule. Example 8-56 Disabling a Propagation to Queues in the Same Database BEGIN … Disabling a Propagation to Queues in Another Database BEGIN DBMS_AQADM.DISABLE_PROPAGATION_SCHEDULE
Message Propagation Between Queues → You can use Oracle Streams to configure message propagation between two queue s. These queues can … propagate messages. A propagation is always between a source queue and a destination queue. Although … propagation is always between two queues, a single queue can participate in many propagations. That … propagation
Enabling a Propagation Schedule → ) throws JMSException This method enables a propagation schedule. It has the following parameters … string means that propagation is to the local database. Example 12-29 Enabling a Propagation Schedule
WebSphere MQ Outbound Propagation → If no message transformation is provided for outbound propagation, then the Oracle Streams Advanced
TIB/Rendezvous Outbound Propagation → If no propagation transformation is provided for outbound propagation, then the Oracle Streams … Advanced Queuing source queue payload type must be either SYS.MGW_TIBRV_MSG_T or RAW. If a propagation
Resetting a Propagation Job → When a problem occurs with a propagation job, the Messaging Gateway agent retries the failed … operation up to 16 times in an exponential backoff scheme before the propagation job stops. You can use … operation immediately. Example 19-21 resets the failure count for propagation job job_aq2mq. Example 19-21 … Resetting a Propagation
Propagation Job Overview → A propagation job specifies what messages are propagated and how the messages are propagated … . Messaging Gateway allows bidirectional message propagation. An outbound propagation moves messages from … Oracle Streams Advanced Queuing to non-Oracle messaging systems. An inbound propagation moves … messages from
Removing a Propagation Job → You can remove a Messaging Gateway propagation job by calling DBMS_MGWADM. REMOVE_JOB. Before … removing the propagation job from the Messaging Gateway configuration, Messaging Gateway does the … by Messaging Gateway Removes propagation log records from log queues for the job being removed … propagation job being
Propagation Processing Overview → Propagation jobs must be defined in order for messages to be propagated from one messaging system … to another. A propagation job defines the source queue, destination queue, and various other … attributes that affect the processing of the propagation job. If the propagation source is a queue (point-to … propagation
Altering a Propagation Schedule → method alters a propagation schedule. It has the following parameters: Parameter Description … session JMS session destination Database link of the remote database for which propagation is being … scheduled. A string means that propagation is scheduled for all subscribers in the database of the … topic. duration Duration of propagation
Disabling a Propagation Schedule → ) throws JMSException This method disables a propagation schedule. It has the following parameters … string means that propagation is to the local database. Example 12-31 Disabling a Propagation
Altering a Propagation Job → After a propagation job is created you can alter the selection rule, transformation, exception … propagation job. Example 19-22 Altering Propagation Job by Adding an Exception Queue BEGIN … the polling interval for a propagation job. The polling interval determines how soon the agent can … discover the available
Security Required for Propagation → Oracle Streams Advanced Queuing propagates messages through database links. The propagation driver … no explicit Oracle Streams Advanced Queuing privileges must be granted. See Also: \"Propagation from Object Queues\"
Propagation from Object Queues → Propagation from object queues with BFILE objects is supported. To be able to propagate object … database. AQ propagation does not support non-final types. Propagation of BFILE objects from object queues
WebSphere MQ Inbound Propagation → If no message transformation is provided for inbound propagation, then the Oracle Streams Advanced
propagation → Copying messages from one queue to another (local or remote) queue.
propagation → An optional Oracle Streams client that uses an Oracle Scheduler job to send message s from a source queue to a destination queue.
3 Oracle Streams Staging and Propagation → propagating messages from one queue to another: Introduction to Message Staging and Propagation Queues … Message Propagation Between Queues See Also: Chapter 16, \"Managing Staging and Propagation … \" \"Monitoring Queues and Messaging\" \"Monitoring Oracle Streams Propagations and Propagation Jobs\" Chapter 32, \"Troubleshooting
Persistent Queues and Buffered Queues → $_ queue_table_name _d table about any propagation s and apply process es that are eligible for processing the … apply processes, messaging clients, applications, and users. Queues and Propagations A propagation … a buffered queue or in a persistent queue. A propagation can propagate both types of messages if … the messages satisfy
Queue-to-Queue Propagations → A propagation can be queue-to-queue or queue-to-database link (queue-to-dblink). A queue-to-queue … propagation always has its own exclusive propagation job to propagate message s from the source queue … to the destination queue. Because each propagation job has its own propagation schedule, the