Vs: RE: DRG-50857 & ORA-06512 & ORA-20000 after 10.2.0.5.0 patchset on Update clause on XMLTYPE

From: Teijo Lallukka <teijo.lallukka_at_edita.fi>
Date: Wed, 09 Jun 2010 09:17:57 +0300
Message-Id: <sc0f5c57.008_at_gw00.edita.fi>



Hi!

Thanks, and yes, it is confirmed yesterday already. Sorry that not responding to list right away.

Workaround is to use lenghth of schema.index < 40 Chars.

SR going and waiting fix for this issue...

Thanks listers.

-Teijo

>>> "Vijay Singh" <vsingh_at_smartdogservices.com> 9.6.2010 3:11 >>> Hi Again,

    Sorry did not read the whole email :(

This looks like bug 9488247.

Schema- XXPUBLIC_APP1_PROD (18 Chars)
Index - PROD_RESOURCE_DATA_INDEX (24 Chars) 18 + 24 > 40 Chars.

Please reduce the size of index name so that schema.index is < 40 Chars. Thanks !
VKS
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Teijo Lallukka Sent: Tuesday, June 08, 2010 4:05 AM
To: oracle-l_at_freelists.org
Subject: DRG-50857 & ORA-06512 & ORA-20000 after 10.2.0.5.0 patchset on Update clause on XMLTYPE

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

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 09 2010 - 01:17:57 CDT

Original text of this message