Grant,
ColdFusion does not use Oracle natively, but through ODBC. I have seen this
in the past and it's an ODBC setting that's causing the problem. Find out what
ODBC driver their using. Look for a timeout setting, I know that DataDirect
driver has one on the general panel.
Dick Goulet
____________________Reply Separator____________________
Author: [EMAIL PROTECTED]
Date: 9/11/2002 4:43 PM
..apologies this should have read v8.1.6 ....if that makes any difference.
This problem is occurring within our production domain so *any*
assistance would be greatly appreciated.
Many thanks
GH
Grant G Holyoake
11/09/2002 17:56
To: [EMAIL PROTECTED]
cc:
Subject: Timeout while obtaining an oracle connection lock
Is this part of a business decision process?:
v8.1.7
solaris 2.6
E10k domain/SAN
Coldfusion application receives the following Error Msg:
Error Occurred While Processing Request....Oracle Error Code =0....Timeout
while obtaining an oracle connection lock....[<simple> select statement].
CF uses native drivers to connect to oracle instance. Nothing in logs or
trace files. Tried using 'cookies' default client storage setting in lieu
of 'database' however still no luck.
We recently moved our instances to SAN however we don't appear to have any
other latency issues/problems
TIA
Grant Holyoake
Important: This e-mail is intended for the use of the addressee and may contain
information that is confidential, commercially valuable or subject to legal or
parliamentary privilege. If you are not the intended recipient you are notified
that any review, re-transmission, disclosure, use or dissemination of this
communication is strictly prohibited by several Commonwealth Acts of Parliament.
If you have received this communication in error please notify the sender
immediately and delete all copies of this transmission together with any
attachments.
<br><font size=2 face="sans-serif">..apologies this should have read v8.1.6
....if that makes any difference. This problem is occurring within our
production domain so *any* assistance would be greatly appreciated.</font>
<br><font size=2 face="sans-serif">Many thanks</font>
<br><font size=2 face="sans-serif">GH</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Grant G Holyoake</b></font>
<p><font size=1 face="sans-serif">11/09/2002 17:56</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To:
[EMAIL PROTECTED]</font>
<br><font size=1 face="sans-serif"> cc:
</font>
<br><font size=1 face="sans-serif"> Subject:
Timeout while obtaining an oracle connection lock</font>
<br><font size=1 face="sans-serif">Is this part of a business decision process?:
</font></table>
<br>
<br><font size=2 face="sans-serif">v8.1.7</font>
<br><font size=2 face="sans-serif">solaris 2.6</font>
<br><font size=2 face="sans-serif">E10k domain/SAN</font>
<br>
<br><font size=2 face="sans-serif">Coldfusion application receives the following
Error Msg:</font>
<br>
<br><font size=2 face="sans-serif">Error Occurred While Processing
Request....Oracle Error Code =0....Timeout while obtaining an oracle connection
lock....[<simple> select statement].</font>
<br>
<br><font size=2 face="sans-serif">CF uses native drivers to connect to oracle
instance. Nothing in logs or trace files. Tried using 'cookies'
default client storage setting in lieu of 'database' however still no
luck.</font>
<br>
<br><font size=2 face="sans-serif">We recently moved our instances to SAN
however we don't appear to have any other latency issues/problems</font>
<br>
<br><font size=2 face="sans-serif">TIA</font>
<br><font size=2 face="sans-serif">Grant Holyoake</font>
<br>
<br>
<br><CODE><FONT SIZE=3><BR>
<BR>
Important: This e-mail is intended for the use of the addressee and may contain
information that is confidential, commercially valuable or subject to legal or
parliamentary privilege. If you are not the intended recipient you are notified
that any review, re-transmission, disclosure, use or dissemination of this
communication is strictly prohibited by several Commonwealth Acts of Parliament.
If you have received this communication in error please notify the sender
immediately and delete all copies of this transmission together with any
attachments.<BR>
</FONT></CODE>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
