Results for propagation


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


Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Error Handling

Exception PropagationIf an exception is raised in a block that has no exception handler for it, then the exception propagates. That is, the exception reproduces itself in successive enclosing blocks until either a block has a handler for it or there is no enclosing block. If there is no handler for the exception, then PL/SQL returns an unhandled exception error to the invoker or host environment, which determines the

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Error Handling

Propagation of Exceptions Raised in Exception HandlersAn exception raised in an exception handler propagates immediately to the enclosing block (or to the invoker or host environment if there is no enclosing block). Therefore, the exception handler must be in an enclosing or invoking block. In Example 11-17, when n is zero, the calculation 1/n raises the predefined exception ZERO_DIVIDE, and control transfers to the ZERO_DIVIDE exception handler in the

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Error Handling

Propagation of Exceptions Raised in Declarationsexception raised by a remote subprogram. Topics Propagation of Exceptions Raised in Declarations … Propagation of Exceptions Raised in Exception Handlers Propagation of Exceptions Raised in

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_AQADM

Propagation SubprogramsTable 23-7 Propagation Subprograms Subprograms Description ALTER_PROPAGATION_SCHEDULE Procedure … Alters parameters for a propagation schedule DISABLE_PROPAGATION_SCHEDULE Procedure Disables a … propagation schedule ENABLE_PROPAGATION_SCHEDULE Procedure Enables a previously disabled propagation … schedule SCHEDULE_PROPAGATION

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

Troubleshooting Propagation

Is the Propagation Enabled?For a propagation job to propagate messages, the propagation must be enabled. If messages are not … being propagated by a propagation as expected, then the propagation might not be enabled. You can … find the following information about a propagation: The database link used to propagate messages from

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

Troubleshooting Propagation

ORA-25224 Sender name must be specified for enqueue into secure queuesTo enqueue into a secure queue, the SENDER_ID must be set to an Oracle Streams Advanced Queuing (AQ) agent with secure queue privileges for the queue in the message properties. See Also: Oracle Streams Advanced Queuing User's Guide for an example that sets the SENDER_ID for enqueue

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

Troubleshooting Propagation

32 Troubleshooting PropagationThe following topics describe identifying and resolving common propagation problems in an Oracle … Streams environment: Does the Propagation Use the Correct Source and Destination Queue? Is the … Propagation Enabled? Is Security Configured Properly for the ANYDATA Queue? See Also: \"Message Propagation … propagations

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

Troubleshooting Propagation

Does the Propagation Use the Correct Source and Destination Queue?If messages are not appearing in the destination queue for a propagation as expected, then the … propagation might not be configured to propagate messages from the correct source queue to the correct … destination queue. For example, to check the source queue and destination queue for a propagation … @DBS1.EXAMPLE.COM STRMADMIN.QUEUE2@DBS2.EXAMPLE.COM

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

Troubleshooting Propagation

