OraFAQ Forum: Server Administration » ORA-00054: resource busy and acquire with NOWAIT specified.

Home » RDBMS Server » Server Administration » ORA-00054: resource busy and acquire with NOWAIT specified. (Oracle 10.1.0.5.0/Hp Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00054: resource busy and acquire with NOWAIT specified. [message #302115]

Sat, 23 February 2008 13:52

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hi Everybody,

I am facing a problem while truncating a table.
please have a look onto the scenario below.

SQL> truncate table SUKANT.UIBSCDRPOSTED;
truncate table SUKANT.UIBSCDRPOSTED
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified.

SQL>select OBJECT_NAME,OBJECT_ID from dba_objects where OBJECT_NAME='UIBSCDRPOSTED' and owner='SUKANT' and OBJECT_TYPE='TABLE'

OBJECT_NAME OBJECT_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
UIBSCDRPOSTED 6615409

SQL> select SESSION_ID from v$locked_object where OBJECT_ID='6615409';

SESSION_ID
----------
722

SQL> alter system kill session '722,23807' immediate;
alter system kill session '722,23807' immediate
*
ERROR at line 1:
ORA-00031: session marked for kill

then after running the truncate, got the error message again.

SQL> truncate table dishnettest.UIBSCDRPOSTED;
truncate table dishnettest.UIBSCDRPOSTED
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

Please Help.....

Thanks

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302118 is a reply to message #302115]

Sat, 23 February 2008 14:00

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have top wait the session is rolled back.
When you kill a session its current transaction is rolled back and the locks are released after that. This may take time.
There is nothing to do but wait.

Regards
Michel

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302121 is a reply to message #302118]

Sat, 23 February 2008 14:10

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thanks a lot Michel.

I will wait.....

in the meantime, please let me know from which view can i get the password of my users in encrypted without resetting them.
Thanks

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302123 is a reply to message #302121]

Sat, 23 February 2008 14:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

DBA_USERS

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302125 is a reply to message #302115]

Sat, 23 February 2008 14:42

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

THANKS MICHEL.....

I am able to truncate the table now.
but while using the below query i am facing an error.

SQL> select username,password from dba_users where username='SUKANT';

USERNAME PASSWORD
------------------------------ ------------------------------
SUKANT 2FF2B63193FB7DB9

SQL> CONNECT SUKANT/2FF2B63193FB7DB9
ERROR:
ORA-01017: invalid username/password; logon denied

Thanks

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302126 is a reply to message #302125]

Sat, 23 February 2008 14:46

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't connect giving the encrypted password you have to give the clear one otherwise it would be useless to encrypt them.

Regards
Michel

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302127 is a reply to message #302125]

Sat, 23 February 2008 15:00

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

First of all, remember the password (talking about 2FF2B63193FB7DB9)! Then alter user in order to identify it with another password; connect using newly given credentials. Once you're over, restore the original password by

alter user this_user identified by values '2FF2B63193FB7DB9'

Report message to a moderator

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302130 is a reply to message #302115]

Sat, 23 February 2008 15:11

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thanks a lot to both of you.....

Report message to a moderator

Previous Topic:	upgrade from 9.2 to 10.2 failed. how do i downgrade and then make sure it upgrades properly next tim
Next Topic:	Patch issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:54:49 CDT 2024