ID: 21897 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: OCI8 related Operating System: Solaris PHP Version: 4.2.3 New Comment:
Also this error occurs sometimes: Warning: OCISessionBegin: ORA-24327: need explicit attach before authenticating a user in /htdocs/e-academy.eui.at/www/oci8test.php on line 4 Error: 24327 Error: ORA-24327: need explicit attach before authenticating a user currently I'm sitting here at the customer and try to track down the problem. Any quick tips would be great. There are other webs running on this system using java without problems. Maybe there are problems running php + tomcat on the same apache at the same time?! Previous Comments: ------------------------------------------------------------------------ [2003-01-27 14:49:15] [EMAIL PROTECTED] One more thing, the bug #1539 looks like a similar problem: http://bugs.php.net/bug.php?id=15390 If you consider it relevant, please comment under that bug instead of duplicating it at this point. Maxim Maletsky ------------------------------------------------------------------------ [2003-01-27 14:36:00] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Actually, I think Michael's is the most probable answer. Check out these places: http://dbforums.com/t584473.html http://dbforums.com/showthread.php?threadid=496655 http://home.clara.net/dwotton/dba/ora3113.htm http://www.google.com/search?q=Ora-03113+solaris&hl=en&lr=&ie=UTF-8&oe=utf-8&start=20&sa=N As you can see, this randomly hapens for various *nix installations and the most tipical case is the misconfiguration of the Oracle enviroment. As was also mentioned "Oracle's way to say you misconfigured him". Thus, I doubt this is really php's oci8 extension that causes it. Try also using SQL*Plus and see whether you get it. I'd be worried if this only happens connecting to Oracle thought PHP. If so, then please post us the full PHP code and/or anything you might have discovered. Maxim Maletsky ------------------------------------------------------------------------ [2003-01-27 12:37:40] [EMAIL PROTECTED] Make sure you set the environment variables mentioned on <http://de3.php.net/manual/de/ref.oci8.php> before you start your httpd. _Don't_ set them in PHP with putenv() or in httpd.conf with SetEnv. If this doesn't help, maybe you can find the cause of the problem by reading <http://www.oracle-error.com/ora-03113.htm>. ------------------------------------------------------------------------ [2003-01-27 04:24:39] [EMAIL PROTECTED] This error occurs very often but not allways: FEHLER: Database error: ALTER SESSION SET NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS" Oracle8 Error: O (ORA-03113: end-of-file on communication channel ) Session halted. Warning: failed to rollback outstanding transactions!: ORA-03114: not connected to ORACLE in Unknown on line 0 it seems that the Oracle connection died, but the oci8 extension doesen't know this. The sql-statement above is the first after OCIPlogon(), changing to OCINLogon() doesen't solved this problem. We run the same application on other platforms with Oracle without any problems, this problem seems to be Solaris related. The Oracle Version is 8.1.7.4. Apache 1.3.26. The problem also occurs with PHP4.1.1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21897&edit=1