From: oguilloux at sopragroup dot com
Operating system: Windows 2000 SP4
PHP version: 5.0.0
PHP Bug Type: OCI8 related
Bug description: Crash attemping to connect Oracle via oci8 when database is not
mounted
Description:
------------
Using oci8 extention for connecting Oracle Database crash PHP (with and
without Apache) when SID isn't found.
I'm working with PHP 5 (13 july version), Win 2K SP4. My oracle client is
8.1.7 and I wish connected to a Oracle 9.2.0.4 database. In PHP4, I had no
problems in oci8, but now, PHP crash.
The SOLUTION is to use oracle extention which work even if database has
some trouble.
In my PHP.INI, I use :
extension=php_gd2.dll
extension=php_oracle.dll
extension=php_oci8.dll
extension=php_sockets.dll
extension=php_mbstring.dll
extension=php_zip.dll
Reproduce code:
---------------
$argDatabasename = 'PNGRS24';
$cn = OCILogon('SYSTEM','MANAGER',
"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RS24.PA.SOPRA)(PORT=1542))(CONNECT_DATA=(SID=$argDatabasename)))");
// BUT with ORACLE_LOGON() (not oci8) it's work !
Expected result:
----------------
That oci8 does work as well as oracle extention in PHP 5
Actual result:
--------------
(IN EVENTVIEWER, WITH LOG IN SYSINFO)
FOR APACHE 1.3.29 / PHP5
------------------------
Application popup : apache.exe - Erreur d'application : L'instruction ą
"0x01822456" emploie l'adresse memoire "0x00000008". La memoire ne peut
pas etre "read".
WITH PHP5 logs
--------------
PHP Warning: ociplogon() [<a
href='function.ociplogon'>function.ociplogon</a>]: _oci_open_server:
ORA-12514: TNS : le listener n'a pas pu resoudre le SERVICE_NAME figurant
dans le descripteur de connexion in c:\work\WEB\LookSGBD.php on line 31.
IN DEBUGGER
-----------
My debugger tell me that it's crashed on php_oci8.dll at this code line
(stack):
01492456 cmp dword ptr [eax+8],2
--
Edit bug report at http://bugs.php.net/?id=29444&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29444&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29444&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=29444&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=29444&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=29444&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=29444&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=29444&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=29444&r=support
Expected behavior: http://bugs.php.net/fix.php?id=29444&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=29444&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=29444&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=29444&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29444&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=29444&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=29444&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=29444&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=29444&r=float
