Oracle 9 client will work with either version, but the Oracle 8 client will only support that version. Each new version is backward-compliant only. Regards...Michael ----- Original Message ----- From: "Johan Kruger-Haglert" <aliquis@xxxxxxxxxxxx> To: <redhat-list@xxxxxxxxxx> Sent: Wednesday, October 22, 2003 7:28 AM Subject: Re: Running oracle 8 or oracle 9 on RedHat9.x > On Wed, Oct 22, 2003 at 08:47:19AM -0400, Reuben D. Budiardja wrote: > > What installation "just hangs with a gray window and 100% CPU usage"? PHP > > installation or Oracle client? > > Installation of oracle 8.1.7 (which is the only one who got a graphical java > installer) > > > You said PHP compilation works, but it does not work. I'm not sure I > > understand you completely. What does not work? Can you write a PHP script > > that connect to your Oracle database and see if it works with simple query? > > The compilation works, that is, i can make PHP without any errors > against the oracle database. However PHP does not work correctly. And > no, a simple query does not work since i get any of a few errors, the > one which is "most correct" is probably "ORA-03117: two-task save area > overflow". Sorry for not mentioning that one but i forgot it :/ > > > Are you using PHP as an apache module? If yes, what version of Apache? Send us > > / cut & paste the apace log files (access_file and error_log) when you tried > > your script from Web app. Check the error_log to see if there is a Seg Fault > > there. > > Yes, and this is how my error_log looks: > > [client 10.101.17.7] PHP Warning: Call-time pass-by-reference has been > deprecated - argument passed by value; If you would like to pass it by > reference, modify the declaration of ocifetchinto(). If you would like > to enable call-time pass-by-reference, you can set > allow_call_time_pass_reference to true in your INI file. However, > future versions may not support this any longer. in > /usr/local/webroot/index.php on line 23 > [client 10.101.17.7] PHP Warning: ocilogon(): _oci_open_server: Error > while trying to retrieve text for error ORA-12546 > in /usr/local/webroot/index.php on line 10 > > I can't find an entry with the 03117 error. > > > PHP needs an Oracle client to be compile --with-oci8. Are you able to just run > > plain "sqlplus" console and connect to your database? > > Yes, oracle 9.2 works like it should, but PHP 4.3.x seems to have no > support for it so i wanted to install the oracle 8.x client aswell but > it's installer hangs. > > > I suggest these: > > 1. Make sure your Oracle client works and can connect to your oracle server > > (assuming you're sure the oracle server works). I don't know if you can use > > Oracle8 client for Oracle9 server. But why don't you just use oracle9 client > > as well? > > because php doesn't work with the oracle 9 client. > > > In any case, make sure you can run and connect and run query with > > "sqlplus" console on the linux machine where PHP is going to be installed. > > sqlplus works like it does, so does other oracle tools. > > > 2. Compile PHP and make sure the compile really works. There should be > > messages at the end of the compile (or maybe configure, I don't remember > > exactly) to make sure that your Apache is compiled with certain library, > > otherwise you may get seg fault. Please do that. > > i know it works and phpinfo() shows oci8 support in the information > table. > > > 3. If you've installed PHP with make install, see if it works, check the > > apache error_log and see what's going on. > > i can execute phpinfo() in a phpscript so there is nothing wrong with > php, it just can't talk to the oracle 9 client. > > > FWIW, I've installed Oracle9 client + server on Redhat 7.3, compile latest > > stable PHP --with-oci8 and use it as apache module for latest apache 1.3.27 > > and it works fine. > > weird, since i use latest stable php with --with-oci8 against oracle 9. > Do i have to install some special client version of oracle9 aswell? > Shouldn't all those tools be in the oracle 9 enterprise server > installation? i do have sqlplus for example. I do use apache 2.x instead > thought. > > > Hope that helps. > > RDB > > thanks for all the suggestions. > > > -- > redhat-list mailing list > unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe > https://www.redhat.com/mailman/listinfo/redhat-list > -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
