---------------------------------------------------------------------------- ----------------- Disclaimer: The information contained in this email is intended only for the use of the person(s) to whom it is addressed and may be confidential or contain legally privileged information. If you are not the intended recipient you are hereby notified that any perusal, use, distribution, copying or disclosure is strictly prohibited. If you have received this email in error please immediately advise us by return email at [EMAIL PROTECTED] and delete the email document without making a copy. ---------------------------------------------------------------------------- ----------------- I always compile PHP (with exactly the same config) with --enable-sigchild and as a CGI not module. I had similiar problems until i took both these steps. (I think we also moved away from Plogon due to not using the PHP module anymore) I assume you've patched 8.05 (i had to connect to ora 7.3.3 on a remote machine) You problem 'could' be 1. Improperly configured Oracle on the DB server end (maybe a limit to no. of connections?) 2. Not using --enable-sigchild 3. Not using PHP as CGI 4. Not patching Ora 8.0.5 Or simply that when a CGI process die it dies a lot more quietly... and the users simply rerun the page. Just some gueses but i have 3 boxes configured the way you describe access remote Oracle DB servers (7.3.3 to 8.1.6) and they work reliably. The whole sites are oracle driven, but only receive 100 hits or so an hour. (so it could be something due to load i havent experienced) mn Mark Nold [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Senior Consultant Change is inevitable, except from vending machines. -----Original Message----- From: Chien-Pin Wang [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:21 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Wierd OCI Problem... [Urgent, and please help] Dear all, My server is running RedHat6.2/Apache 1.3.14/PHP 4.0.4pl1/Oracle 8.0.5. The way I make connection from PHP to Oracle is through php's Oracle 8 extension OCIPLogon. Since the server was made available to the public, *EVERY ONCE A WHILE* I got error messages logged in apache's error log as found in the attachement (sorry the oracle message is in Big5 characters). The error sequence starts with ORA-00022, saying 'invalid session id; access denied', but a connection resource is returned. Then all kinds of ORA-/PLS- errors come after it. The persistent connection affects only the attached apache process, not everyone. That explains when user reload the page, the problem cannot be reproduced everytime. The only way I've found to stop it is by restarting apache. I use quite a lot of Oralce stored procedures and return query results by cursor variables. But I doubt this the reason to it. My guess is that somewhere between apache process and oracle connection is interrupted. I've been working on this issue for a while but got no clue now to move any further. When errors come, the error log got filled up pretty quick. Please help......, and thanks in advance. Chien-pin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
