I have installed Oracle 11gR2 on Ubuntu 12.04 and also Oracle 12c on another Ubuntu 12.04.
I know that this is not a supported distribution, but we have a case where it's necessary to have Ubuntu.
Following some instructions, that we have read in some posts ,the installation has finished fine.
It seems like everything is working but there is one thing that doesn't work and we needed.
The problem are the calls to CTX_DOC.IFILTER that we neeed to convert some PDF into a BLOB column into HTML, to later insert them into another column.
The error that we get is:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: in "CTXSYS.CTX_DOC",line 3039
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: in "CTXSYS.DRVDISP", line 372
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: in "IDISC2013.CONTINGUT_DOC", line 16
ORA-06512: en line 2
(CONTINGUT_DOC is the procedure that makes the call to CTX_DOC.IFILTER)
If I replace ctxhx to another executable script that writes some text to a file I can check that is not launched from the database.
If I call ctxhx from operating system it works fine (also using user oracle)
We have also checked tht LD_LIBRARY and LB_LIBRARY_PATH to include $ORACLE_HOME/ctx/lib and $PATH to include $ORACLE_HOME/ctx/bin
I have read that some people have the same problem but they didn't receive any solution.
Any idea?
I think that this could be so simple to resolve (install a shared lib, create a symbolic link of a library, create an environment variable, recompile something with an specific option, check a log file, etc.)
Thanks