Home » RDBMS Server » Server Administration » Problem with User getting locked on database startup
Problem with User getting locked on database startup [message #268057] Mon, 17 September 2007 06:50 Go to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Users are complaining that the database is locked, and when we kill the session, another lock appears. All users are unable to update in the database. We were having problems with UNDO tablespace becoming full and so increased its size, and also setup the auto extend feature to extend by 1MB. The UNDO tablespace has Extent management set to LOCAL and Segmentment management set to MANUAL. Im not sure if it is related to these changes, because these changes occured a few days ago, and the locking problem has occured today, but does anybody have any ideas or possible hints? Much appreciated.
Re: Problem with User getting locked on database startup [message #268108 is a reply to message #268057] Mon, 17 September 2007 09:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you check you alert log file??

Its a database lock or TABLE LEVEL LOCK?

Quote:
The UNDO tablespace has Extent management set to LOCAL and Segmentment management set to MANUAL.


NO its not a matter.
Re: Problem with User getting locked on database startup [message #268187 is a reply to message #268057] Mon, 17 September 2007 22:26 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You have not specified your version. After version 10.2 oracle has a feature if you sequentially failed 10 times to give password then acoount will be automatically locked. Nothing with the relation will undo.
To account your account change in your profile. If you have default one, use

alter profile default limit failed_login_attempts UNLIMITED;

Re: Problem with User getting locked on database startup [message #268352 is a reply to message #268057] Tue, 18 September 2007 05:18 Go to previous messageGo to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Thanks for the replies - we identified that one specific table was being locked, but we couldnt identify what was causing the lock. In the end we issued ALTER TABLE table_name MOVE which released the locks on the table, but we are still looking into what caused this lock in the first place.

Thanks
Yamon
Re: Problem with User getting locked on database startup [message #268389 is a reply to message #268352] Tue, 18 September 2007 07:31 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
You could have used the dba_blockers and dba_waiters views to identify the blocking and waiting sessions.
Previous Topic: Error in creating database (merged)
Next Topic: ORA-00313 and ORA-00312
Goto Forum:
  


Current Time: Tue Dec 06 14:24:42 CST 2016

Total time taken to generate the page: 0.07404 seconds