Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Apache & Oracle on NT 4.0
In article <94t5lg$pnd$1_at_nnrp1.deja.com>,
Vince Law <law_vince_at_my-deja.com> writes:
> I wrote a javabean and when I ran it as a standalone app, the
> connection through OCI to the Oracle DB is perfectly fine, but when I
> ran it behind the Apache WebServer, it then kept saying that "can not
> resolve the tns service name". I already checked the whole computer to
> make sure that there is only one tnsnames.ora file exists. I guess, it
> must be that I need to set some where to tell the Apache where to find
> the tnsnames.ora file. Any idea which file I need to set or any
> environment variable? By the way, I am using NT 4.0.
Assuming the Unix version is similar to NT, you need to set up the SQLNET.ORA / TNSNAMES.ORA in the Oracle Home where IAS is installed, probably $ORACLE_HOME\network\admin\*.ora.
-- Regards, RichardReceived on Sun Jan 28 2001 - 04:43:51 CST