OraFAQ Forum: Server Administration » SYSTEM user locked

Home » RDBMS Server » Server Administration » SYSTEM user locked

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

SYSTEM user locked [message #172158]

Mon, 15 May 2006 05:15

rafi_aamiri
Messages: 34
Registered: September 2005

Member

Hi,

In oracle 10g the SYSTEM user is getting frequently locked and shows as

SYSTEM(TIMED) -- Unlocked in the OEM.

I am unlocking and again getting locked after some time automatically.

Could you please let me know how to unlock the SYSTEM user permanently.

With Warm Regards,

A.Mohammed Rafi.

Report message to a moderator

Re: SYSTEM user locked [message #172162 is a reply to message #172158]

Mon, 15 May 2006 05:35

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Try

SQL>Alter user system account unlock;

Report message to a moderator

Re: SYSTEM user locked [message #172163 is a reply to message #172162]

Mon, 15 May 2006 05:37

rafi_aamiri
Messages: 34
Registered: September 2005

Member

But the account gets unlocked again after few minutes.

Any solution to make it unlock permanently....

Report message to a moderator

Re: SYSTEM user locked [message #172165 is a reply to message #172163]

Mon, 15 May 2006 05:38

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What platform?

Report message to a moderator

Re: SYSTEM user locked [message #172313 is a reply to message #172165]

Tue, 16 May 2006 00:08

rafi_aamiri
Messages: 34
Registered: September 2005

Member

WINDOWS XP Professional

Report message to a moderator

Re: SYSTEM user locked [message #172332 is a reply to message #172313]

Tue, 16 May 2006 01:38

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Just check the alert log file.

Report message to a moderator

Previous Topic:	Rename Logical Volume
Next Topic:	nls_characterset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:34:56 CDT 2024