Dear Listers...
I upgraded one of our 10.2.0.4.3(SLES 10 linux 64bit) prod instance to
10.2.0.5.0... Today update to some XML data fails.
Has anyone faced same issue before? Below is error and extra info...
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:DRG-50857: oracle error in
textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:DRG-10602: failed to queue DML change to column
SYS_NC00012$ for primary key AACVTjAAZAAADV1AAA
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 257:PLS-00103: Encountered the symbol
"XXPUBLIC_APP1_PROD" when expecting one of the following:
ORA-06512: at "CTXSYS.DRUE", line 160
UPDATE
app1_resource
SET title=:title, description=:description, code=:code, data=XMLTYPE(:data),
public_from=:public_from,
public_to=:public_to, modified=sysdate WHERE id = :id
Whole db is valid, no invalid objects, upgrade went without any errors.
Any help would be nice... Thanks.
-Teijo
SQL>
SQL> CONNECT / AS SYSDBA;
Connected.
SQL>
SQL> SELECT COMP_ID, VERSION, STATUS FROM DBA_REGISTRY;
COMP_ID
VERSION
------------------------------------------------------------------------------------------
---------------
STATUS
------------------------------------------------------------------------------------------------------------------------------------
ORDIM
10.2.0.5.0
VALID
EM
10.2.0.5.0
VALID
XDB
10.2.0.5.0
VALID
CONTEXT
10.2.0.5.0
VALID
EXF
10.2.0.5.0
VALID
RUL
10.2.0.5.0
VALID
OWM
10.2.0.5.0
VALID
ODM
10.2.0.3.0
OPTION OFF
CATALOG
10.2.0.5.0
VALID
CATPROC
10.2.0.5.0
VALID
JAVAVM
10.2.0.5.0
VALID
XML
10.2.0.5.0
VALID
CATJAVA
10.2.0.5.0
VALID
13 rows selected.
SQL>
SQL> SELECT OBJECT_NAME,OBJECT_TYPE,OWNER FROM DBA_OBJECTS WHERE STATUS !=
'VALID';
no rows selected
SQL>
SQL> SELECT IDX_OWNER, IDX_NAME, IDX_TABLE_OWNER, IDX_TABLE,
IDX_TEXT_NAME,IDX_STATUS, IDX_TYPE FROM CTXSYS.CTX_INDEXES;
IDX_OWNER
------------------------------------------------------------------------------------------
IDX_NAME
------------------------------------------------------------------------------------------
IDX_TABLE_OWNER
------------------------------------------------------------------------------------------
IDX_TABLE
------------------------------------------------------------------------------------------
IDX_TEXT_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
IDX_STATUS IDX_TYPE
------------------------------------ ---------------------
XXPUBLIC_APP1_PROD
PROD_RESOURCE_DATA_INDEX
XXPUBLIC_APP1_PROD
APP1_RESOURCE
SYS_NC00012$
INDEXED CONTEXT
.... snipped rest of index info... all status INDEXED.....
27 rows selected.
SQL>
SQL> SELECT INDEX_NAME, INDEX_TYPE, STATUS, DOMIDX_STATUS ,
DOMIDX_OPSTATUS,TABLE_OWNER, TABLE_NAME FROM DBA_INDEXES WHERE INDEX_TYPE =
'DOMAIN';
no rows selected
SQL>
SQL> SELECT * FROM CTXSYS.CTX_INDEX_ERRORS;
no rows selected
SQL>
SQL> SPOOL OFF
--
//www.freelists.org/webpage/oracle-l
