Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
problem using autofilter / ctxhx not working

I'm realy stuck here.
I have a vanilla oracle 19c installation
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
and i can't get ctxhx (oracle context / text index) to work.
I created 3 documents testdoc2.doc testdoc2.docx testdoc2.pdf and try to convert them manually.
See screen output below... ctxhx invoked 3 times, only one output file is generated. And it contains ORA_DRG-11221. The other two conversions give nothing. No error no output. just zip null
What am i missing?
[[email protected] ~]$ mkdir test
[[email protected] ~]$ cd test
[[email protected] test]$ mv ../testdoc2.* .
[[email protected] test]$ ls -la
total 40
drwxr-xr-x. 2 oracle oinstall 4096 Aug 27 15:03 .
drwx------. 8 oracle oinstall 4096 Aug 27 15:03 ..
-rw-r--r--. 1 oracle oinstall 9728 Aug 27 14:33 testdoc2.doc
-rw-r--r--. 1 oracle oinstall 10331 Aug 27 14:33 testdoc2.docx
-rw-r--r--. 1 oracle oinstall 6409 Aug 27 14:53 testdoc2.pdf
[[email protected] test]$ pwd
/home/oracle/test
[[email protected] test]$ ls -la
total 40
drwxr-xr-x. 2 oracle oinstall 4096 Aug 27 15:03 .
drwx------. 8 oracle oinstall 4096 Aug 27 15:03 ..
-rw-r--r--. 1 oracle oinstall 9728 Aug 27 14:33 testdoc2.doc
-rw-r--r--. 1 oracle oinstall 10331 Aug 27 14:33 testdoc2.docx
-rw-r--r--. 1 oracle oinstall 6409 Aug 27 14:53 testdoc2.pdf
[[email protected] test]$ env|grep PATH
LD_LIBRARY_PATH=/u01/app/ora19/ctx/lib:/u01/app/ora19/lib
PATH=/u01/app/ora19/ctx/bin:/u01/app/ora19/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bi
n:/home/oracle/bin:/home/oracle/bin
[[email protected] test]$ ctxhx testdoc2.doc doc.txt
[[email protected] test]$ ctxhx testdoc2.docx docx.txt
[[email protected] test]$ ctxhx testdoc2.pdf pdf.txt
[[email protected] test]$ ls -la
total 44
drwxr-xr-x. 2 oracle oinstall 4096 Aug 27 15:03 .
drwx------. 8 oracle oinstall 4096 Aug 27 15:03 ..
-rw-r--r--. 1 oracle oinstall 14 Aug 27 15:03 doc.txt
-rw-r--r--. 1 oracle oinstall 9728 Aug 27 14:33 testdoc2.doc
-rw-r--r--. 1 oracle oinstall 10331 Aug 27 14:33 testdoc2.docx
-rw-r--r--. 1 oracle oinstall 6409 Aug 27 14:53 testdoc2.pdf
[[email protected] test]$ cat doc.txt
ORA_DRG-11221
[[email protected] test]$
Answers
-
Hi Henrie,
There are some known bugs on indexing documents in 19c. I suggest to raise an SR with Oracle Support here.
Cheers,
Victor -
Hi Henrie,
I can confirm that there are significant issues with ctxhx that I've ran into. For me most were resolved in 19.12 - but that patch is not yet official released yet and only available via SR request.