running catblock.sql and utllockt.sql

From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Fri, 11 Apr 2003 15:38:02 GMT
Message-ID: <ujBla.98495$B54.2725348@news1.telusplanet.net>

One of our new apps is freezing due to a large number of blocking locks accumulating, I have been able to view the locks from DBartisan and usually getting the offending user to log off clears the problem up.

However I want to probe a little more via sql and after some research found that I should be able to get more info from running the utllockt.sql, which needs the catblock.sql script run to create the neccesary views. I ran the catblock.sql (as sysdba) and recieved errors, mostly grant select on <new_view> to select_catalog_role. Then after I ran the utllockt.sql I could no longer see the dba_lock view and doing a desc on dba_blockers causes sqlplus to error out and crash.

Is there something I missed here? Should I just run the scripts again?

TIA ps. I'm running 8.1.7.4 on 2000 advanced server Received on Fri Apr 11 2003 - 10:38:02 CDT