Oracle Locks - ORA00054
Most of the self-help website outthere would suggest that whenever you encounter the ORA-00054 error message; just go check the tables like DBA_BLOCKERS and the likes to weed out the root cause. Well for typical users like me, every time I run the command "select * from DBA_BLOCKERS" the only reply I get from the DB would be something like "object does not exist". Bummer. That is until I found out that you actually had to run a script for all of those "DBA lock"-related table to be created. Simply go to $ORACLE_HOME/rdbms/admin directory and run catblock.sql script. And owh yeah - you might need to have admin privileges for this to work.