Vs: RE: DRG-50857 & ORA-06512 & ORA-20000 after 10.2.0.5.0 patchset on Update clause on XMLTYPE
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