Perl CGI Scripts - Oracle ORA-12514
Error Troubleshooting
Error Message (from Apache web server error_log file on
Linux/UNIX):
ORA-12154 Error while trying to retrieve text for error ORA-12514 (DBD
ERROR: OCIServerAttach)
Solution: Add environment variables to the Apache httpd.conf file for
proper execution of Oracle client software libraries by DBD::Oracle.
Customize the following configuration statements to include the pathnames
to the Oracle client software installed on your web server:
SetEnv ORACLE_HOME /v920
SetEnv LD_LIBRARY_PATH /v920/lib
PerlPassEnv ORACLE_HOME
PerlPassEnv LD_LIBRARY_PATH
