How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Exception Propagation → If 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
Propagation of Exceptions Raised in Exception Handlers → An 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
Propagation of Exceptions Raised in Declarations → exception raised by a remote subprogram. Topics Propagation of Exceptions Raised in Declarations … Propagation of Exceptions Raised in Exception Handlers Propagation of Exceptions Raised in
Propagation Subprograms → Table 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
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
ORA-25224 Sender name must be specified for enqueue into secure queues → To 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
32 Troubleshooting Propagation → The 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
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
ORA-24093 AQ Agent not granted privileges of database user → Secure 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 =>
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
Managing Propagation → This section contains these topics: EXECUTE Privileges Required for Propagation Propagation from … Object Queues Optimizing Propagation Handling Failures in Propagation Caution: For propagation to work
Propagation Schedules → This section contains these topics: Scheduling a Propagation Enabling a Propagation Schedule … Altering a Propagation Schedule Disabling a Propagation Schedule Unscheduling a Propagation
Propagation Jobs → An 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
Optimizing Propagation → AQ 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
JMS Propagation → This section contains these topics: RemoteSubscriber Scheduling Propagation Enhanced Propagation … Scheduling Capabilities Exception Handling During Propagation
Propagation Features → be 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
Propagation Rules → Figure 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
Scheduling Propagation → Propagation 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
Propagation Restrictions → for Queue-To-Queue Propagations See Also: \"Message Propagation Between Queues\"
Set the Propagation Latency for Each Propagation → Propagation 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
Adding Rules to the Rule Set for a Propagation → To 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
9 Advanced Propagation Concepts → propagating 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
Binary File Propagation → , but before the message propagation is committed. The directory object and filename of each
17 Best Practices for Propagation → environment. 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\"
Best Practices for Propagation Configuration → Propagations Set the Propagation Latency for Each Propagation Increase the SDU in a Wide Area Network for Better Network Performance
Starting a Propagation → propagation. For example, the following procedure starts a propagation named strm01_propagation
Stopping a Propagation → propagation. 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
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 Oracle Streams Propagations and Propagation Jobs → A 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
Removing a Rule Set for a Propagation → You 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 propagation … propagation. For example, the following procedure removes both the positive and the negative rule set from a … propagation
Propagation Scheduling and Oracle Streams Propagations → A 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
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,
16 Managing Staging and Propagation → The 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\"
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
Removing a Rule from the Rule Set for a Propagation → You 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
Managing Queues → ANYDATA queue, and each Oracle Streams propagation is associated with one ANYDATA source queue and
Specifying the Rule Set for a Propagation → You 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
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
Use Queue-to-Queue Propagations → A 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
Increase the SDU in a Wide Area Network for Better Network Performance → When 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
Best Practices for Propagation Operation → The following section describes best practices for operating existing propagations.
Restart Broken Propagations → Sometimes, 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,
Removing a Queue → You 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
Altering the Schedule of a Propagation Job → To 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
Propagation Jobs and RESTRICTED SESSION → statement, 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
WebSphere MQ Inbound Propagation → If no message transformation is provided for inbound propagation, then the Oracle Streams Advanced
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\"
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
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
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
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
DBA_QUEUE_SCHEDULES: All Propagation Schedules → The DBA_QUEUE_SCHEDULES view describes all the current schedules in the database for propagating messages.
WebSphere MQ Outbound Propagation → If no message transformation is provided for outbound propagation, then the Oracle Streams Advanced
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
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
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
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; /
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
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