Hi,
I am on solaris 10 Now in my alert file, I see lot of messages like
the following. What is
going on here? Your suggestions are appreciated.
Thanks.
This is the trace file generated yxtnc_qmn0_25600.trc
------------------------------------------------
more yxtnc_qmn0_25600.trc
/data/admin/yxtnc/bdump/yxtnc_qmn0_25600.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /export/home/ora/ora9/app/oracle/product/9.2.0.1
System name: SunOS
Node name: mdc-nc-sun2
Release: 5.8
Version: Generic_117350-14
Machine: sun4u
Instance name: yxtnc
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 25600, image: oracle@(protected))
*** 2006-06-10 16:58:26.099
*** SESSION ID:(13.20663) 2006-06-10 16:58:26.098
kwqicaclcur: Error 24026
Cursor Session Number : 40
Cursor Session Serial : 19746
Cursor Pin Number : 9
Error 24026 in Queue Table QS.QS_ORDERS_PR_MQTAB
kwqitmmsgs: error 604
error 604 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-24026: operation failed, queue QS.AQ$_QS_ORDERS_PR_MQTAB_E has errors
--
Regards,
- Qian
--
http://www.freelists.org/webpage/oracle-l