ORA-24093 AQ Agent not granted privileges of database userSecure queue access must be granted to an Oracle Streams Advanced Queuing (AQ) agent explicitly for both enqueue and dequeue operations. You grant the agent these privileges using the ENABLE_DB_ACCESS procedure in the DBMS_AQADM package. For example, to grant an agent named explicit_dq privileges of the database user oe, run the following procedure: BEGIN DBMS_AQADM.ENABLE_DB_ACCESS( agent_name =>

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

Troubleshooting Propagation

Is Security Configured Properly for the ANYDATA Queue?ANYDATA queues are secure queue s, and security must be configured properly for users to be able to perform operations on them. If you use the SET_UP_QUEUE procedure in the DBMS_STREAMS_ADM package to configure a secure ANYDATA queue, then an error is raised if the agent that SET_UP_QUEUE tries to create already exists and is associated with a user other than the user specified by queue_user in this

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

Managing Oracle Streams Advanced Queuing

Managing PropagationThis section contains these topics: EXECUTE Privileges Required for Propagation Propagation from … Object Queues Optimizing Propagation Handling Failures in Propagation Caution: For propagation to work

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

Oracle JMS Basic Operations

Propagation SchedulesThis section contains these topics: Scheduling a Propagation Enabling a Propagation Schedule … Altering a Propagation Schedule Disabling a Propagation Schedule Unscheduling a Propagation

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

Managing Oracle Streams Advanced Queuing

Optimizing PropagationAQ propagation jobs are run by the Oracle Scheduler. Propagation may be scheduled in the following … ways: A dedicated schedule in which the propagation runs forever or for a specified duration. This … mode provides the lowest propagation latencies. A periodic schedule in which the propagation runs

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

Advanced Propagation Concepts

Propagation JobsAn Oracle Streams propagation is configured internally using Oracle Scheduler. Therefore, a … propagation job is a job that propagates message s from a source queue to a destination queue. Like other … Oracle Scheduler jobs, propagation jobs have an owner, and they use slave processes ( j nnn ) as … needed to execute jobs. The

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

Introduction to Oracle AQ

Propagation Featuresbe located in the same database or in a remote database. Propagation enables you to fan out … . You can also use propagation to combine messages from different queues into a single queue. This … queue to a single-consumer queue. Propagation from a single-consumer queue to a multiconsumer queue … Queuing does not currently propagate

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

Introducing Oracle JMS

JMS PropagationThis section contains these topics: RemoteSubscriber Scheduling Propagation Enhanced Propagation … Scheduling Capabilities Exception Handling During Propagation

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

Oracle Streams Staging and Propagation

Propagation RulesFigure 3-1 Propagation from a Source Queue to a Destination Queue Description of \"Figure 3-1 … Propagation from a Source Queue to a Destination Queue\" You can create, alter, and drop a propagation … , and you can define propagation rule s that control which messages are propagated. The user who owns … used by

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

Introducing Oracle JMS

Scheduling PropagationPropagation must be scheduled using the schedule_propagation method for every topic from which … schedule is created, a job is automatically submitted to the job_queue facility to handle propagation … . The administrative calls for propagation scheduling provide great flexibility for managing the … schedules. The duration or propagation

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

Oracle Streams Restrictions

Propagation Restrictionsfor Queue-To-Queue Propagations See Also: \"Message Propagation Between Queues\"

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Set the Propagation Latency for Each PropagationPropagation latency is the maximum wait, in seconds, in the propagation window for a message to be … propagated after it is enqueued. Set the propagation latency to an appropriate value for each … propagation in your Oracle Streams replication environment. The default propagation latency value is 60

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

Managing Staging and Propagation

Adding Rules to the Rule Set for a PropagationTo add rule s to the rule set of a propagation, you can run one of the following procedures … rule set for a propagation. The ADD_SUBSET_PROPAGATION_RULES procedure can add rules only to the … positive rule set for a propagation. This section contains these topics: Adding Rules to the Positive … Rule Set for a Propagation

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

Advanced Propagation Concepts

9 Advanced Propagation Conceptspropagating messages from one queue to another: Propagation Jobs Oracle Streams Data Dictionary for … Propagations Binary File Propagation See Also: \"Message Propagation Between Queues\" \"Managing Oracle … Streams Propagations and Propagation Jobs\" Oracle Streams Advanced Queuing User's Guide for detailed

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

Advanced Propagation Concepts

Binary File Propagation, but before the message propagation is committed. The directory object and filename of each

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

Managing Staging and Propagation

Starting a Propagationpropagation. For example, the following procedure starts a propagation named strm01_propagation

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

Managing Staging and Propagation

Stopping a Propagationpropagation. For example, the following procedure stops a propagation named strm01_propagation: BEGIN … ; / To clear the statistics for the propagation when it is stopped, set the force parameter to TRUE … . If there is a problem with a propagation, then stopping the propagation with the force parameter

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

17 Best Practices for Propagationenvironment. This chapter includes these topics: Best Practices for Propagation Configuration Best … Practices for Propagation Operation See Also: \"Best Practices for Oracle Real Application Clusters and Oracle Streams\"

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Best Practices for Propagation ConfigurationPropagations Set the Propagation Latency for Each Propagation Increase the SDU in a Wide Area Network for Better Network Performance

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)

Advanced Propagation Concepts

Propagation Scheduling and Oracle Streams PropagationsA propagation schedule specifies how often a propagation job propagates messages from a source … queue to a destination queue. Each queue-to-queue propagation has its own propagation job and … propagation schedule, but queue-to-dblink propagations that use the same propagation job have

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

