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
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