I am facing the following problem when indexing a column:
DRG-11207: user filter command exited with status 2
DRG-11225: Third-party filter timed out.
I am using Ubuntu 10.04.2 LTS and Oracle Database 11g Enterprise Edition Release 188.8.131.52.0
I have a column named URL in a table named DOCUMENTO_CONSULTA
This column contains file URLs (2 rows involved in the test)
I am confident that the paths that appear in the two rows of the URL column are correct (because if I change
them to something different another error appear that says, as expected, that files could not be found). I am sure
that access to the files is granted. FILE_ACCESS_ROLE is set to CTXAPP and role is granted to the user. File
and path permission are set to 777.
The two rows contains paths to simple DOC and PDF content, with just one paragraph each.
Ubuntu is not a supported platform for Oracle, so it's hard to answer this.
However, if you want to try to debug it, replace the "ctxhx" executable with a shell script which dumps its arguments and the current environment to a file.
You can then use that output to create a shell with the same environment, and see if command line ctxhx still works. If not, you'll have to figure out what the differences are between the two environments.
I don't know how to do that, I'm a newbie, but I understand that help about this topic is beyond the scope of this thread.
Anyway, I tried the same scenario (Oracle version, database, parameters, index...) in Fedora 17 and it worked,
so I guess that the settings are ok and the problem is located in the link between Ubuntu and Oracle (or maybe I did a
bad Oracle installation).