Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
ezhilarasan_1
Occasional Advisor

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

Hi,

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

Kindly give the detail steps.

Thanks
Ezhil
4 REPLIES
Steven E. Protter
Exalted Contributor

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

Shalom Ezhil,

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

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

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Frank de Vries
Respected Contributor

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


job_queue_processes = 2 #param to
run 2 jobs
job_queue_interval = 60 # Parameter every 60 seconds
Look before you leap
Indira Aramandla
Honored Contributor
Solution

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

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
Never give up, Keep Trying
ezhilarasan_1
Occasional Advisor

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

Hi Indira,

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

Regards
Ezhil