Home » RDBMS Server » Server Administration » ORA-00054: resource busy and acquire with NOWAIT specified. (Oracle 10.1.0.5.0/Hp Unix)
ORA-00054: resource busy and acquire with NOWAIT specified. [message #302115] Sat, 23 February 2008 13:52 Go to next message
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

Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302118 is a reply to message #302115] Sat, 23 February 2008 14:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302121 is a reply to message #302118] Sat, 23 February 2008 14:10 Go to previous messageGo to next message
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
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302123 is a reply to message #302121] Sat, 23 February 2008 14:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DBA_USERS
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302125 is a reply to message #302115] Sat, 23 February 2008 14:42 Go to previous messageGo to next message
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
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302126 is a reply to message #302125] Sat, 23 February 2008 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302127 is a reply to message #302125] Sat, 23 February 2008 15:00 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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'
Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302130 is a reply to message #302115] Sat, 23 February 2008 15:11 Go to previous message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Thanks a lot to both of you.....
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:
  


Current Time: Sun Dec 08 19:08:12 CST 2024