os - Windows server 2012
version - 11.2.0.1.0
server : production server
Every day we are taking Data pump expdp backup and yesterday it got failure with following error
Starting "AWSCOMMONMASTER"."FULLEXPJOB18JUN15_090003":
Estimate in progress using STATISTICS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DO_STATISTICS_ESTIMATE [TABLE_DATA:"DAILYRAWMAH"."S07130131"]
SELECT cols, rowcnt, avgrln FROM SYS.KU$_TABLE_EST_VIEW WHERE object_schema = :1 AND object_name = :2 AND :3 IS NULL AND :4 IS NULL
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8171
----- PL/SQL Call Stack -----
object line object
handle number name
00000002F8D46620 18990 package body SYS.KUPW$WORKER
00000002F8D46620 8192 package body SYS.KUPW$WORKER
00000002F8D46620 8599 package body SYS.KUPW$WORKER
00000002F8D46620 7734 package body SYS.KUPW$WORKER
00000002F8D46620 12616 package body SYS.KUPW$WORKER
00000002F8D46620 2434 package body SYS.KUPW$WORKER
00000002F8D46620 8847 package body SYS.KUPW$WORKER
00000002F8D46620 1649 package body SYS.KUPW$WORKER
00000002F114F380 2 anonymous block
Estimate in progress using STATISTICS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DO_STATISTICS_ESTIMATE [TABLE_DATA:"DAILYRAWTN"."S07130131"]
SELECT cols, rowcnt, avgrln FROM SYS.KU$_TABLE_EST_VIEW WHERE object_schema = :1 AND object_name = :2 AND :3 IS NULL AND :4 IS NULL
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8171
----- PL/SQL Call Stack -----
object line object
handle number name
00000002F8D46620 18990 package body SYS.KUPW$WORKER
00000002F8D46620 8192 package body SYS.KUPW$WORKER
00000002F8D46620 8599 package body SYS.KUPW$WORKER
00000002F8D46620 7734 package body SYS.KUPW$WORKER
00000002F8D46620 12616 package body SYS.KUPW$WORKER
00000002F8D46620 2434 package body SYS.KUPW$WORKER
00000002F8D46620 8847 package body SYS.KUPW$WORKER
00000002F8D46620 1649 package body SYS.KUPW$WORKER
00000002F114F380 2 anonymous block
Job "AWSCOMMONMASTER"."FULLEXPJOB18JUN15_090003" stopped due to fatal error at 22:21:19
Based on above error i have two doubt,
1) Every day i used to take expdp successfully why it has failed yesterday only when everything is correct, My doubt is that any one manually stop or revoke any privilege that related to export from above mentioned user called AWSCOMMONMASTER.
If yes then how can i find who has revoked privileges and what privileges has revoked and when, How can i achieve it. I have toad tool
2) If not above mentioned point of view then, what is the actual error how can i Identify. Any way my backp job will start today and i need to make it success. Thanks in Advance to spending your golden time.