Hi
I am getting ORA-01013: user requested cancel of current operation frequently. I have given the log of Alert and trace file.
Googling the error message is not helping me much.
Alert Log-
Beginning log switch checkpoint up to RBA [0x8e11.2.10], SCN: 18012393821
Wed Oct 31 20:40:41 2012
Thread 2 advanced to log sequence 36369 (LGWR switch)
Current log# 5 seq# 36369 mem# 0: +BACKUP_DG2/****/onlinelog/group_5.293.692879379
Current log# 5 seq# 36369 mem# 1: +DATA_DG2/****/onlinelog/group_5.367.716206869
Wed Oct 31 20:43:35 2012
Incremental checkpoint up to RBA [0x8e10.eda.0], current log tail at RBA [0x8e11.19.0]
Wed Oct 31 20:45:23 2012
Completed checkpoint up to RBA [0x8e11.2.10], SCN: 18012393821
Wed Oct 31 20:55:58 2012
Errors in file /u01/app/oracle/product/10.2.0/db/admin/****/udump/***_ora_22258.trc:
ORA-01013: user requested cancel of current operation
Wed Oct 31 21:13:41 2012
Incremental checkpoint up to RBA [0x8e11.ba1.0], current log tail at RBA [0x8e11.c3e.0]
Trace File -
***** | *** | /u01/app/oracle/product/10.2.0/db/admin/****/bdump > head -100 /u01/app/oracle/product/10.2.0/db/admin/****/udump/***_ora_22258.trc
/u01/app/oracle/product/10.2.0/db/admin/****/udump/***_ora_22258.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db
System name: SunOS
Node name: *****
Release: 5.10
Version: Generic_138888-08
Machine: sun4u
Instance name: ***
Redo thread mounted by this instance: 2
Oracle process number: 57
Unix process pid: 22258, image: oracle@*****
*** ACTION NAME:() 2012-10-31 20:55:58.160
*** MODULE NAME:(nqsserver.exe) 2012-10-31 20:55:58.160
*** SERVICE NAME:(****) 2012-10-31 20:55:58.160
*** SESSION ID:(458.63982) 2012-10-31 20:55:58.160
*ORA-01013: user requested cancel of current operation*
*Dump of memory from 0x00000003FEBF0950 to 0x00000003FEBF95E8*
3FEBF0950 2F2A2061 63626536 30356520 2A2F5749 [/* acbe605e */WI]
3FEBF0960 5448200D 0A534143 4F4D4D4F 4E363931 [TH ..SACOMMON691]
3FEBF0970 30373738 32204153 20287365 6C656374 [07782 AS (select]
3FEBF0980 2073756D 28543530 35393732 302E4348 [ sum(T5059720.CH]