From: sixd Operating system: All PHP version: 5.4.7 Package: OCI8 related Bug Type: Bug Bug description:Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro
Description: ------------ The error ORA-00028 "your session has been killed" should be added to the PHP_OCI_HANDLE_ERROR macro. This would allow a connection that was killed with ALTER SYSTEM KILL SESSION to be directly marked for re-establishment. Currently after getting ORA-00028, reusing the connection gives ORA-01012 which causes the cleanup. Adding ORA-00028 would reduce the number of operations needed to recover from a DBA killing a session: after getting ORA-00028 the next connection reuse would "work" because OCI8 has reopened the connection. -- Edit bug report at https://bugs.php.net/bug.php?id=63265&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=63265&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=63265&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=63265&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=63265&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=63265&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=63265&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=63265&r=needscript Try newer version: https://bugs.php.net/fix.php?id=63265&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=63265&r=support Expected behavior: https://bugs.php.net/fix.php?id=63265&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=63265&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=63265&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=63265&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=63265&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=63265&r=dst IIS Stability: https://bugs.php.net/fix.php?id=63265&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=63265&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=63265&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=63265&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=63265&r=mysqlcfg