Can't select * from v$aq

Our database is 8.1.7 Enterprise Ed. OS Sparc Solaris 2.6. I have this error:

SQL> select * from v$aq;
ERROR:

ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor

select count(*) or select distinct <column_name> from v$aq works. select * from v$aq works in svrmgrl, just not in SQL*Plus.

I can't find anything on Metalink indicating this is a bug. I checked most if not all objects created by dbmsaqad.sql and catqueue.sql and they exist. I made sure all objects in SYS and SYSTEM valid. Enabled tracing with 10046 level 12 and looked at the trace file (please go to http://www.stormloader.com/yonghuang/CannotSelectv$aq.txt for it; thanks). Nothing unusual.

Any help is appreciated.

Yong Huang
yong321_at_yahoo.com Received on Tue May 29 2001 - 13:43:41 CDT