Re: Advanced Queuing problem

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 27 Mar 2003 15:40:03 GMT
Message-ID: <3E831A88.C7B64396@telusplanet.net>

I think AQ is primarily implemented in the dictionary with AQ tables. IIRC, the AQ processes can be started/stopped using OEM and can be defined in the init.ora. Some ideas:

Do you have OEM available? If yes, please comment what you have tried...
Do you have the $ORACLE_HOME/AQ directory? The AQ is (was?) installed through OH/aq/admin/???.sql You may look through there instead of SYS/SYSTEM to get more info...
Consider dropping the demo users. Seems to me you should be able to 'FORCE' this issue.
Since you say you've lost a datafile, you have a DBA challenge anyway. It might be time to do a proper recovery (you do have backups, don't you?)
If you have a valid license/support contract, this is exactly the type of problem to call Oracle support.

I sincerely hope you are not planning to do the changed directly in the SYS schema.

/Hans Received on Thu Mar 27 2003 - 09:40:03 CST