sexta-feira, 17 de janeiro de 2014

DRG-10513: index WWSBR_TOPIC_CTX_INDX metadata is corrupt

Caso ocorra o erro abaixo na migração do Portal, utilizando o banco 11.2.0.4:

###
### ERROR: WWU-01013: Upgrade terminated with the following errors:
###        10465 : ERROR at line 1:
###        10466 : ORA-20000:
###        10467 : ORA-06512: at "PORTAL.WWPOF", line 440
###        10468 : ORA-06512: at line 152
###        10469 : ORA-06510: PL/SQL: unhandled user-defined exception
###        10470 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 164
###        10471 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2283
###        10472 : ORA-06510: PL/SQL: unhandled user-defined exception
###        10473 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 71
###        10474 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2231
###        10475 : ORA-29874: warning in the execution of ODCIINDEXALTER routine
###        10476 : ORA-29960: line 1,
###        10477 : DRG-10595: ALTER INDEX WWSBR_TOPIC_CTX_INDX failed
###        10478 : DRG-50857: oracle error in drixmd.PurgeKGL
###        10479 : ORA-20000: Oracle Text error:
###        10480 : DRG-10513: index WWSBR_TOPIC_CTX_INDX metadata is corrupt
###        10481 : ORA-30576: ConText Option dictionary loading error
###        10482 : DRG-50610: internal error: kglpurge []
###        10492 : #   ERROR: Creating missing Text indices
###        10493 : #   ERROR: User-Defined Exception
###        10501 : ### ERROR: Exception Executing upg/common/posttrge/crtxtind.sql


Rodar os seguintes scripts para recriar os índices antes do upgrade:
 /u01/app/oracle/product/as10g/MidTier/portal/admin/plsql/wws/ctxdrind.sql
 /u01/app/oracle/product/as10g/MidTier/portal/admin/plsql/wws/ctxcrind.sql

Aplicar o patch e seguir as instrucões:
 Oracle Text release 11.2.0.4.0 mandatory Patches (Doc ID 1608029.1)





0 comentários: