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 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. -- 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).
