Re: ctxsrv problem

Tom76 wrote:
>
> Oracle: 9.2.0.4
> OS: Linux
>
> when starting a ctxsrv process, getting the following errors in the
> logfile.
>
> --command--
> >nohup ctxsrv -user ctxsys/systext -personality M -log
> /tmp/ABC8_CONTEXT.log -sqltrace > /dev/null 2>&1 &
>
> --logfile(/tmp/ABC8_CONTEXT.log)--
> 14:44:20 05/12/05 === OCO server startup ===
> 14:44:20 05/12/05 Initialized CORE
> 14:44:20 05/12/05 Connected to database.
> 14:44:20 05/12/05 === Initializing dispatcher ===
> 14:44:20 05/12/05 === Server startup completed. ===
> 14:44:21 05/12/05 DML batch: cid=1083, pid=0
> 14:44:22 05/12/05 End batch, return code is 1
> 14:44:22 05/12/05 DRG-50857: oracle error in drtldml(dml)
> 14:44:22 05/12/05 ORA-20000: Oracle Text error:
> DRG-50857: oracle error in drekmap (select rowid row locator)
> DRG-50858: OCI error: OCI_NO_DATA
>
> ORA-06512: at "CTXSYS.DRUE", line 157
> ORA-06512: at line 1
>
> 14:44:24 05/12/05 DML batch: cid=1083, pid=0
> 14:44:25 05/12/05 End batch, return code is 1
> 14:44:25 05/12/05 DRG-50857: oracle error in drtldml(dml)
> 14:44:25 05/12/05 ORA-20000: Oracle Text error:
> DRG-50857: oracle error in drekmap (lob write)
> ORA-01403: no data found
>
> ORA-06512: at "CTXSYS.DRUE", line 157
> ORA-06512: at line 1
> =============================================================
> this error is continously filling the log file.
>
> --Recompiled invalid objects and CTXSYS & SYS has no invalid objects.
> --nothing in the database alert log(like space issue or any kind)
> --using UNDO tablespace and it has 15GB in free space
>
> Please help!!URGENT!!

btw - use of ctxsrv is not supported from 8.1.6 onwards, you're meant to be using the CTX_DDL package

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------