Results for propagation


41 to 80 of 931 results. Prev  Next
Results per page:  20 |  40  | 60


Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Propagation Concepts

Oracle Streams Data Dictionary for Propagationsavailable 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

Streams Concepts and Administration, 11g Release 2 (11.2)

Managing Staging and Propagation

Managing QueuesANYDATA queue, and each Oracle Streams propagation is associated with one ANYDATA source queue and

Streams Concepts and Administration, 11g Release 2 (11.2)

Managing Staging and Propagation

Enabling a User to Perform Operations on a Secure QueueFor 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

Streams Concepts and Administration, 11g Release 2 (11.2)

Managing Staging and Propagation

Disabling a User from Performing Operations on a Secure QueueYou 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,

Streams Concepts and Administration, 11g Release 2 (11.2)

Managing Staging and Propagation

Dropping a Propagationpropagation. 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle JMS Basic Operations

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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing & Messaging Gateway Views

DBA_QUEUE_SCHEDULES: All Propagation SchedulesThe DBA_QUEUE_SCHEDULES view describes all the current schedules in the database for propagating messages.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

JMS Outbound Propagationpropagation of messages from that queue does not continue until the message is removed.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

Scheduling a Queue Propagationschedules 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Performance and Scalability

Propagation Tuning TipsPropagation 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Introducing Oracle JMS

Enhanced Propagation Scheduling CapabilitiesCatalog 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle JMS Basic Operations

Unscheduling a PropagationJMSException 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\");

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

Enabling a Propagation Schedulepropagation 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; /

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Introducing Oracle JMS

Exception Handling During Propagationreverified. 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.

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

TIB/Rendezvous Inbound PropagationIf 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

JMS Inbound Propagationis necessary prior to enqueuing using Oracle JMS. However, if the payload ADT of the propagation

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

Verifying Propagation Queue TypeDBMS_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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

Unscheduling a Queue Propagationpropagation 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Managing Oracle Streams Advanced Queuing

Handling Failures in Propagationmessage 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Streams Advanced Queuing Administrative Interface

Disabling a Propagation Schedulepropagation 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Working with Oracle Messaging Gateway

Resetting a Propagation JobWhen 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle JMS Basic Operations

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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

WebSphere MQ Outbound PropagationIf no message transformation is provided for outbound propagation, then the Oracle Streams Advanced

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

TIB/Rendezvous Outbound PropagationIf 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

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Staging and Propagation

Message Propagation Between QueuesYou 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Working with Oracle Messaging Gateway

Propagation Job OverviewA 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Working with Oracle Messaging Gateway

Removing a Propagation JobYou 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Introducing Oracle Messaging Gateway

Propagation Processing OverviewPropagation 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle JMS Basic Operations

Altering a Propagation Schedulemethod 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle JMS Basic Operations

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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Working with Oracle Messaging Gateway

Altering a Propagation JobAfter 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Managing Oracle Streams Advanced Queuing

Security Required for PropagationOracle 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\"

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Managing Oracle Streams Advanced Queuing

Propagation from Object QueuesPropagation 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

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Oracle Messaging Gateway Message Conversion

WebSphere MQ Inbound PropagationIf no message transformation is provided for inbound propagation, then the Oracle Streams Advanced

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Glossary

propagationCopying messages from one queue to another (local or remote) queue.

Streams Concepts and Administration, 11g Release 2 (11.2)

Glossary

propagationAn optional Oracle Streams client that uses an Oracle Scheduler job to send message s from a source queue to a destination queue.

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Staging and Propagation

3 Oracle Streams Staging and Propagationpropagating 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

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Staging and Propagation

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

Streams Concepts and Administration, 11g Release 2 (11.2)

Oracle Streams Staging and Propagation

Queue-to-Queue PropagationsA 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





Was this page helpful?

Integrated Cloud Applications & Platform Services