#24343 [Opn->Fbk]: Oracle 9.2.0 client libs do not work

ID: 24343 Updated by: sniper@php.net Reported By: thomas at fivemile dot net -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Redhat Linux 8.0 PHP Version: 4.3.3-dev New Comment: Try adding "ociinternaldebug(1);" in the beginning of your script. That'll make the functions to print out some extra debugging information. Previous Comments: ------------------------------------------------------------------------ [2003-07-13 05:54:10] thomas at fivemile dot net Okay, once again, slowly. - installed a fresh oracle 9.2.0 - installed a fresh apache with PHP and linked against oracle - does NOT work - copied over the entire /opt/oracle/product/9.0.1 tree from another machine where the libs work - installed a fresh apache with PHP linked against those other libs - CHANGED the environment vars so the 9.0.1 libs are used instead of the 9.2.0 libs - now it works - NO thanks to wild guesses from the bugs team. i have installed a couple of working oci/php combos so far, the 9.2.0 is the first one where i ran into these kind of problems. And you can't earnestly expect new users to fiddle with libs for 2 weeks till their oci bindings start to work... If you like, you can have an account on the box in question and have a look around yourself. However i am NOT satisfied with the answer 'okay, you made a crude hack, and by chance it worked, now use it and stop bugging us' ------------------------------------------------------------------------ [2003-07-08 11:40:16] sniper@php.net Then use those. Wild guess: The SAME environment vars don't work with DIFFERENT oracle version.. ------------------------------------------------------------------------ [2003-07-08 10:52:15] thomas at fivemile dot net the SAME script on the SAME machine works with the 9.0.1 client libs I copied over from the other machine. Only the 9.2.0 client libs (using the SAME script, the SAME php, the SAME apache and the SAME configure line) do not work. ------------------------------------------------------------------------ [2003-07-07 19:29:08] sniper@php.net Try a script which has ONLY that one line. And you're sure your username/password doesn't contain any illegal chars? And your db name is tns.domain ?? ------------------------------------------------------------------------ [2003-06-26 18:36:52] thomas at fivemile dot net Warning: ociplogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid character in /home/httpd/index.php3 on line 3 or Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00922: missing or invalid option in /home/httpd/index.php3 on line 3 'Line 3' is simply the OCILogon or OCIPLogon as follows: $ohnd = OCILogon("dvd","hidden","tns.domain"); ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/24343 -- Edit this bug report at http://bugs.php.net/?id=24343&edit=1