In one of our Linux based web servers using Oracle 11g database and DBI DBD perl modules , we observed a peculiar error where on accessing a web page , below error was reported
Error Observed :
ORA-24365: error in character conversion
The character set used and the function calls were proper.
Solution :
After lot of searching , few possible reasons for this error was found to be , when using DBI & DBD modules for Oracle - if ORACLE_HOME environment is not set in the webserver configuration , then those library functions may return this error.
- In our case we used Apache HTTPD web server, so we added our DB install directory in httpd.conf configuration file.
- SetEnv ORACLE_HOME "/u01/product/db_1"
- Restarted the web services , after which error was not observed.
Hope this helps to some.