Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: strange TNS-12154

Re: strange TNS-12154

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 06 Jan 2004 12:09:24 -0600
Message-ID: <>


Sever based, client based . . . . they are all clients to Oracle. I'm still waiting to hear back from the developer as to where he was executing his stand-alone vb code vs. the ASP code. If they were both being executed on the web server box . . . .

I don't understand your assertion that "IIS does not like an Oracle client information in other server." What does IIS know or care about anything to do with Oracle? Is IIS standing *between* the ASP code and the Oracle SQL*Net interface? I don't think so, but could be wrong. Actually, between several test and prod web servers, we have a mix of configurations . . . some with their own local TNSNAMES, some with TNS_ADMIN pointing off to another server. We've never had a technical problem with either. (Administrative problems are a different question!)

On 3 Jan 2004 21:22:32 -0800, (Peter Chong) wrote:

>Hi, Ed
>First of all, ASP is Server base application and Vb is client base
>And Second of all, IIS does not like an Oracle client information in
>other server, It like to keep the Oracle infomation in same IIS
>Peter C.
>Ed Stevens <nospam_at_noway.nohow> wrote in message news:<>...
>> Oracle 8.1.7 client on Win2k server
>> Oracle db on different Win2k server
>> Background -- we keep a central TNSNAMES file in a non-Oracle
>> directory on one of our main DB servers. Let's say it is on dbsvr01at
>> x:\app_info with the \app_info directory shared as app_info. As part
>> of the Oracle client installation, whether on a desktop or a web or
>> app server, we set TNS_ADMIN=\\dbsvr01\app_info. We set this into
>> arrangement has been rock-solid for us for several years.
>> Got a msg from a developer working with some web apps that he had been
>> getting TNS-12154 (could not resolve service name) errors from some
>> new ASP modules he had just placed on the web server. He said the asp
>> code returned the tns-12154, but when he took the code out of the asp
>> and created a simple vb exe, it worked ok. He then added the
>> 'missing' tnsnames entry to the local tnsnames file (there is a
>> security issue I need to address, but is not germaine to my question)
>> the asp page worked.
>> Problem is, with the registry entries set the way they are (and I
>> confirmed myself that they are correct) I don't understand how
>> anything he could have done to the local tnsnames could have had any
>> effect. Or, alternatively, why the simple vb exe would have worked,
>> but the asp page didn't.
>> I don't know much about how these asp pages are put together, so I ran
>> it past another developer that I trust, and she couldn't come up with
>> an explanation either.
>> So I'm on a bit of a fishing expedition . . . and am running out of
>> bait. Does anone have any ideas?
Received on Tue Jan 06 2004 - 12:09:24 CST

Original text of this message