Re: Bug #3131: Errors while connecting Oracle database

hi - there might be a problem in php and/or apache or in the oracle-libs. we had similar reports -but- others are using php+oci8 on high volumne sites with no trouble. i am willing to investigate, but i cannot reproduce this kind of problems here, and nobody has manages to a) send me a working (=breaking) testcase or b) given me acces to a system where he could show me the problem. so - the best would be if cou could create a test-environment and *one* *short* script that produces this problem / maybe using the ab test-tool (part of the apache-dist). it looks to me like a memory overwrite somewhere - a working solution could be not to use the BEQ interface to oracle but instead going thru the listener process (ipc or tcp). in beq-mode oracle and apache/php communicate via shared-memory, if any php/apache function writes "by accident" into this area you can expect the unexpected to happen. again - (i hate to repeat myself over and over again) - if we can reproduce a problem and nail down a bug -> we'll fix it! tc On 7 Jan 2000 luvan@iname.com wrote: > From: luvan@iname.com > Operating system: Linux 2.2.5 > PHP version: 3.0.12 > PHP Bug Type: Oracle related > Bug description: Errors while connecting Oracle database > > We are using Oracle 8.0.5 and Apache 1.3.9 and we have following problems: > > 1. Ocassional loss of persistent connection to Oracle database. Oracle returns ORA-01041 or > ORA-03113. > > 2. When using non-persistent connect, OCIlogon fails (again occasionally) with ORA-12154, IMHO > as a consequence of error ORA-12545. We found out that after the first appearance of the error this > webserver process (one of Apache's sons) is not able to connect anymore and only possibility to > refresh the application is to kill it. > There is the file sqlnet.log in working directory with following messages: > ------ > Fatal NI connect error 12545, connecting to: > > (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp_hrouda_pre.world)(PROTOCOL=TCP)(Host=wwwcall)(Port=1 > 521)))(CONNECT_DATA=(SID=CCP)(CID=(PROGRAM=)(HOST=vl11823)(USER=nobody)))) > > VERSION INFORMATION: > TNS for Linux: Version 8.0.5.0.0 - Production > TCP/IP NT Protocol Adapter for Linux: Version 8.0.5.0.0 - Production > Time: 06-JAN-00 16:01:03 > Tracing not turned on. > Tns error struct: > nr err code: 12206 > TNS-12206: TNS:received a TNS error during navigation > ns main err code: 12545 > TNS-12545: Connect failed because target host or object does not exist > ns secondary err code: 12560 > nt main err code: 515 > TNS-00515: Connect failed because target host or object does not exist > nt secondary err code: 111 > nt OS err code: 0 > nt OS err code: 0 > ------ > > The database server is on the same machine as the webserver and Oracle vars are set in > Apache's environment. > > We mean that both problems (1. and 2.) have the same cause (somewhere in PHP, Apache or Linux > ??) > > We found similar problems in: > - bug #2487 > - > http://www.weberdev.com/forum/read.php3?num=1&id=854&thread=854& > > Appropriate files: > http://mujweb.cz/www/luvan/sqlnet.log > http://mujweb.cz/www/luvan/tnsnames_ora.txt (appr. part of > tnsnames.ora) > http://mujweb.cz/www/luvan/set-out.txt (output of set called > via PHP) > http://mujweb.cz/www/luvan/oci8.php (OCI itf functions from the > appl) > > Many thanks for helping us > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany