Re: (Fwd) Just a quick question on the DBI perl mod



John Scoles wrote:
ORA-24315 is a tricky one.
Seems this has cropped up the odd time with a number of different system
(seen the same in PHP). It could be that your session is timing out so
DBD::Oracle cannot get a handle or it could have something to do with the
oracle language settings. Check with you DBA and see if you have any
special features set on you DB.

Incomprehensible errors at connect time can be cause by version
mismatches. The following three things should be the same.

1. The version of the Oracle client which was used in the
compilation of DBD::Oracle.

2. The version of of libclntsh.so which is dynamically linked
when DBD::Oracle is loaded at run-time.

3. The version of the Oracle client pointed to by ORACLE_HOME
at run-time.

(3) is not relevant for Instant Clients, as they do not fetch
auxiliary files via ORACLE_HOME.

A possible explanation of the OP's problem is that the Oracle
client installation he is using has been upgraded since his
DBD::Oracle was compiled. Other possibilities are that the
DBD::Oracle was compiled using a different ORACLE_HOME than
tha used at run-time, or that dynamic linking is being done
wrongly.

--
Charles Jardine - Computing Service, University of Cambridge
cj10@xxxxxxxxx Tel: +44 1223 334506, Fax: +44 1223 334679
.



Relevant Pages

  • Re: Errors Installing
    ... What did you set as ORACLE_HOME and LD_LIBRARY_PATH during your compilation? ... Where did you install the full oracle client? ... Either write something worth reading or do something worth writing. ...
    (perl.dbi.users)
  • Re: Running oracle 8 or oracle 9 on RedHat9.x
    ... > The machine has to run RedHat, and newest version would be good. ... the compilation works but PHP does not. ... installation or Oracle client? ... PHP needs an Oracle client to be compile --with-oci8. ...
    (RedHat)
  • PHP and Oracle Client
    ... I spent a couple of hours trying to figure out why PHP would not connect to Oracle using OCI8 functions while ODBC functions and TOAD worked fine. ... I eventually launched Systernal's "Filemon" utility and found out that Apache was looking for a file called "ORAOCIEI10.DLL", which was nowhere on my hard disc. ... If "php_oci8.dll" is binded to an specific oracle client library, why is it version 10 and not something newer? ...
    (comp.databases.oracle.misc)
  • Re: PHP, ODBC, Oracle
    ... > does anyone know the reason of displaying this error message: ... > The Oracle client is installed on the same machine as the Apache with ... > PHP and the ODBC sources are configured properly. ... > with MS Access and SQL Server but does not want to work with the PHP ...
    (comp.lang.php)
  • OCI and resluts question
    ... I am using FC2 with php 4.3.10 and 10g oracle client. ... when I run a query on the DB I get back several fields ...
    (comp.lang.php)