From: inet2024 at hotmail dot com Operating system: win2kas PHP version: 5.0.4 PHP Bug Type: OCI8 related Bug description: ora-12154 and other errors
Description: ------------ I am trying to get Oracle 10g to work with php5 on win2kas running IIS5. I have successfully installed all components and tested each. I have also installed oracle client, tested sqlplus and 3rd party products and ora-connect and ODBC are all working. I have set environment variables ORACLE_HOME, ORACLE_SID, ORACLE_BASE and TNS_ADMIN, and verified (printed) these from within a php program. The php_oci8.dll loaded successfully. The tnsnames.ora, sqlnet.ora and listener.ora are all configured and contain the correct SID and naming. I have tried to connect (see below) using both TNSNAMES and EZCONNECT methods, neither work. I have read and read and read on how to set this up, and all looks fine on my end - but no connect. Reproduce code: --------------- $db_connoci = ocilogon("username", "password", $db_db); where $db_db = ORACLE_SID (which has been verified correctly). also tried with $db_db = "\\hostname\Oracle_SID" (for EZCONNECT) Expected result: ---------------- Connection to Oracle Actual result: -------------- ORA-12154 -- Edit bug report at http://bugs.php.net/?id=34254&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34254&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34254&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34254&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34254&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34254&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34254&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34254&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34254&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34254&r=support Expected behavior: http://bugs.php.net/fix.php?id=34254&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34254&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34254&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34254&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34254&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34254&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34254&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34254&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34254&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34254&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34254&r=mysqlcfg