Managing Staging and Propagation

Managing Oracle Streams Propagations and Propagation JobsA propagation propagates message s from an Oracle Streams source queue to an Oracle Streams … Propagation Stopping a Propagation Altering the Schedule of a Propagation Job Specifying the Rule Set for … a Propagation Adding Rules to the Rule Set for a Propagation Removing a Rule from

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

Managing Staging and Propagation

Removing a Rule Set for a PropagationYou remove a rule set from a propagation using the ALTER_PROPAGATION procedure in the … . Specify TRUE for the remove_rule_set parameter to remove the positive rule set for the propagationpropagation. For example, the following procedure removes both the positive and the negative rule set from a … propagation

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

16 Managing Staging and PropagationThe following topics describe managing ANYDATA queue s and propagation s: Managing Queues Managing … Oracle Streams Propagations and Propagation Jobs Each task described in this chapter should be … specified otherwise. See Also: Chapter 3, \"Oracle Streams Staging and Propagation\" Oracle Streams … \"Monitoring Queues and Messaging\"

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

Removing a Rule from the Rule Set for a PropagationYou remove a rule from the rule set for an existing propagation by running the REMOVE_RULE … departments3 from the positive rule set of a propagation named strm01_propagation. BEGIN … DBMS_STREAMS_ADM.REMOVE_RULE( rule_name => 'departments3', streams_type => 'propagation', streams_name … for the propagation, not

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Use Queue-to-Queue PropagationsA propagation can be queue-to-queue or queue-to-database link (queue-to-dblink). Use queue-to-queue … propagations whenever possible. A queue-to-queue propagation always has its own exclusive … propagation job to propagate messages from the source queue to the destination queue. Because each … propagation job

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Increase the SDU in a Wide Area Network for Better Network PerformanceWhen using Oracle Streams propagation in a Wide Area Network (WAN), increase the session data unit … (SDU) to improve the propagation performance. The maximum value for SDU is 32K (32767). The SDU … advantage of an increased SDU for Oracle Streams propagation, the receiving side sqlnet.ora file must … parameters in the listener.ora

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

Specifying the Rule Set for a PropagationYou can specify one positive rule set and one negative rule set for a propagation. The propagation … Positive Rule Set for a Propagation Specifying a Negative Rule Set for a Propagation See Also … Positive Rule Set for a Propagation You specify an existing rule set as the positive rule set for an

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 Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Best Practices for Propagation OperationThe following section describes best practices for operating existing propagations.

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Best Practices for Propagation

Restart Broken PropagationsSometimes, the propagation job for a propagation might become \"broken\" or fail to start after it … encounters an error or after a database restart. Typically, stopping and restarting the propagation … solves the problem. For example, to stop and restart a propagation named prop1, run the following … set to TRUE,

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

Managing Staging and Propagation

Removing a QueueYou use the REMOVE_QUEUE procedure in the DBMS_STREAMS_ADM package to remove an existing ANYDATA queue. When you run the REMOVE_QUEUE procedure, it waits until any existing message s in the queue are consumed. Next, it stops the queue, which means that no further enqueues into the queue or dequeues from the queue are allowed. When the queue is stopped, it drops the queue. You can also drop the queue

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

Managing Staging and Propagation

Altering the Schedule of a Propagation JobTo alter the schedule of an existing propagation job, use the ALTER_PROPAGATION_SCHEDULE procedure … propagation job for a queue-to-queue propagation and for a queue-to-dblink propagation. These examples … set the propagation job to propagate message s every 15 minutes (900 seconds), with each propagation

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

Advanced Propagation Concepts

Propagation Jobs and RESTRICTED SESSIONstatement, propagation jobs with enabled propagation schedules do not propagate messages. When the … restricted session is disabled, each propagation schedule that is enabled and ready to run will run when … SQL statement ALTER SYSTEM ENABLE RESTRICTED SESSION, any running propagation job continues to run … to

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)

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)

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

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 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

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 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

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)

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

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)

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)

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 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





Was this page helpful?

Integrated Cloud Applications & Platform Services