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
sexta-feira, 17 de janeiro de 2014
DRG-10513: index WWSBR_TOPIC_CTX_INDX metadata is corrupt
18:39
No comments
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:
Postar um comentário