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

ID: 24343 User updated by: thomas at fivemile dot net Reported By: thomas at fivemile dot net -Status: Bogus +Status: Open Bug Type: OCI8 related Operating System: Redhat Linux 8.0 PHP Version: 4.3.3-dev New Comment: 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' Previous Comments: ------------------------------------------------------------------------ [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"); ------------------------------------------------------------------------ [2003-06-26 18:30:36] sniper@php.net With what script and what errors do you get..? ------------------------------------------------------------------------ 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