Grant - I have never encountered this one in Oracle. Are you receiving an
Oracle error number? It makes me wonder if it is a Cold Fusion message. Have
you received it outside of Cold Fusion? Check the Oracle logs, alert_log,
dump files, trace files. Check to see if there is a timeout parameter in
Cold Fusion that can be increased, or maybe in Oracle's listener.ora file.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L
..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 RequestOracle Error Code =0Timeout
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).