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@mdc-nc-sun2 (QMN0)
*** 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 -- //www.freelists.org/webpage/oracle-l