problem using autofilter / ctxhx not working

Henrie Cuijpers

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]$                                                                                                                                               

victor.ivan-Oracle

Hi Henrie,

There are some known bugs on indexing documents in 19c. I suggest to raise an SR with Oracle Support here.

Cheers,
Victor

kutrovsky

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.