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
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
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
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
JMS Propagation → This section contains these topics: RemoteSubscriber Scheduling Propagation Enhanced Propagation … Scheduling Capabilities Exception Handling During Propagation
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