Re: php and oracle

Hi, we are not really trained in analyzing Oracle-logs. I've been using Mysql and Mssql for years, but the migration was more difficult, than I thought. In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know, where to start... du -sch * 1.5G bdump 166M cdump 28K create 8.0K pfile 282K udump 1.7G total well, for the apache-problem, I've found an "solution" (not the straight way, but it seems to work so far): using apache_child_terminate doesn't work (probably apache2 compiled against nptl (linux kernel 2.6), apache_child_terminate doesn't work in an multi-threaded env) so I cought the php-error using set_error_handler. Inside of this error-method, I did an "posix_kill(getmypid(),15);" I know, I won't win the programmers Nobel-Prize for that crap, but it works so far; dropped connections are reconnected. Dieter Christopher Jones sagte: > > D.Wilkening wrote: > >> Hi everyone, >> >> i've a problem using php with oracle 10g. >> (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) >> One or two days, everything looks good. Then, by pressing (once a >> second) >> reload in your browser, you sometimes get an >> ERROR #: 2 >> ERROR DESC: oci_execute() [<a >> href='function.oci-execute'>function.oci-execute</a>]: OCIStmtExecute: >> ORA-03114: Nicht mit ORACLE verbunden >> >> restarting apache solves the problem, but is no real option. >> My first idea was the connection pooling, so i tried a ocilogon instead >> ociPlogon, but the problem dodn't solve. >> >> Any Ideas? >> >> Thank you in advance >> > > Are there any clues in the database trace files? > > Chris >