Problem with Apache, Oracle, OS ????????

[Henrique Silva_3]

I must have hit the wrong button here, and sent nothing !!! :-(

Anyways, this problem is puzzling.

Brand new N class server, running HPUX 11 64 bit, oracle 8.1.7.3 64 bit, with latest patch set ( 8.1.7.4 ), and both oracle's default apache install and another apache install, and netscape web server installed ).

The problem is that a C program, when runs from the command prompt of a unix user, works fine, by querying the DB, via the listener, but when running as a cgi-bin program from apache, or netscape web server, it fails to open the DB.

The error log is also weird, for there is a sqlnet.log error log under the apache log files, where the SID name is * and the service name is the SID, say TEST concatenated with a ., or TEST. !!!!!

Since I had problem in the past with some perl programs spawning other shells and having the environment not being passed, we modified the C probra to make a call to source the .profile before and after trying to open the DB connection, and we print the environment values as well, and the SID and ORACLE_HOME are correct !!!

So, when running from command prompt, it does work fine, from within apache or netscape web servers, it fails.

This is not the case on the developmental box, which is running hpux 11, 32 bit, with oracle 8.1.7.3 as well.

We are trying to find out if there are any patches that need to be loaded, but the 64 bit box has the latest patches on it. Also, we are trying to find another box, that we can install everything, to see if the problem is the installation, since the developmental box could have somethings that were not installed on the pre-production box.

In any case, if you have ANY IDEA here, it would be great !!!

Thanks,

Henrique Silva

[Raynald Boucher]

Sorry I don't remember the service note.
We encountered a problem when upgrading to 8.1.7.4 where the max user processes where specified too low. We modified some kernel prameters as er Oracle's instructions and have been fine since.

A littl research on metalink should find the note.

[Henrique Silva_3]

Thanks Raynald.

Is this OS kernel parameter or Oracle number of processes ? The kernel parameters for HPUX have all been set at proper levels. I can increase the number of Oracle processes, but I do not see how that would have a problem with the connection from within Apache, since the program works fine from the command line.

Yesterday, they tried from another web server to their development box, and it worked fine. They will try from that box over to our pre-production box on MOnday, since they do not work today, and if that does not work, then, we know it is a problem with Oracle listener, or something like that, since it works going to their development box.

Can anyone think of anything oracle related here ? You can do all basic connections from sqlplus. You can use SID name or global name or no name at all and login to the environment on your shell, and it works, but when you run it from the CGI bin, it does not.

My guess was bad environment, or, permissions on the apache server. Since I am not too familiar with that, and their apache gurus say there is nothing wrong, here we are, and to make matters worse, the same program that works on their development box, does not work on the pre-production one !!! :-((((

IDEAS ???????//////

Henrique Silva