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.


Christopher Jones sagte:
> D.Wilkening wrote:
>> Hi everyone,
>> i've a problem using php with oracle 10g.
>> (php 5.0.1 compiled against Oracle, 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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to