How to install or enable Advanced Queue (AQ) in the database

[ezhilarasan_1]

Hi,

How to install or enable Advanced Queue (AQ) in the database ( 8i, 9i ).

Kindly give the detail steps.

Thanks
Ezhil

[Steven E. Protter]

Shalom Ezhil,

This is a product you intend to install into Oracle? What is your OS?

May I suggest http://technet.oracle.com

SEP

[Frank de Vries]

job_queue_processes = 2 #param to
run 2 jobs
job_queue_interval = 60 # Parameter every 60 seconds

[Indira Aramandla · Accepted solution]

Hi Ezhil,

Oracle8 AQ (Advanced Queuing) provides message queuing as an integrated part of the Oracle Server. Oracle8 uses the following components to deliver AQ functionality (Message, Queue, Queue Tables, Agents, Time manager)

Refer to Note:52748.1 in Metalink for details on Oracle8 Advanced Queuing Capabilities And An Introduction To Terms And Concepts

Note:1060419.6 for details on ORACLE8 ADVANCED QUEUING ROLES: AQ_USER_ROLE, AQ_ADMINISTRATOR_ROLE

Note:93819.1 ADVANCED QUEUING PROPAGATION JOBS

Check the entries in the Initialisation parameter. File.

To setup ADVANCED QUEUING (AQ) CONFIGURATION, make sure the Oracle Message Broker is NOT running when you run the scripts

In order to use the Advanced Queueing option on 8i as a messaging technology with OMB, the following changes to AQ must be performed. You will need to run three scripts located in %OMB_HOME%\admin\plsql

$cd %OMB_HOME%\admin\plsql

Create the AQ admin user for OMB
Grant privileges
Install packages and execute permission

The AQ_ADMINISTRATOR_ROLE and AQ_USER_ROLE roles are used for the Advanced
Queuing (AQ) option in Oracle8.

Administrative Interface

The administrative interface to Oracle8 AQ is comprised of two PL/SQL packages, DBMS_AQADM and DBMS_AQ. Configuration information can be managed through procedures in the DBMS_AQADM package

Privileges and Access Control

Access to AQ operations are granted to users through roles. These roles provide execution privileges on the Advanced Queuing procedures contained in the DBMS_AQADM and DBMS_AQ packages.

Administrator Role

The AQ_ADMINISTRATOR_ROLE role grants execute privileges to procedures in the DBMS_AQADM and DBMS_AQ packages.
User Role

The AQ_USER_ROLE role grants execute privileges to procedures in the DBMS_AQ
package. These include all the operational interfaces.

Oracle 8i Considerations:

Avoid granting AQ_USER_ROLE in 8.1 since this role will not provide sufficient privileges for enqueue/dequeue on 8.1 compatible queues. The AQ_USER_ROLE will only work with 8.0 compatible queues. DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE can be used
to grant ENQUEUE/DEQUEUE ANY QUEUE privilege.

Access to AQ Object Types

The procedure "grant_type_access" must first be executed by the user 'SYS' to grant access for AQ object types to the AQ administrator. The AQ administrator can then execute this procedure to grant access for AQ object types to other AQ users. The procedure needs to be executed if the user wishes to perform any administrative operations involving a multiple consumer queue.
These include CREATE_QUEUE_TABLE, CREATE_QUEUE, ADD_SUBSCRIBER and REMOVE_SUBSCRIBER, which are all procedures contained in the DBMS_AQADM package.

Indira A

[ezhilarasan_1]

Hi Indira,

You have given excellent notes for my request.
Thanks you very much.

Regards
Ezhil