Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
Removing locks on records in an Oracle DB (UPDATED 5-29-08)
I'm a total novice when it comes to Oracle, so please don't assume I know how to do anything. Unfortunately, I'm the one who has to deal with this current problem and as far as I can tell, the only weapon at my disposal is SQL*Plus.
We use software at work that's based on an Oracle 9 DB. The software we're working with isn't letting us update a record because it says that the record is locked by a user. I've shut down the instance, rebooted the server, and killed as many sessions as possible. There don't seem to be any lingering sessions that would be hanging onto these records.
V$LOCKED_OBJECT is empty and the only remaining sessions are unkillable (SQL*Plus spits out ORA-00029, "session is not a user session" when I try to kill them... they seem to be stemming from Windows services on the server machine). There are 30+ entries in DBMS_LOCK_ALLOCATED, though I don't know anything about that table (I just randomly found it when searching for tables with "lock" in the name) and it may be a total red herring. However, the entries therein do appear to be related to our software.
So, how do I go about unlocking records? Deleting from DBMS_LOCK_ALLOCATED seems pretty cavalier, and of course it may not actually remove the lock. Thoughts?
NFA 2005 - the free, full-featured sport sim built in Excel.