Bug #3131: Errors while connecting Oracle database

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