Re: Resolve TM lock

From: <ramakrishna.gv_at_db.com>
Date: Wed, 22 Nov 2000 10:43:48 +0530
Message-Id: <10687.122692@fatcity.com>

--0__=JIEVt0wZRq4OMsRpf3ooGPYspA4U3LglFuZ1RsCg4ku30qnJHiopDXK7
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Shutdown the database and startup again.

or

Try to kill through alter system several times.

Then you should be able to drop the table.

Thanks & Regards

Ram
Tel:4236953

Message History ----------------------------------------

From: chuan_at_asiaonline.net on 22/11/2000 04:05 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Resolve TM lock

Hi, all

I got an error when I drop a table "ORA-00054: resource busy and acquire with NOWAIT specified".

I figure out that table was locked by a session. Therefore, I use "alter system kill session 'sid,serial#' " to kill session. Finally, that session is marked "killed".

Again, I still cannot drop that table.

Have any idea what anything I can do for this situation.

My platform is on Solaris 2.7, Oracle EE 8.1.5.

Many Thanks

Chuan

--0__=JIEVt0wZRq4OMsRpf3ooGPYspA4U3LglFuZ1RsCg4ku30qnJHiopDXK7
Content-type: text/html;

name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjMxNC4xMDAwIiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT48L1NUWUxFPg0KPC9IRUFE Pg0KPEJPRFkgYmdDb2xvcj0jZmZmZmZmPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5I aSwgYWxsPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1B cmlhbCBzaXplPTI+Jm5ic3A7IEkgZ290IGFuIGVycm9yIHdoZW4gSSBkcm9wIGEgdGFibGUgDQoi T1JBLTAwMDU0OiByZXNvdXJjZSBidXN5IGFuZCBhY3F1aXJlIHdpdGggTk9XQUlUIHNwZWNpZmll ZCIuPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1Bcmlh bCBzaXplPTI+SSBmaWd1cmUgb3V0IHRoYXQgdGFibGUgd2FzIGxvY2tlZCBieSBhIHNlc3Npb24u IA0KVGhlcmVmb3JlLCBJIHVzZSAiYWx0ZXIgc3lzdGVtIGtpbGwgc2Vzc2lvbiAnc2lkLHNlcmlh bCMnICIgdG8ga2lsbCBzZXNzaW9uLiANCkZpbmFsbHksIHRoYXQgc2Vzc2lvbiBpcyBtYXJrZWQg ImtpbGxlZCIuIDwvRk9OVD48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZh Y2U9QXJpYWwgc2l6ZT0yPkFnYWluLCBJIHN0aWxsIGNhbm5vdCBkcm9wIHRoYXQgdGFibGUuIA0K PC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBz aXplPTI+SGF2ZSBhbnkgaWRlYSB3aGF0IGFueXRoaW5nIEkgY2FuIGRvIGZvciB0aGlzIA0Kc2l0 dWF0aW9uLjwvRk9OVD48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9 QXJpYWwgc2l6ZT0yPk15IHBsYXRmb3JtIGlzIG9uIFNvbGFyaXMgMi43LCBPcmFjbGUgRUUgDQo4 LjEuNS48L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFy aWFsIHNpemU9Mj5NYW55IFRoYW5rczwvRk9OVD48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8 RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPkNodWFuPC9GT05UPjwvRElWPjwvQk9EWT48L0hU TUw+DQo= Received on Tue Nov 21 2000 - 23:13:48 CST