From: buhmann at teqneers dot de Operating system: WIN2k/Win2003/XP PHP version: 4.3.10 PHP Bug Type: OCI8 related Bug description: Already reproducable Bug #20006 cannot use 2 database connections
Description: ------------ I have to fight with the same problem up to the current release (4.9.10). It doesn't seems to be fixed. In my opinion adding more tnsnames to the oracle client isn't help enough. the oracle user have to be enough. I tried it on a win2k and win2003 server edition with oracle clients 8 and 9. always the same problem. opening the first connection works fine. also doing some selects with this connection. but, after opening a second connection and don't use it immediately, errors occurred. if i instead use the second connection immediately (doing a select or anything), it will also works correct. The errors will occurr (using the first connection) until i will use the second connection. Reproduce code: --------------- <?php /* test table 1, created on the first schema 'SCHEMA_1' ---------------------------- create table test1 ( dummy NUMBER(20) NOT NULL ); commit; ---------------------------- test table 2, created on the second schema 'SCHEMA_2' ---------------------------- create table test2 ( dummy NUMBER(20) NOT NULL ); commit; ---------------------------- */ function selectOne() { global $connectionOne; $select = 'SELECT * FROM test1'; $stmt = OCIPARSE( $connectionOne, $select ); OCIExecute( $stmt ); OCIFetchInto( $stmt, $arr, OCI_ASSOC ); OCIFreeStatement( $stmt ); } function selectTwo() { global $connectionTwo; $select = 'SELECT * FROM test2'; $stmt = OCIPARSE( $connectionTwo, $select ); OCIExecute( $stmt ); OCIFetchInto( $stmt, $arr, OCI_ASSOC ); OCIFreeStatement( $stmt ); } // make first connection $connectionOne = OCILogon( 'user1', 'pwd1', 'TNS' ); // select again from table test1 (connection 1) echo ' Start----- Test1 Con1 -----------------------<br />'; selectOne(); echo ' End------------------------------------------- <br /> <br /> <br />'; // make second connection $connectionTwo = OCILogon( 'user2', 'pwd2', 'TNS' ); // select again from table test1 (connection 1), this will result in an error echo ' Start----- Test1 Con1 -----------------------<br />'; selectOne(); // ===> if you will make a selectTwo() instead off a // ===> selectOne() at this point, now errors occurr! //selectTwo(); echo ' End------------------------------------------- <br /> <br /> <br />'; // select from table test1 (connection 1) echo ' Start----- Test1 Con1 -----------------------<br />'; selectOne(); echo ' End------------------------------------------- <br /> <br /> <br />'; // select from table test2 (connection 2) echo ' Start----- Test2 Con2 -----------------------<br />'; selectTwo(); echo ' End------------------------------------------- <br /> <br /> <br />'; // select again from table test1 (connection 1), this will work now echo ' Start----- Test1 Con1 -----------------------<br />'; selectOne(); echo ' End------------------------------------------- <br /> <br /> <br />'; ?> -- Edit bug report at http://bugs.php.net/?id=31898&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31898&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31898&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31898&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31898&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31898&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31898&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31898&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31898&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31898&r=support Expected behavior: http://bugs.php.net/fix.php?id=31898&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31898&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31898&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31898&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31898&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31898&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31898&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31898&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31898&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31898&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31898&r=mysqlcfg