PHP 4.0 Bug #10215: OCI Interface error when compiled statically with Apache

From: jclin@rocketmail.com Operating system: Linux PHP version: 4.0.4pl1 PHP Bug Type: Oracle related Bug description: OCI Interface error when compiled statically with Apache If I were to compile the OCI interface with Apache statically and call OCILogin(), php returns: Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /usr/local/webmail/htdocs/oracle.php on line 9 Database connection (SID=b888) failed I have double check tnsnames.ora and it appears to be fine. I even test it using Oracle's manager to check it and us php binary command, it works fine. PHP and Oracle works fine if I were to compile the OCI with PHP as a binary not if I were to compile it with Apache statically. I am using Apache 1.3.14. that is wierd. Can you give any suggestion ASAP. Appearantly there is a bug in php. By the way Apache somehow generates core dump. -- Edit Bug report at: http://bugs.php.net/?id=10215&edit=1