I'm having a strange problem on a 184.108.40.206 database. We are doing once a day optimization of text-indexes. We do this by the ctx_scheduling package every day at the evening (normally no users are working than).
but get next errors in my alertlog:
ora-12012: error on auto execute of job 1
ora-20000: intermedia text error
drg-50857: oracle errro in dreogc
ora-00600: with argument 
ora-06512: at ctxsys.drue at line ...
ora-06512: at ctxsys.ctx_ddl at line ...
I also saw that in dba_jobs, the first job had 2 failures.
We also do optimizing of 2 other indexes, this runs well. (maybe less documents - changes could be the reason).
Today I tried to run the ctx_ddl.optimize_index('index_name','optimize full') direct on the prompt (not by schedule), but this is already running now for more than 6 hours???!
I don't find anything about this problem on google, metalink ...
Only at metalink there was a bug that has almost same problems as mine, but they don't really give a solution :-(
Should I upgrade to 220.127.116.11 or later? Upgrading to 9i is not an option at this moment ...
Also on Oracle 18.104.22.168 we use exact the same procedures and this runs without problems...
anyone else who had this problem and could help me out with this?