Doc ID: Note:105851.1
Subject: Problem/Solution: ORA-29902 DRG-50857 ORA-904 ORA-30576 after upgrade to 8.1.6
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 19-APR-2000
Last Revision Date: 19-JUL-2002
Problem Description ------------------- After upgrading the RDBMS from 8.1.5 to 8.1.6 the following errors may occur when performing a 'select .. where contains ..' on a table which has been indexed using InterMedia: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: interMedia Text error: DRG-50857: oracle error in drdmlpo ORA-00904: invalid column name ORA-30576: ConText Option dictionary loading error Solution Description -------------------- Verify which text version is currently installed, connected as CTXSYS: SQL> select * from ctx_version; gives you the installed ctxsys-version. Run the following upgrade scripts when version is 8.1.5: $ORACLE_HOME/ctx/admin/upgrade/u0801060.sql as user CTXSYS $ORACLE_HOME/ctx/admin/upgrade/s0801060.sql as user SYS $ORACLE_HOME/ctx/admin/dr0pkh.sql as user CTXSYS $ORACLE_HOME/ctx/admin/dr0plb.sql as user CTXSYS $ORACLE_HOME/ctx/admin/dr0type.plb as user CTXSYS Explanation ----------- After upgrading the RDBMS from 8.1.5 to 8.1.6, the ctxsys schema has to be upgraded as well. Related Documents Please also review [NOTE:73605.1] Which covers manual Install issues. Please also review [NOTE:120611.1] for an upgrade to 8.1.7. Additional Search Words ----------------------- CTXSYS, 8.1.5, 8.1.6, interMedia Text, DRGEN
Originally posted by toan voduc:
Hello every body!
I have some problem like Prabha. When I am trying to execute:
---- code ---
SELECT * FROM resource_view
WHERE under_path(RES,'/public/home/') > 0
AND contains(RES,'=') > 0
----
I get the following error:
ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 1
Is the error different from error Prabha got?
Can Mr.Mark Spritzler help me out with this.
Thanks,
voduc
---<br />Tom Battaglia<br />:wq
SCJP 1.4<br />SCWCD 1.4<br />SCBCD 1.3
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |