Apache users can't login

[Doug_85]

We're running Apache web server on a L class server with HP-UX 11.0. Our users receive ORA-12154 error when they try to log in. Using sqlplus you can log into the database but not from any browser. The tnsnames.ora file seems to be configured properly. This problem just occurred yesterday afternoon and we're trying to find a quick solution.

Thanks,
Doug

[Steven E. Protter]

This is most likely due to an incorrect tnsnames.ora and/or sqlnet.ora file on the client desk top.

What are the results from a tnsping query?

What if any change has happened to client or server configuration?

Has there been a change to the DNS records on the network? do the clients and servers use the same dns server. If not were records changed on the one the client uses?

SEP

[Doug_85]

The configuration to the client and server has not changed. Our DBA performed a tnsping and verified that we're connecting to the database. I will check with our networking section to verify any DNS changes.

Thanks,
Doug

[Doug_85]

I just checked with our networking section and no DNS changes have been made.

Thanks,
Doug

[Doug_85]

Here's the complete error that's received when the user tries to log in.

Error - There was an error with the database.
Please inform your DBA. The Error was: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach)
The SQL statement that produced the error is: Problem during login! CHECK ALL YOUR ENV VARIABLES!!! called in(CTDBOBJ)
Click the Back arrow above to go to the previous page!

Thanks,
Doug

[James A. Donovan · Accepted solution]

What is your version of Oracle? There are known issues with version 8.1.6 (fixed in 8.1.6.3 and higher)

Otherwise, make sure that the application environment is being set correctly prior to Apache starting. TNS_ADMIN and such like need to be set appropriately.

[Doug_85]

Our oracle environment has recently changed to 8.1.7. I've found some information that states we need to change the following settings:

SetEnv ORACLE_HOME /v920
SetEnv LD_LIBRARY_PATH /v920/lib
PerlPassEnv ORACLE_HOME
PerlPassEnv LD_LIBRARY_PATH


Where do you set these variables in the httpd.conf file?

Thanks,
Doug