ORA-29874 DRG-10595 DRG-00100 - During Autoconfig Oracle R12

During autoconfig got below error
Error:
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
DECLARE
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed
DRG-00100: internal error, arguments : [51021],[drwaf.c],[1615],[],[]
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at line 96


Solution:
Autoconfig Failed On Apps Tier "jtfictx.sh INSTE8_PRF" . Running manually "jtfictx.sh " 

Failed on "DRG-10758: index owner does not have the privilege" [ID 1357760.1]

1. Apply the note 1081227.1
   (Recommended) Create a new role, grant it to the owners of the impacted indexes, and 

set file_access_role to the new role.
- or -
2. Set file_access_role to 'public'

To change file_access_role, you must be connected as SYSDBA.

SQL> connect as sysdba
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')
3. Rerun Autoconfig on the APPS tier

How to Kill oracle datapump export job

In oracle expdp and impdp we can Kill job at any moment.Below are the steps how can we kill the datapump job.

17:18:37 dev > select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION
------------------------------ ------------------------------ ------------------------------
JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ---------- ----------------- -----------------
SYSTEM SYS_EXPORT_FULL_01 EXPORT
FULL EXECUTING 1 0 2


17:19:11 dev > !ps -ef | grep expdp
orauat 1945838 2142428 0 17:19:25 pts/0 0:00 grep expdp



$ expdp system/manager attach=SYSTEM.SYS_EXPORT_FULL_01

Export: Release 11.2.0.1.0 - Production on Fri Dec 9 17:23:04 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Job: SYS_EXPORT_FULL_01
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: B3A5B7EACDCC30C8E0430A0B014030C8
Start Time: Friday, 09 December, 2011 14:09:19
Mode: FULL
Instance: dev
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/******** directory=EXP_dev dumpfile=fulldp_c lone_091211_system.dmp logfile=fulldp_dev_091211_system.log full=y
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /orabackup/EXP_dev/fulldp_dev_091211_system.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: APPS
Object Name: EAM_DEPT_APPROVERS_PUB
Object Type: DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Completed Objects: 11,280
Worker Parallelism: 1


Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes