|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #63265 Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro
Submitted: 2012-10-12 02:09 UTC Modified: 2012-10-12 02:09 UTC
From: Assigned: sixd
Status: Closed Package: OCI8 related
PHP Version: 5.4.7 OS: All
Private report: No CVE-ID:
 [2012-10-12 02:09 UTC]
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.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-10-12 02:09 UTC]
-Assigned To: +Assigned To: sixd
 [2012-10-19 01:56 UTC]
Automatic comment on behalf of sixd
Log: Fixed bug #63265 (Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro)
 [2012-10-19 01:56 UTC]
-Status: Assigned +Status: Closed
PHP Copyright © 2001-2014 The PHP Group
All rights reserved.
Last updated: Fri Apr 18 15:02:26 2014 UTC