Wednesday 26 February 2014

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



No comments:

Post a Comment