On Fri, 20 Feb 2004, hjr_at_dizwell.com wrote:
>
> "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> news:ud68asvld.fsf_at_standardandpoors.com...
>> On Thu, 19 Feb 2004, gooiditweg_at_sybrandb.demon.nl wrote:
>> > On 19 Feb 2004 11:12:17 -0600, Galen Boyer
>> > <galenboyer_at_hotpop.com> wrote:
>> >
>> >>The hard thing is that Oracle doesn't tell you what objects
>> >>were involved in the deadlock, and it can be anything.
>> >
>> > I don't think this is true. Ora-060 will always result in a
>> > trace file with detailed info about open cursors, lockmodes
>> > etc.
>>
>> Hm... Sets up a deadlock situation... Looks at trace file.
>>
>> I'll be damned. I solved an insidious deadlocking issue a few
>> weeks ago and didn't use that info. How many times do I have
>> to tell myself, just look at the trace file you dummy!
>>
>> --
>> Galen Boyer
>
>
> LOL! I remember the first time I got the "instance terminated
> disconnection forced' error message with 9i... panic!
> terror!... bloody Linux!!.. I thought I must have done the
> Linux or Oracle installs wrong, so was about to re-install the
> lot... when I thought, "hang on, let's just look at the alert
> log" -it's what I always drill into students, after all. Sure
> enough: incorrect undo tablespace name. Phew!
I wish I was able to join in with the "Phew", but alas, I did it
the old-fashioned way, I tried, cussed, tried something else,
cussed some more, tried something else, blamed someone who left
the company, tried something else, went for coffee...
--
Galen Boyer
Received on Thu Feb 19 2004 - 18:08:10 CST
