OraFAQ Forum: Server Administration » Problem with User getting locked on database startup

Home » RDBMS Server » Server Administration » Problem with User getting locked on database startup

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

Problem with User getting locked on database startup [message #268057]

Mon, 17 September 2007 06:50

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.

Report message to a moderator

Re: Problem with User getting locked on database startup [message #268108 is a reply to message #268057]

Mon, 17 September 2007 09:27

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.

Report message to a moderator

Re: Problem with User getting locked on database startup [message #268187 is a reply to message #268057]

Mon, 17 September 2007 22:26

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;

Report message to a moderator

Re: Problem with User getting locked on database startup [message #268352 is a reply to message #268057]

Tue, 18 September 2007 05:18

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

Report message to a moderator

Re: Problem with User getting locked on database startup [message #268389 is a reply to message #268352]

Tue, 18 September 2007 07:31

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.

Report message to a moderator

Previous Topic:	Error in creating database (merged)
Next Topic:	ORA-00313 and ORA-00312

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 10:42:52 CDT 2024