ID: 36250
Updated by: [EMAIL PROTECTED]
Reported By: fred dot cohen at iridium dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Solaris 9
PHP Version: 5.1.2
New Comment:
So you're effectively saying that OCIPing() which exists in OIC is not
supported by Oracle servers 8 and 9 and causes them to crash?
This sounds really.. hmm.. weird, because I was recommended to use
OCIPing() namely by Oracle developers.
Previous Comments:
------------------------------------------------------------------------
[2006-03-04 07:41:10] fred dot cohen at iridium dot com
It might be a good idea get the Server Version with a call to
OCIServerVersion rather than relying on the OCI_xx_VERSION defines.
Any of the developers care to comment?
#if OCI_MAJOR_VERSION >= 10 && OCI_MINOR_VERSION >= 2
/* OCIPing() is usable only in 10.2 */
OCI_G(errcode) = PHP_OCI_CALL(OCIPing, (connection->svc, OCI_G(err),
OCI_DEFAULT));
#else
char version[256];
/* use good old OCIServerVersion() by default */
OCI_G(errcode) = PHP_OCI_CALL(OCIServerVersion, (connection->server,
OCI_G(err), (text*)version, sizeof(version), OCI_HTYPE_SERVER));
#endif
------------------------------------------------------------------------
[2006-03-04 07:33:51] fred dot cohen at iridium dot com
Oracle is claiming OCIPing isn't a supported in anything less than
oracle 10.2
------------------------------------------------------------------------
[2006-02-01 19:49:51] fred dot cohen at iridium dot com
Description:
------------
This isn't a bug in PHP, but I'm submitting it since Oracle currently
has no patch available and it's cause isn't obvious.
Using the Instant Client 10.2 and PHP 5.1.2 connecting to Oracle
9.2.0.7 we began seeing ORA-07445 errors immediately after upgrading to
the versions listed. They may appear to occur intermittently, but they
can happen as frequently as the oci8.ping_interval value.
I've traced it down to the OCIPing call in the oci extension.
It turns out any calls to OCIPing cause the error in the server.
Workaround:
In php.ini [oci8] section, set:
oci8.ping_interval=-1
I'll provide updates about possible patches from Oracle as soon as
they're able to respond.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36250&edit=1
