topic Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2 in Operating System - Microsoft

How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

minh pacia — Thu, 31 Aug 2006 15:24:19 GMT

Hi,

How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2. My OS is Windows XP.

Kindly give the detail steps.

..Minh

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

Yogeeraj_1 — Fri, 01 Sep 2006 08:05:19 GMT

hi Minh,

Advanced Queuing should already be available with your installation.

verify that the dbms_aqadm package is available.

if you want, we can provide you with a simple example

kind regards
yogeeraj

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

melvyn burnard — Fri, 01 Sep 2006 09:38:22 GMT

posted in wrong forum, moved to more appropriate forum

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

minh pacia — Fri, 01 Sep 2006 12:05:23 GMT

yogeeraj,

This is the history of the database that I inherited:
-- Oracle 9.2
-- an upgrade was executed to bring it to Oracle 10g Release 2.

I would like to re-install Advanced Queuing. Is this possible?

Please send me the simple example.

..Minh

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

Yogeeraj_1 — Sat, 02 Sep 2006 00:31:26 GMT

hi,

to start with, try to install the two packages (DBMS_ADM and DBMS_AQ) from the $ORACLE_HOME/rdbms/admin directory.

then as a test, you can create the following user:
CREATE USER aq IDENTIFIED BY aq;

GRANT CONNECT, RESOURCE, aq_administrator_role TO aq;

GRANT EXECUTE ON dbms_aq TO aq;

GRANT EXECUTE ON dbms_aqadm TO aq;

begin
dbms_aqadm.grant_system_privilege('ENQUEUE_ANY','AQ',FALSE);
dbms_aqadm.grant_system_privilege('DEQUEUE_ANY','AQ',FALSE);
end;
/

After you are able to create this user, you will be able to proceed with any test that you may wish

kind regards
yogeeraj

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

minh pacia — Tue, 05 Sep 2006 16:40:43 GMT

yogeeraj,

Thank you for the help. I follow your suggestion to re-install the Advanced Queue package.

..Minh

Re: How to install or enable Advanced Queue (AQ) in the oracle database 10g Release 2

minh pacia — Tue, 05 Sep 2006 16:43:04 GMT

I have re-installed the Package as suggested and now it is a different error that I don't believe is related to Advanced Queue.