Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01013: user requested cancel of current operation

GeetaMOct 31 2012 — edited Nov 1 2012
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]

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 29 2012
Added on Oct 31 2012
#database, #general-database-discussions
9 comments
2,624 views