Are the database definitions in the local tnsnames.ora file? Or is that
local file pointing at another server to get the database definitions? We
had problems with the local tnsnames.ora file pointing at another server to
find out where the databases were. Everytime that server was rebooted,
etc., we got the same message. We got the DBAs to push the tnsnames.ora
file out to our web servers whenever they made changes and we've been fine
since.
Dan
-----Original Message-----
From: Carlson, Kevin
To: '[EMAIL PROTECTED]'
Sent: 7/17/2000 5:46 PM
Subject: Intermittent Oracle error msg
This is a strange problem, which I haven't found in the Allaire
Knowledge
Base or HouseOfFusion Archives, so here goes:
After several months of successfully running CF Server 4.0.1 on Solaris,
we
are experiencing episodes during which there is an Oracle error message
on
every query, as follows:
Oracle Error Code = 12154
ORA-12154 TNS:could not resolve service name
Yet, when the same SQL is pasted into SQL*Plus on my PC, the query
executes
fine!
I've seen this error message on a PC before, when "SQL Net Easy
Configuration" had missing or incorrect settings. This doesn't explain
the
intermittent nature of this problem, or how to ultimately fix it. Our
DBA
can find nothing wrong.
Has anyone else experienced this phenomenon? Any recommendation to
solve
it?
Thanks much,
Kevin Carlson
Quality Systems Engineer
AT&T Wireless Services
------------------------------------------------------------------------
------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
